Conference Video: Kasia Rachuta - First Steps to Transition from SQL to Pandas

This is the video of Kasia Rachuta’s tech talk at WDS Puget Sound Conference 2020. Enjoy!

ABSTRACT

This talk will discuss my experiences of trying different options when wanting to use both SQL and pandas: the SQL Jupyter extension, Python SQL module, connecting to a database through Python and finally, ‘translating’ all calculations into pandas. I will touch on the advantages and disadvantages of all of these methods and I will then dive deeper into slicing and dicing pandas DataFrames, performing joins, unions, aggregations and more advanced calculations such as window functions and rolling averages. All of the calculations shown will use pandas, one of the most common data science libraries. Attendees will gain an overview of the ways of data munging and SQL plus pandas solutions, such as using the Jupyter extension, connecting to a database through Python or performing a number of operations in pandas. In particular, they will learn how to perform the most commonly used SQL functions in pandas, such as joins and unions, aggregations as well as more complicated calculations such as rolling averages or window functions.

Kasia works as a product analyst at Square; she previously worked at Medium and Fivestars. She has a master’s in theoretical physics from University College London. Kasia is entirely self-taught and learnt data science skills through a combination of online courses and internships. In her spare time, she enjoys volunteering for women-related organizations and diversity causes, scuba diving and traveling. Kasia is also a San Francisco PyLadies organizer.

Kasia works as a product analyst at Square; she previously worked at Medium and Fivestars. She has a master’s in theoretical physics from University College London. Kasia is entirely self-taught and learnt data science skills through a combination of online courses and internships. In her spare time, she enjoys volunteering for women-related organizations and diversity causes, scuba diving and traveling. Kasia is also a San Francisco PyLadies organizer.