Pandas安装简单使用
1、pandas的安装可以直接pip安装它:pip install pandas
2、安装成功后,可以直接import导入直接使用pandas处理三个数据结构 -系列(Series) 数据帧(DataFrame) 面板(Panel)
3、pandas创建DataFrame ,创建一个空的dataframeimport pandas as pddf = pd.DataFrame()print df
4、使用单个列表或列表列表创建DataFrame。# -*- coding: UTF-8 -*import pandas as pddata = [1,2,3,4,5]df = pd.DataFrame(data)print df输出结果如图二所示
5、Lists的Dict创建一个DataFrameimport pandas as pddata = {'user1':['Tom'],'user2':['Cindy']}df = pd.DataFrame(data)print dfindex参数为每一行分配一个索引字典的键
6、从Dicts列表创建一个DataFrameimport pandas as pddata = [{'key1': 1, 'key2': 2},{'name1':'zhangsan','name2':'lixi'}]df = pd.DataFrame(data)print df输出: key1 key2 name1 name20 1.0 2.0 NaN NaN1 NaN NaN zhangsan lixi
7、从Dict of Series首疏扌熘创建一个DataFrameimport pandas as pdd = {'one' : pd.Series([1, 2, 3], ind髫潋啜缅ex=['a', 'b', 'c']), 'two' : pd.Series([1, 2, 3, 4], index=['a', 'b', 'c', 'd'])}df = pd.DataFrame(d)print df输出 one twoa 1.0 1b 2.0 2c 3.0 3d NaN 4