How to read csv file and excel file python? [closed]

Question

Closed. This question needs to be more focused. It is not currently accepting answers.

Want to improve this question? Guide the asker to update the question so it focuses on a single, specific problem. Narrowing the question will help others answer the question concisely. You may edit the question if you feel you can improve it yourself. If edited, the question will be reviewed and might be reopened.

Closed 7 years ago.

Improve this question

What is the syntax of reading file ,writing file in python.and How to read csv file and excel file in DataFrames(pandas).

Possible duplicate of Reading an Excel file in python using pandas — snipsnipsnip
– snipsnipsnip, Commented Nov 6, 2018 at 9:36

Mayank Porwal · Accepted Answer · 2018-11-06 09:32:56Z

2

   df = pd.read_csv('myfile.csv')
   df = pd.read_excel('myfile.xlsx')

answered Nov 6, 2018 at 9:32

Mayank Porwal

34.2k9 gold badges45 silver badges65 bronze badges

Sign up to request clarification or add additional context in comments.

Comments

dejanmarich · Accepted Answer · 2018-11-06 09:32:40Z

1

To read:

df = pd.read_excel('filename.xlsx')
df = pd.read_csv('filename.csv')

To write:

df.to_csv('filename.csv')
df.to_excel('filename.xlsx')

if you just googled "pandas read excel"..

answered Nov 6, 2018 at 9:32

dejanmarich

1,30512 silver badges26 bronze badges

Comments

iz_ · Accepted Answer · 2018-11-06 09:34:18Z

1

See pandas.read_excel() for Excel and pandas.read_csv() for CSV files.

answered Nov 6, 2018 at 9:34

iz_

16.7k4 gold badges29 silver badges43 bronze badges

Comments

The_Scan_Master · Accepted Answer · 2018-11-06 09:45:45Z

0

import pandas as pd
df=pd.read_csv('file_name.csv')

this will result into Dataframe.If you want to read a specific column and want output as series.

df=pd.read_csv('file_name.csv',usecols=['col_name'],squeeze=True)

answered Nov 6, 2018 at 9:45

The_Scan_Master

1461 silver badge6 bronze badges

Collectives™ on Stack Overflow

How to read csv file and excel file python? [closed]

4 Answers 4

Comments

Comments

Comments

Comments

Hot Network Questions