How to read csv file and excel file python?

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](https://stackoverflow.com/questions/17063458/reading-an-excel-file-in-python-using-pandas) — snipsnipsnip, Nov 06 '18 at 09:36

score 2 · Answer 1 · answered Nov 06 '18 at 09:32

2

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

answered Nov 06 '18 at 09:32

Mayank Porwal

score 1 · Answer 2 · answered Nov 06 '18 at 09:32

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 06 '18 at 09:32

dejanmarich

score 1 · Answer 3 · answered Nov 06 '18 at 09:34

1

answered Nov 06 '18 at 09:34

iz_

score 0 · Accepted Answer · answered Nov 06 '18 at 09:45

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 06 '18 at 09:45

Abhinav Vajpeyi

4 Answers4