Conversion of xlsx to pandas DataFrame is only showng 71 columns, but I have 214 columns in xlsx file

Viewed 27

I have an xlsx file containing my personal data of business, I want to eliminate some rows from it. The xlsx file has 42 rows and 214 columns.

I am reading xlsx file with this method

df = pd.read_excel('test1.xlsx') 
df

The Python code shows only 42 rows and 71 columns (42 rows × 71 columns) in jupyter lab.

I want to show all 42 rows and 214 columns in dataFrame

How can I do this?

0 Answers
Related