~/talk

Introduction to Pandas

Talkat PyOhio 2014 · 2014-07-26..07-27· [data-science, python]
links:none on file
slides:none on file

Pandas provides Series and DataFrame primitives for labeled arrays, fast tabular joins and merges, and built‑in handling of missing values; the demo loads CSVs with read_csv, converts strings to datetime, sets the datetime index, resamples five‑minute windows to days, computes cumulative sums and means, and builds pivot_table views and SQL‑style joins (via SQLAlchemy or DataFrame.join). A real problem ingests ~100 vendor formats of spam feedback, pivots and fills NaNs, exports with to_csv, and visualizes results using vincent charts. It works but uses in‑memory frames and can exhaust memory.

AI-written summary · about

  1. 0:00Introduction
  2. 0:16What is Panda
  3. 2:24Getting Started
  4. 3:56Series
  5. 4:36Values
  6. 5:19Index
  7. 9:09DataFrame
  8. 11:57Grouping
  9. 12:46Grouping Multiples
  10. 13:35Naming Columns
  11. 14:11Pivot Tables
  12. 15:39Join Pivot Tables
  13. 17:34Real World Problem
  14. 21:12Indexing Date Time
  15. 22:44Missing Points
  16. 25:34Resampling
  17. 26:26Sorting
  18. 27:01Describe
  19. 28:47Vincent
  20. 30:43Questions
  21. 41:18Integrate
~/search
type to search 6,249 conferences, 138,987 speakers and 185,172 talks
~/help
cmdctrl k
search every conference, speaker and series
/
focus the filter search
h
home
c
conferences
s
speakers
e
series
t
light / dark — the status bar button does the same
?
this help
esc
close this, then clear every filter — or just the search, while you are typing in it

Ignored while you are typing. Pages without a filter rail have no search to focus.