Python in Excel! Part 2 - Organization
Following on from yesterday's video and the HUGE news about Python in Excel, here's another video showing a little more of how it works, some thoughts I had about organization and another taster of some data cleaning and analysis that this feature enables.
Main takeaways:
1. Row Major Order includes spreadsheet position - Python code is executed left-to-right on your spreadsheets. This means it's a good idea to put your imports and any function definitions on the first spreadsheet in your Workbook.
2. Currently, importing data from external sources is not supported, though this will be possible via Power Query in the future.
3. The currently supported libraries are as shown below, as well as their "related and dependent libraries". This is important. Remember, several of these are imported by default. But not all.
Library: json; Imported by default: No
Library: matplotlib; Imported by default: Partially; Imported as: .pyplot as plt Library: numpy; Imported by default: Yes; Imported as: np
Library: pandas; Imported by default: Yes; Imported as: pd
Library: scikit-learn; Imported by default: No
Library: scipy; Imported by default: No
Library: seaborn; Imported by default: Yes; Imported as: sns
Library: statsmodels; Imported by default: Yes; Imported as: sm
Library: regex; Imported by default: No
4. The last statement in a Python cell is the value for that cell. So, if you want to display some custom text to help you stay organized, consider making a string the last statement in the cell. See the video for other examples.
5. In the video, I mention that the print function is not needed. This is true in the cell itself, but if you use print("Message") in a cell, the value "Message" will be printed to the Diagnostics pane (found via the Python group in the Formula Ribbon).
Again, another shortish video and I'll make more in the coming days.
Please like, share and subscribe to stay notified of new videos about Python in Excel.
What are you thinking about Python in Excel now that you've no doubt read and watched content from several people? 💬
Auf dieser Seite können Sie das Online-Video Python in Excel! Part 2 - Organization mit der Dauer stunde minuten sekunde in guter Qualität ansehen, das der Benutzer flexyourdata 23 August 2023 hochgeladen hat, den Link mit Freunden und Bekannten teilen, dieses Video wurde auf Youtube bereits 14,709 Mal angesehen und es wurde von 273 den Zuschauern gefallen. Viel Spaß beim Betrachtenden Zuschauern gefallen!
