• Cursussen
  • Code Compiler
  • Discussiëren
  • Prijzen
  • Teams
Menu
0

Reading data from Excell with python

How can someone read and manipulate data from microsoft excel.

pythondataScience
28th Aug 2020, 2:54 PM
Brian Muchai
Brian Muchai - avatar
2 Antwoorden
+ 5
If you need to manipulate an excel sheet, you can use separate modules like xlwings from: https://www.xlwings.org/
28th Aug 2020, 3:21 PM
Lothar
Lothar - avatar
+ 3
Yes, use Pandas, df=pd.read_excel(PATH\FileName.xlsx) https://pandas.pydata.org/pandas-docs/stable/reference/api/pandas.read_excel.html
28th Aug 2020, 3:02 PM
Steven M
Steven M - avatar

Heb je vaak vragen zoals deze?

Leer efficiënter, gratis:

  • Inleiding tot Python

    7,1 miljoen leerlingen

  • Inleiding tot Java

    4,7 miljoen leerlingen

  • Inleiding tot C

    1,5 miljoen leerlingen

  • Inleiding tot HTML

    7,5 miljoen leerlingen

Bekijk alle cursussen
Populair vandaag
Where is the bug?
3 Votes
Pointers cpp
2 Votes
Is it possible to convert .zip file to apk? If yes, how??
1 Votes
I think the heart system is ridiculous, 5 hearts that refill after like 5 hours? That is really just crazy to me.
1 Votes
How to add two strings together in ts or css
1 Votes
Is pro worth the money ?
1 Votes
Why can’t I use double “ in python?
0 Votes
What do you think of this code and what are your suggestions for developing and modifying it?, How can I develop myself more?
0 Votes
2 cases not correct what's the problem
1 Votes
Drawing images in java
2 Votes