python数据分析

一.

1.用python读取JSON数据

path = 'usagov_bitly_data2012-03-16-1331923249.txt'
open(path).readline()

2.用json库将JSON数据转换为python对象

import json
path = 'usagov_bitly_data2012-03-16-1331923249.txt' 
records = [json.loads(line) for line in open(path)]
records[0]

3. pandas.Series.plot（）画图

plot的参数见 https://blog.csdn.net/ranwei693532/article/details/79934986

4. pandas基础: 处理缺失数据  dropna()  notnull()

https://www.jianshu.com/p/2eb1fc7332bd

5.unstack()    数据reshape的理解

unstack函数将数据从”花括号结构“变成”表格结构“  https://www.cnblogs.com/bambipai/p/7658311.html

6.pivot_table 数据透视表

https://www.cnblogs.com/Yanjy-OnlyOne/p/11195621.html

7.多种条件的选取 用 &

df.loc[(df['column'] == some_value) & df['other_column'].isin(some_values)]