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.


Required packages

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


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.
Read CSV