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 hereCode explanation
- Read Excel file from provided path.
- Display first rows of data.
Read data cookbook
Code recipes from Read data cookbook.