Pandas

Introduction

• Python Pandas Tutorial: A Complete Introduction for Beginners • “Learn some of the most important pandas features for exploring, cleaning, transforming, visualizing, and learning from data” • LearnDataSci 📖
• Learn Data Science from SCRATCH (with GitHub CoPilot) • Visual Studio Code 📺

General

• DataFrame • Pandas docs 📚
• Complete Python Pandas Data Science Tutorial! (Reading CSV/Excel files, Sorting, Filtering, Groupby) • Keith Gali 📺
• Pandas code snippets • InterviewQs 📖
• Exploratory Data Analysis with Pandas • Rob Mulla 📺
• 25 Nooby Pandas Coding Mistakes You Should NEVER make • Rob Mulla 📺
• Filtering Pandas • Waylon Walker 📖
• Pandas: How to Select Rows Based on Column Values • Statology 📖
• Select rows from a Pandas DataFrame based on values in a column • InterviewQs 📖
• How do I select rows from a DataFrame based on column values? • Stack Overflow 👩‍💻
• How to filter Pandas dataframe using ‘in’ and ‘not in’ like in SQL • Stack Overflow 👩‍💻
• How to Use “NOT IN” Filter in Pandas (With Examples) • Statology 📖

Testing

• Testing • Pandas docs 📚

Editing a *.parquet file

1. Read the parquet file using pandas.read_parquet(‘some/path.parquet’), which returns a DataFrame
2. Modify the df however you need
3. Write the df to a parquet file again with df.to_parquet(‘some/path.parquet’)

Inbox