Can you give a command which will fetch and store column information from an excel file in python?? | Sololearn: Learn to code for FREE!
New course! Every coder should learn Generative AI!
Try a free lesson
0

Can you give a command which will fetch and store column information from an excel file in python??

Urgent

28th Jun 2021, 7:44 PM
Sourya Banerjee
Sourya Banerjee - avatar
7 Answers
+ 4
there are a couple modules you can use. i normally use pandas. the code would looke something like this: imports pandas as pd filepath=r”c:\path\to\file.xlsx” df = pd.read_excel(filepath) print(df[column])
28th Jun 2021, 8:03 PM
you are smart. you are brave.
you are smart. you are brave. - avatar
0
Maybe you can search the web.
28th Jun 2021, 7:45 PM
Ithiel😎
Ithiel😎 - avatar
0
Unable to find.... that's why asking
28th Jun 2021, 7:53 PM
Sourya Banerjee
Sourya Banerjee - avatar
0
That depends on how your excel files are stored. Or you can use numpy.
28th Jun 2021, 8:00 PM
Slick
Slick - avatar
0
Not working
28th Jun 2021, 9:20 PM
Sourya Banerjee
Sourya Banerjee - avatar
0
would you mind sharing your code? it is difficult to provide guidance without seeing it.
29th Jun 2021, 12:22 AM
you are smart. you are brave.
you are smart. you are brave. - avatar
- 2
Then how about you look up pandas online and figure it out bud?
28th Jun 2021, 9:22 PM
Slick
Slick - avatar