forked from codebasics/py
-
Notifications
You must be signed in to change notification settings - Fork 0
/
Copy pathcontents.txt
48 lines (38 loc) · 908 Bytes
/
contents.txt
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
1) Intro
* what is pandas?
* what using excel/plain python not good.
* Show how pandas increase productivity
2) Dataframe basics
* What is dataframe?
* Dealing with rows and columns
* Operations: mean, max, std, describe
* Conditional selection
* set_index
3) Different ways of creating dataframe
* dictionary, tuples list, list of dictionaries, csv, excel
-) reading/writing to excel/csv: http://pbpython.com/excel-pandas-comp.html
-) Handling Missing Data
* dropna
* fillna
* isnull
* df.reindex
-) Excel Like Operations
* sort
* filter
* remove/rename columns
* .duplicated
*
-) Selection of data
* df['A'] or df.A
* df[0:3]
* df['20130102':'20130104']
* df.loc['Rain'] or df.at['Rain']
* df.iloc[3]
* df.iat[1,1]
* df[df.A > 0]
-) Merge/Concat/Join
-) Grouping
-) Reshaping/Stack/Unstack
-) Pivot Table
-) Time Series and Categoricals
-) Plotting (Bokeh?)