Python Pandas For Excel webinar on vBrownBag

Katie - Aug 19 '19 - - Dev Community

Wednesday August 21, 2019, 8:30PM Eastern / 5:30PM Pacific -- I'm talking about using Python's Pandas module to edit Excel files (and other table-shaped data!) on Chris Williams's awesome "Python for DevOps" webinar series within the vBrownBag video podcast.

Register Here to get the link to participate live

mistwire image

Am I allowed to announce an upcoming speaking gig on Dev? 🤔 If it helps, this post will be the "where to find the slides & video & links" once it's done. But for now I wanted to include the registration link!

Again:

  • Wednesday August 21, 2019, 8:30PM Eastern / 5:30PM Pacific
  • Register for the link
  • (Check your spam folder -- no matter how many times I flag it as "not spam," my email provider won't listen to me.)

Can’t make it? Don’t worry – you can catch up on YouTube within a week or two.




Links

(These will make a lot more sense after the webinar, of course...)

Environment Setup

Sample Data

Pandas Tutorials

  • An anonymous StackAbuse contributor's Beginner's Tutorial on the Pandas Python Library
    • Category: Explain Programming Like I'm Five (but only the parts I care about)
    • This is my favorite link if you hate trying to program without truly understanding your "data types."
    • It does a nice "explain it like I'm five" about Pandas "DataFrames" and Pandas "Series."
    • Ready for more? Deepak "Daksh" K's Pandas DataFrame: A lightweight Intro isn't quite as "ELI5" and feels a bit more "math-class"-ey, but I still like it.
  • Bhavani Ravi's Python Pandas -- Basics to Beyond
    • Category: Quick-start, Excel-specific
    • Warning: this awesome article's CSS got messed up in the actual code samples sometime since it was published (probably during the Medium -> HackerNoon migration).If you're on a desktop computer and comfortable using the developer tools built into your browser, right-click on the black-backgrounded code snippets, click "Inspect Element," and hand-edit the CSS from line-height: 1.5; to line-height: 3; in the code[class*="language-"] section of the CSS controlling the text.
  • Chris Moffitt's Common Excel Tasks Demonstrated in Pandas, part 2 and Common Excel Tasks Demonstrated in Pandas, part 2
    • Category: Quick-start, Excel-specific
    • Chris's Practical Business Python site is a blog, so I recommend starting at the oldest posts in the archives and working your way up, since blogs tend to start basic and grow more advanced over time if you check out the rest of his material.
    • Chris also did a great episode, Escaping Excel Hell with Python and Pandas, in February 2019 on the Talk Python To me podcast. Full transcript available if you prefer over audio!
    • Chris himself has a listicle of books on his site as well.
  • Ankit Gandhi's Replacing Excel with Python
    • Category: Quick-start, Excel-specific
  • Harish Garg's Tutorial Using Excel with Python and Pandas
    • Category: Quick-start, Excel-specific
  • Kevin Markham's #PandasTricks "cool feature of the day" tweets. Ongoing on Twitter -- just started summer 2019!
    • Category: Short attention span
  • Daniel Chen's Pandas For Everyone (link 2)
    • Category: Full-on book
    • I haven't read this, but Kelly and Sean of the awesome Teaching Python podcast recommended it. You can see a big sample here if you'd like to know what his writing style is like.
  • Pete Houston's Read CSV file using pandas
    • Category: Feature tutorial
    • Mostly overkill about the read_csv() function if you've already played around, but I like that it covers handling ultra-ultra-large CSV files.
    • (Tip: When you're ready to write out your transformed "chunks" to one ultra-ultra-large CSV file, use the to_csv() function in "append" mode.)
    • Ultra-ultra-large is probably bigger than you think it is. You're going to love how much faster things run just by using Python instead of Excel without worrying about this.
  • Shane Lynn's Using iloc, loc, & ix to select rows and columns in Pandas DataFrames
    • Category: Feature tutorial
    • If you hit a wall selecting cells of a Pandas DataFrame to edit, and someone suggests you use .loc[], and you wonder what on earth that is, this article should help.
    • Also good for learning how to grab specific row numbers out of a spreadsheet.
  • Kevin Markham's Top 8 resources for learning data analysis with Pandas listicle
    • Category: Link listicle
  • My Pandas Quick Examples
    • Category: Hands-On Exercises
    • If you like to test the waters on a new skill with little "just jump in and try it" challenges, read this and try the handful of "test yourself!" exercises.
  • My Python for Excel 101 hands-on training course video.
    • Category: Explain Programming Like I'm Five (but only the parts I care about)
    • A 2.5-hour video is probably not the fastest way to learn Pandas, but if you're new to programming, this might be useful.
    • We really dig into data types, DataFrames, Series, etc. -- but only as they pertain to getting you up and running with Pandas for spreadsheet editing.
    • It says it's "for Salesforce administrators," but that's just who my audience was that particular day.

Pandas References

General-Purpose Python Tutorials & References

Misc

. . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . .