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)

Read excel into dataframe python

import pandas as pd

sheet1, sheet2 = None, None
with pd.ExcelFile("PATH\FileName.xlsx") as reader:
    sheet1 = pd.read_excel(reader, sheet_name='Sheet1')
    sheet2 = pd.read_excel(reader, sheet_name='Sheet2')

Source: stackoverflow.com

Find data in sheet pandas

import pandas
df = pandas.DataFrame()
df[df.text_column.str.contains('whatever')] #to replace ctrl+f in pandas

Pandas read excel

import pandas as pd

data = pd.read_excel (r'C:\Users\Ron\Desktop\Product List.xlsx') 
df = pd.DataFrame(data, columns= ['Product'])
print (df)

Source: datatofish.com

Set header in dataframe 2nd line

In [23]: df.columns = df.iloc[1]

Source: stackoverflow.com

Similar codes

0 vote156 views2 answers
Message: 'geckodriver' executable needs to be in PATH.
Python
0 vote146 views1 answer
Create dataframe pyspark
Python
0 vote149 views1 answer
Nornir config file
Python
18 votes162 views6 answers
Pd.set_option('display.max_columns' none)
Python
0 vote148 views1 answer
How to set default user group in django
Python
0 vote154 views2 answers
Is not and != difference in python
Python
1 vote166 views2 answers
Tensor vs numpy array
Python
0 vote159 views6 answers
Python list of difference beetwen values in list
Python
1 vote152 views2 answers
How to print out text in python
Python
0 vote145 views2 answers
Python convert long floats to usd
Python