#pandas

• 25 Apr 2024 · Study

  Matplotlib · Mini EDA project

  A small end-to-end exploratory analysis of the Palmer Penguins dataset with pandas and Seaborn: shape, missing values, distributions, groups and relationships.

• 27 Mar 2024 · Study

  Pandas · Time series

  DatetimeIndex, date_range, the .dt accessor, resampling to weekly or monthly, rolling windows and shift.

• 25 Mar 2024 · Study

  Pandas · pivot_table

  Reshaping between long and wide formats with pivot_table, melt and crosstab, including margins and fill_value.

• 21 Mar 2024 · Study

  Pandas · merge and join

  SQL-style joins with merge (inner, left, right, outer), the indicator flag, validate, and stacking with concat.

• 18 Mar 2024 · Study

  Pandas · groupby

  Split-apply-combine with groupby: aggregations, named agg, multiple keys, transform vs agg, and filter.

• 14 Mar 2024 · Study

  Pandas · Missing data

  Detecting NaN with isna, counting missing values per column, dropna vs fillna, filling with group means, and interpolation.

• 12 Mar 2024 · Study

  Pandas · Cleaning data

  Fixing messy columns: stripping and normalising strings, converting types with to_numeric, renaming, dropping duplicates and mapping categories.

• 7 Mar 2024 · Study

  Pandas · Selection with loc and iloc

  Label-based loc versus position-based iloc, boolean filtering, query(), and avoiding chained assignment.

• 5 Mar 2024 · Study

  Pandas · Reading and writing files

  read_csv and to_csv with the parameters that matter (sep, usecols, dtype, parse_dates, index=False), plus JSON and Parquet.

• 1 Mar 2024 · Study

  Pandas · Series and DataFrame

  Series (a labelled 1-D array) and DataFrame (a table of Series sharing an index), and how index alignment works.