open dataframe in excel in debug mode
is there a smart way to view dataframe in an external tool (excel)
i know i can export it to excel and than open, but I do it every few minutes and waste a lot of time
Please sign in to leave a comment.
In terms of code, however, it's possible to write a function or a helper script that would export your dataframes directly to XLS, and even open them in Excel after that.
For example, see https://pandas.pydata.org/docs/reference/api/pandas.DataFrame.to_excel.html