Data analysis by topic
33 posts about working with data in Python — Pandas, SQL, and Jupyter — organized by topic.
Pandas
21 posts on pandas. Most recent:
- Free real-world Pandas exercises, with solutions
- New: In-browser Python/Pandas/Git exercises, with AI support
- What’s new in Pandas 3?
- Pandas Series and DataFrame methods: same names, column-wise results
- Reading multi-sheet Excel files in Pandas with sheet_name
- Pandas memory usage: Why you need deep=True for text columns
- Pandas read_csv accepts a URL: Loading remote data files
- Saving a Pandas plot to a file with get_figure and savefig
- Pandas datetime index slicing: sort_index to avoid a KeyError
- Pandas nlargest: Finding top rows faster than sort_values
- Pandas column arguments: Where one name works, a list does too
- Pandas sort_values: Sorting a data frame by multiple columns
- Pandas select_dtypes: Selecting columns by their dtype
- Jupyter memory usage: Why del doesn’t free your DataFrame
- Your personal mentor for Python and Pandas
PostgreSQL & SQL
10 posts on postgresql & sql. Most recent:
- Using regexps in PostgreSQL
- In PostgreSQL, as in life, don’t wait too long to commit
- Want to understand Python’s comprehensions? Think in Excel or SQL.
- Remember: Don’t mix = and NULL
- Turning a PostgreSQL array to rows
- Turning PostgreSQL rows into arrays
- Looking in PostgreSQL arrays with ANY
- PostgreSQL array indexes and length
- Learning to love PostgreSQL arrays
- Don’t use double quotes in PostgreSQL
Jupyter & notebooks
3 posts on jupyter & notebooks. Most recent: