How to read excel file program in python

How to read Excel files using Python? Import the Pandas library. Use the pd.read_excel() function to load the Excel file. View file contents: df.head(). Access a specific sheet: df = pd.read_excel('path/to/excel_file.xlsx', sheet_name='Sheet1'). Access a specific cell: value = df.iloc[row_index, column_index]. Iterate over rows and columns: for row in df.iterrows(). Save changes: df.to

How to read Excel files using Python

Import the necessary libraries

First, you need to import the Pandas library to read the Excel file:

import pandas as pd

Load the Excel file

Use pd. read_excel() Function loads Excel file:

df = pd.read_excel('path/to/excel_file.xlsx')

where path/to/excel_file.xlsx is the path of the Excel file to be loaded.

View file contents

To view the first five lines of a loaded file:

df.head()

Access specific tables and cells

If you have multiple worksheets, you can use the sheet_name parameter to specify the worksheet to read:

df = pd.read_excel('path/to/excel_file.xlsx', sheet_name='Sheet1')

To access a specific cell, you can use iloc or loc Function:

value = df.iloc[row_index, column_index]

or

value = df.loc[row_label, column_label]

Iterate over rows and columns

You can use Pandas' Iterator to iterate over rows and columns:

for row in df.iterrows():
    # row 是一个元组，包含行索引和行数据
    print(row)

for col in df.itercols():
    # col 是一个元组，包含列名和列数据
    print(col)

Save changes

If changes are made to the file, you can use the to_excel() function to save the changes :

df.to_excel('path/to/output_file.xlsx')

The above is the detailed content of How to read excel file program in python. For more information, please follow other related articles on the PHP Chinese website!