Read data

Read Excel in Python

Load Excel file into Pandas DataFrame. Please check Advanced settings. You can select Sheet by name or by integer index, which is zero-indexed. You can also specify number of rows to skip when file reading.

Please check pandas.read_excel for more parameters.

excelspreadsheetpandas

Required packages

You need below packages to use the code generated by recipe. All packages are automatically installed in MLJAR Studio.

pandas>=1.0.0

Interactive recipe

You can use below interactive recipe to generate code. This recipe is available in MLJAR Studio.

Python code

# Python code will be here

Code explanation

  1. Read Excel file from provided path.
  2. Display first rows of data.
« Previous
Read CSV
Next »
Read XML