Convert an Excel ranges into Pandas DataFrames
Last updated
Last updated
Use this feature to convert a selected Excel range into a Pandas DataFrame. When you click the button, a Python file (with the current workbook’s name) is generated in your workbook’s directory. The Python file contains code to load the selected Excel range directly into a Pandas DataFrame. It includes 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 saving it to a Python file. Useful if you want to integrate it into an existing Python script.
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 more data to be added, 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").
