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:

<code class="python">import pandas as pd</code>

Load the Excel file

Use pd. read_excel() Function loads Excel file:

<code class="python">df = pd.read_excel('path/to/excel_file.xlsx')</code>

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:

<code class="python">df.head()</code>

Access specific tables and cells

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

<code class="python">df = pd.read_excel('path/to/excel_file.xlsx', sheet_name='Sheet1')</code>

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

<code class="python">value = df.iloc[row_index, column_index]</code>

or

<code class="python">value = df.loc[row_label, column_label]</code>

Iterate over rows and columns

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

<code class="python">for row in df.iterrows():
    # row 是一个元组，包含行索引和行数据
    print(row)

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

Save changes

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

<code class="python">df.to_excel('path/to/output_file.xlsx')</code>

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!