Python pandas read_excel

Pandas read excel

import pandas as pd
pd.read_excel('tmp.xlsx’, sheet_name='Sheet1')

Pandas read excel

import pandas as pd
pd.read_excel('tmp.xlsx', index_col=0)

Pd.read_excel column data type

import pandas as pd

df = pd.read_excel('Book1.xlsx',sheetname='Sheet1',header=0,converters={'names':str,'ages':str})
>>> df
       names ages
   0   bob   05
   1   tom   4
   2   suzy  3

Source: stackoverflow.com

Python pandas read_excel

#You will need the package openpyxl to use the .read_excel function.
# pip install openpyxl
import pandas as pd
inFile = "Table.xlsx"
inSheetName = "Sheet1"
pd.read_excel(inFile, sheet_name = inSheetName)

-1

Similar codes

5 votes184 views3 answers
Object to int64 pandas
Python
5 votes204 views3 answers
Python datetime last day of month
Python
0 vote270 views1 answer
Pil normalize image
Python
0 vote191 views1 answer
Opencv write text
Python
11 votes186 views6 answers
How to check the size of a file in python
Python
2 votes146 views2 answers
Python install docx
Python
8 votes229 views2 answers
How to earse special chrat¥cter from string in python
Python
2 votes187 views1 answer
Selenium zoom out python
Python
1 vote277 views2 answers
Join two querysets django
Python
0 vote201 views1 answer
How to vonvert 1 d list to 2d list in pytohn
Python