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

1 vote117 views2 answers
Pydictionary
Python
3 votes104 views2 answers
Enum
Python
0 vote186 views1 answer
Python 3 define type in arguments with default value
Python
-1 vote113 views1 answer
How to make an action repeat in python
Python
0 vote141 views1 answer
Django sesssion can't works when web app call inside an iframe from other website
Python Django
72 votes111 views5 answers
How to run for loop in python
Python
12 votes108 views5 answers
Check if item exists in list python
Python
0 vote124 views3 answers
How to take a screenshot using python
Python
2 votes116 views2 answers
Check multiple keys in python dict
Python
0 vote139 views1 answer
Django querset group by sum
Python Django