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

3 votes315 views2 answers
Remove duplicates from sorted array
Python
3 votes316 views1 answer
Find unique char in string python
Python
4 votes328 views2 answers
Compare multiple columns in pandas
Python
8 votes313 views3 answers
Subtract one list from another python
Python
0 vote372 views1 answer
For loop in django template css
Python Django
12 votes299 views3 answers
Delete all files in a directory python
Python
0 vote364 views1 answer
Or operator in django queryset
Python Django
4 votes312 views4 answers
Jupyter lab autocomplete
Python
0 vote320 views1 answer
How to duplicate a row in python
Python
9 votes262 views1 answer
Python set exercises
Python