To read an Excel file using Python pandas we can make use of the read_excel() method, this will return the Excel data in tabular form as a dataframe.
Microsoft Excel file: data.xlsx
![Excel xlsx file to be read using Python Pandas Excel xlsx file to be read using Python Pandas](https://code2care.org/howto/pandas-reading-xlsx-xls-excel-files/images/Excel xlsx file to be read using Python Pandas.jpg)
Example:
import pandas as pd
excel_file = 'data.xlsx'
dataframe = pd.read_excel(excel_file)
print(dataframe.head())
Output:
% python3 example.py
Date Temp
0 2023-01-01 22
1 2023-02-01 22
2 2023-03-01 21
3 2023-04-01 20
4 2023-05-01 19
Facing issues? Have Questions? Post them here! I am happy to answer!
Author Info:
Rakesh (He/Him) has over 14+ years of experience in Web and Application development. He is the author of insightful How-To articles for Code2care.
Follow him on: X
You can also reach out to him via e-mail: rakesh@code2care.org
More Posts related to Python,
- How to convert int to ASCII in Python
- How to make use of SQLite Module in Python?
- Split a String into Sub-string and Parse in Python
- Python: Pandas Rename Columns with List Example
- How to run Python file from Mac Terminal
- How to Exit a Loop in Python Code
- Python: How to Plot a Histogram using Matplotlib and data as list
- MD5 Hashing in Python
- Jupyter: Safari Cant Connect to the Server localhost:8888/tree
- Fix: AttributeError: str object has no attribute decode. Did you mean: encode?[Python]
- How to Read a binary File with Python
- How to add two float numbers in Python
- Python: How to install YAML Package
- Python: How to Save Image from URL
- What is Markdown in Jupyter Notebook with Examples
- How to change the Python Default version
- 33: Python Program to send an email vid GMail
- How to comment code in Python
- How to Fix AttributeError in Python
- Fix: error: Jupyter command `jupyter-nbconvert` not found [VSCode]
- How to comment out a block of code in Python
- List of All 35 Reserved Keywords in Python Programming Language 3.11
- Import Other Python Files Examples
- Python: How to add Progress Bar in Console with Examples
- 3 Ways to convert bytes to String in Python
More Posts:
- How to Search Maven Central Repository - HowTos
- How to Select Two Separate Columns in Excel on Mac - Microsoft
- How to create a tar.gz file using Java - Java
- How to Concatenate Strings in Bash Scripting - Bash
- 'Edit Document' Requires a Windows Sharepoint Services-compatible application and Microsoft Internet Explorer 6.0 or higher - SharePoint
- Bash: Command to Find the Length of a String - Bash
- Twitter is down? Issues with Tweet create events affecting APIs - Twitter
- Python: How to Save Image from URL - Python