Section 4: Advanced series functionality
Section 4: Advanced series functionality
Table of contents
Section 1: Introduction
Section 1: Introduction
Draft
Pandas, part 1 -- introduction.ipynb
Draft
1 Introduction.mov
Draft
2 what-is-pandas.mov
Draft
3 Installing Pandas.mp4
Draft
4 Loading Pandas into Jupyter.mp4
Section 2: Series
Section 2: Series
Draft
Pandas, part 2 -- series.ipynb
Draft
5 Creating a series.mp4
Draft
6 Creating a series with NumPy.mp4
Draft
7 Setting and retrieving with indexes.mp4
Draft
8 Retrieving with loc and iloc.mp4
Draft
9 Setting the index.mp4
Draft
10 Non-unique indexes.mp4
Draft
10a Fancy indexing.mp4
Draft
11 Basic methods.mp4
Draft
12 Operations by index.mp4
Draft
13 Broadcasting operators.mp4
Draft
14 Boolean indexing.mp4
Draft
15 Exercises 1.mp4
Draft
exercise-1.txt
Draft
16 Exercise solutions 1.mp4
Section 3: dtypes and NaN
Section 3: dtypes and NaN
Draft
Pandas, part 3 -- dtypes and NaN.ipynb
Draft
17 dtypes.mp4
Draft
18 assigning to dtypes.mp4
Draft
19 Using astype.mp4
Draft
20 NaN.mp4
Draft
20a Skipping NaN.mp4
Draft
21 dropna and fillna.mp4
Draft
22 fill_value.mp4
Draft
23 Exercises 2.mp4
Draft
exercise-2.txt
Draft
24 Exercise solutions 2.mp4
Section 4: Advanced series functionality
Section 4: Advanced series functionality
Draft
Pandas, part 4 -- advanced series.ipynb
Draft
25 size and count.mp4
Draft
26 median and quantiles.mp4
Draft
27 describe.mp4
Draft
28 describe with non-numeric data.mp4
Draft
29 head and tail.mp4
Draft
30 value_counts.mp4
Draft
31 duplicated.mp4
Draft
32 replace.mp4
Draft
33 Sorting.mp4
Draft
34 apply.mp4
Draft
35 Exercises 3.mp4
Draft
exercise-3.txt
Draft
36 Exercise solutions 3.mp4
Section 5: Strings
Section 5: Strings
Draft
Pandas, part 5 -- Strings.ipynb
Draft
37 Strings in Pandas vs NumPy.mp4
Draft
38 String methods and the "str" object.mp4
Draft
39 Finding numbers.mp4
Draft
40 startswith and endswith.mp4
Draft
41 [] and strings.mp4
Draft
42 str.contains.mp4
Draft
43 find and index.mp4
Draft
44 Modifying data.mp4
Draft
45 Splitting and reusing str.mp4
Draft
46 Exercises 4.mp4
Draft
exercise-4.txt
Draft
47 Exercise 4 solutions.mp4
Section 6: Plotting series
Section 6: Plotting series
Draft
Pandas, part 6 -- plotting.ipynb
Draft
48 Simple plots with matplotlib.mp4
Draft
49 More sophisticated plotting with Matplotlib.mp4
Draft
50 Line plots via pandas.mp4
Draft
51 Bar plots with pandas.mp4
Draft
52 Histograms.mp4
Draft
53 Pie plots.mp4
Draft
54 Box plots.mp4
Draft
55 Exercises 5.mp4
Draft
exercise-5.txt
Draft
56 Exercise 5 solutions.mp4
Section 7: Data frames
Section 7: Data frames
Draft
Pandas, part 7 -- data frames.ipynb
Draft
57 Data frame introduction.mp4
Draft
58 Index and columns -- simple retrievals.mp4
Draft
58a Dot syntax for column retrieval.mp4
Draft
59 Setting the index and columns.mp4
Draft
60 Retrieving an individual value.mp4
Draft
61 Creating data frames from NumPy arrays.mp4
Draft
62 Creating data frames from a list of dicts.mp4
Draft
63 Creating data frames from a dict of lists, arrays, or series.mp4
Draft
64 Methods on columns.mp4
Draft
65 Methods on an entire data frame.mp4
Draft
66 Retrieving multiple columns.mp4
Draft
67 Retrieving multiple rows.mp4
Draft
68 Updating values in a data frame.mp4
Draft
68a Using "describe" on data frames.mp4
Draft
69 Exercises 6.mp4
Draft
exercise-6.txt
Draft
70 Exercise solutions 6.mp4
Section 8: Boolean indexes and data frames
Section 8: Boolean indexes and data frames
Draft
71 Boolean indexes on a column.mp4
Draft
Pandas, part 8 -- boolean indexes and data frames.ipynb
Draft
72 Applying boolean indexes to other columns.mp4
Draft
73 Complex queries across columns.mp4
Draft
74 Applying a boolean index to an entire data frame.mp4
Draft
75 Assigning to data frames -- recap.mp4
Draft
76 Assigning to multiple rows and columns with loc.mp4
Draft
77 Assigning to a column based on a boolean index.mp4
Draft
78 Chained assignment -- what it is, and how to avoid it.mp4
Draft
79 Data frame assignment example.mp4
Draft
80 Assigning a scalar value to a data frame, based on a condition.mp4
Draft
81 Assigning a vector value to a data frame, based on a condition.mp4
Draft
82 Using df.replace to replace values across a data frame.mp4
Draft
82a Using isna, dropna, and fillna with data frames.mp4
Draft
82a Using isna, dropna, and fillna with data frames.mp4
Draft
83 Using mask and where .mp4
Draft
84 Using clip.mp4
Draft
68e Dropping one or more rows.mp4
Draft
68f Dropping one or more columns.mp4
Draft
85 Exercises 7.mp4
Draft
68d Updating values in rows and adding rows.mp4
Draft
exercise-7.txt
Draft
68c Adding columns.mp4
Draft
86 Exercise solutions 7.mp4
Draft
68b Updating a column.mp4
Draft
85 Exercises 7.mp4
Draft
68a Using "describe" on data frames.mp4
Draft
86 Exercise solutions 7.mp4
Section 9: Pandas and I/O — reading and writing files
Section 9: Pandas and I/O — reading and writing files
Draft
Pandas, part 9 -- input and output.ipynb
Draft
87 Pandas and IO -- and saving to the clipboard.mp4
Draft
88 Saving to CSV.mp4
Draft
89 Changing the CSV separator.mp4
Draft
90 NaN representation.mp4
Draft
91 Choosing output columns.mp4
Draft
92 Writing row and column names.mp4
Draft
93 Saving with compression.mp4
Draft
94 Reading CSV files.mp4
Draft
95 Choosing and ignoring header rows.mp4
Draft
96 Naming columns.mp4
Draft
97 Choosing columns.mp4
Draft
98 Choosing + naming.mp4
Draft
99 Reading NaN values.mp4
Draft
100 dtype hints when reading CSV.mp4
Draft
101 Reading from the network.mp4
Draft
102 Exercises 8.mp4
Draft
exercise-8.txt
Draft
103 Exercise 8 solutions.mp4
Draft
104 Excel files.mp4
Draft
105 JSON files.mp4
Draft
106 SQL databases.mp4
Section 10: Data analysis with Pandas
Section 10: Data analysis with Pandas
Draft
Pandas, part 10 -- analysis of real-world data.ipynb
Draft
flight-delays.zip
Draft
taxi.csv
Draft
107 Analysis of taxi data.mp4
Draft
108 Taxi data part 2.mp4
Draft
109 Taxi data part 3.mp4
Draft
110 Taxi data part 4.mp4
Draft
111 Taxi data part 5.mp4
Draft
112 Taxi data part 6.mp4
Draft
113 Exercises 9.mp4
Draft
114 Exercise 9 solutions.mp4
Section 11: Memory management and categories
Section 11: Memory management and categories
Draft
Pandas, part 11 -- Memory management and categories.ipynb
Draft
115 Data frames and memory usage.mp4
Draft
116 Memory usage in series and data frames.mp4
Draft
117 Categories.mp4
Draft
118 Setting dtypes upon load.mp4
Draft
119 Predefining categories.mp4
Draft
120 Avoiding low-memory warnings.mp4
Draft
exercise-10.txt
Draft
airlines.dat
Draft
121 Exercises 10.mp4
Draft
122 Exercise solutions 10.mp4
Section 12: Indexes and multi-indexes
Section 12: Indexes and multi-indexes
Draft
Pandas, part 12 -- indexes.ipynb
Draft
123 set_index and reset_index.mp4
Draft
124 multi-indexes on series.mp4
Draft
125 multi-indexes on data frames.mp4
Draft
126 stack and unstack.mp4
Draft
127 swaplevel.mp4
Draft
128 Exercises 11.mp4
Draft
exercise-11.txt
Draft
129 Exercise solutions 11.mp4
Draft
college.csv
Section 13: Sorting, merging, and grouping
Section 13: Sorting, merging, and grouping
Draft
Pandas, part 13 -- sorting, joining, merging, and grouping.ipynb
Draft
reuven_travel.csv
Draft
oecd_locations.csv
Draft
phonecodes.json
Draft
oecd_tourist_spending.csv
Draft
weather.zip
Draft
130 sort_index.mp4
Draft
131 sort_values.mp4
Draft
132 concatenating data frames.mp4
Draft
133 concatenating different data frames.mp4
Draft
134 Inner and outer joins.mp4
Draft
135 merging -- inner, left, right, and outer.mp4
Draft
136 groupby.mp4
Draft
137 pivot tables.mp4
Draft
138 Exercises 12.mp4
Draft
exercise-12.txt
Draft
139 Exercise solutions 12.mp4
Section 14: Plotting data frames
Section 14: Plotting data frames
Draft
140 Plotting data frames.mp4
Draft
141 Bar plots.mp4
Draft
142 Stacked bar plots.mp4
Draft
143 Histograms.mp4
Draft
144 Pie plots.mp4
Draft
145 Box plots.mp4
Draft
146 Scatter plots.mp4
Draft
147 Scatter plots and colormaps.mp4
Draft
148 Scatter matrix.mp4
Draft
149 Exercises 13.mp4
Draft
150 Exercise 13 solutions.mp4
Draft
exercise-13.txt
Draft
Pandas, part 14 -- plotting.ipynb
Welcome!
Enter your info below to login.