Can you give a command which will fetch and store column information from an excel file in python?? | Sololearn: Learn to code for FREE!

0

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

6/28/2021 7:44:16 PM

Sourya Banerjee

7 Answers

New Answer

+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])

0

Maybe you can search the web.

0

Unable to find.... that's why asking

0

That depends on how your excel files are stored. Or you can use numpy.

0

Not working

0

would you mind sharing your code? it is difficult to provide guidance without seeing it.

-2

Then how about you look up pandas online and figure it out bud?