DataFrame
wangfutai91
钩深索隐,卓荦为杰。
展开
-
数据分析--DataFrame(1)
import pandas as pdimport numpy as np#1.DataFrame结构类型于数据库结构的数据结果lst=[[1,2,3],[4,5,6],[7,8,9]]print(pd.DataFrame(lst,index=list('abc'),columns=list('def')))dic={"name":"wang","age":15,"addr":"上海"...原创 2019-02-22 15:58:53 · 239 阅读 · 0 评论 -
数据分析--DataFrame(2)
import pandas as pdimport numpy as np#从csv文件读取数据df=pd.read_csv("users.csv",encoding='utf-8')#2.获取前20条记录print(df.head(20))# 3.这个数据集一共有多少条数据print(df.shape[0])print(df.index.size)# 4.一共有几列prin...原创 2019-02-22 15:59:40 · 185 阅读 · 0 评论 -
数据分析--DataFrame(3)
import pandas as pdimport numpy as nparr=np.arange(1,21).reshape(5,4)df=pd.DataFrame(arr,columns=list('ABCD'))df.ix[3,'C']=np.nandf.ix[[0,1],'D']=np.nanprint(df)# 删除nan的行 df.dropna()print(df...原创 2019-02-22 16:00:17 · 173 阅读 · 0 评论 -
数据分析--画图
import matplotlib.pyplot as pltimport pandas as pdimport seaborn as snsplt.rcParams['axes.unicode_minus'] = Falsedf=pd.read_csv('Pokemon.csv',encoding='utf-8')df_index=df.columns.str.lower()#获取表...原创 2019-02-22 16:44:19 · 591 阅读 · 0 评论 -
数据分析--DataFrame(4)
import numpy as npimport pandas as pd# 1.读取Pokemon.csvdf=pd.read_csv('Pokemon.csv',encoding='utf-8')print(df)# 2.将列名同统一转成小写df_index=df.columns.str.lower()#获取表格的列名df.columns=df_index#print(df)...原创 2019-02-22 19:48:03 · 183 阅读 · 0 评论