Pandas is not a replacement for Excel. More...

Variables
string	excel_file = 'movies.xls'

	movies = pd.read_excel(excel_file)

	movies_sheet1 = pd.read_excel(excel_file, sheet_name=0, index_col=0)

	xlsx = pd.ExcelFile(excel_file)

list	movies_sheets = []

	sorted_by_gross = movies.sort_values(['Gross Earnings'], ascending=False)

	kind

Detailed Description

Pandas is not a replacement for Excel.

Both tools have their place in the data analysis workflow and can be very great companion tools.

As we will demonstrate, pandas can do a lot of complex data analysis and manipulations, which depending on your need and expertise, can go beyond what you can achieve, if you are just using Excel.

One of the major benefits of using Python and pandas over Excel is that it helps you automate Excel file processing by writing scripts and integrating with your automated data workflow.

Pandas also has excellent methods for reading all kinds of data from Excel files. You can export your results from pandas back to Excel too, if that’s preferred by your intended audience.

On the other hand, Excel is a such a widely used data tool, it’s not a wise to ignore it. Acquiring expertise in both pandas and Excel and making them work together gives you skills that can help you stand out in your organization.

Author: Paulo Roma

Since: 05/11/2021

See also: https://www.dataquest.io/blog/excel-and-pandas/

Variable Documentation

◆ excel_file

string movies.excel_file = 'movies.xls'

◆ kind

movies.kind

◆ movies

movies.movies = pd.read_excel(excel_file)

◆ movies_sheet1

movies.movies_sheet1 = pd.read_excel(excel_file, sheet_name=0, index_col=0)

◆ movies_sheets

list movies.movies_sheets = []

◆ sorted_by_gross

movies.sorted_by_gross = movies.sort_values(['Gross Earnings'], ascending=False)

◆ xlsx

movies.xlsx = pd.ExcelFile(excel_file)

Variables