Long long ago, in a galaxy far far away, there lived pandas traveling space. They were peaceful explorers and skilled data scientists. The pandas would venture to the stars in their spaceships to discover planets full of data, to analyze and plot that data, and find new tastes of bamboo no creature had tasted before.

This is a Python tutorial featuring the pandas library. It focuses on the technical basics of Data Science – working with tabular data. On the way, you will help the pandas explore space.

Contents

• Preparations
• Read and Write Data
• Inspect DataFrames
• Select Rows and Columns
• Data Wrangling
• High-Quality Plots
• Descriptive Statistics
• Pivot Tables
• Edit columns
• String Handling
• Time Series
• Plotting Maps
• Create DataFrames and Series
• Long vs Wide Format
• Aggregation
• The Duck Archives
• Dashboard
• Hall of Fame
• Links

Challenges

• Powerful Pivots
• Read Baby Name Data
• Timelines of Baby Names
• Last Letters
• Climate Stripes
• Plotting Titanic Data
• Life Expectancy Animation
• Penguin Dashboard
• PageRank

Image Sources

Most images for this tutorial were created with the generative neural networks hotpot.ai and deepai.org .

The spaceship logo was purchased from thenounproject.com

License

© 2023 Kristian Rother

Unless stated otherwise, the content of this tutorial may be used under the conditions of the Creative Commons Attribution Share-Alike License 4.0 (CC-BY-SA 4.0). See creativecommons.org .

Acknowledgements

I would like to thank the following people for inspiring exchange on training and Python that this material has benefited from: Jasmin Touati, Veit Schiele, Dinu Gherman, Pedro Fernandes, Tomasz Puton, Edward Jenkins, Bernard Szlachta, Robert Lehmann, Allegra Via, Kaja Milanowska, Anna Philips, Paul Wlodkowski, Tom Gadsby, Stefan Roth, Gesa Johannsen, Ugur Ural, Malte Bonart, Paula Gonzalez, Samuel McGuire, Sara Maras, Carmine Somma, Kiran Challa, Dina Deifallah, Marija Vlajic, Emely Henninger and Magdalena Rother.