Convert an Excel range into a Jupyter Notebooks
Last updated
Last updated
Use this feature to create a Jupyter notebook from your selected cell range. When you click the button, a notebook is generated in your workbook’s directory, containing the code to load the selected Excel range directly into a Pandas DataFrame. The code specifies the workbook path, sheet name, columns, and rows, as well as how many rows to skip or include.
There are also additional settings available (see image below):
Copy Python Code: Copy the generated Python code to your clipboard instead of creating a Jupyter notebook. Useful if you already have a Python file or Jupyter notebook.
Use Absolute Path: Choose to use an absolute file path instead of a relative one.
Ignore Row Parsing: This option is helpful if you expect new data to be added to your Excel file, as it will automatically expand to include the last row/cell.
Change DataFrame Name: Set a custom name for your DataFrame variable (default is "df").
