import numpy as np
import pandas as pd
s = pd.Series(np.random.rand(50))print(s.head())print(s.tail())# .head()查看头部数据# .tail()查看尾部数据# 默认查看5条# 重新索引reindex
s = pd.Series(np.random.rand(3), index =['a','b','c'])print(s)
s1 = s.reindex(['c','b','a','d'])print(s1)# .reindex()中也是写列表# 这里'd'索引不存在,所以值为NaN
s2 = s.reindex(['c','b','a','d'], fill_value =0)print(s2)# fill_value参数:填充缺失值的值
Series对齐
import numpy as np
import pandas as pd
s1 = pd.Series(np.random.rand(3), index =['Jack','Marry','Tom'])
s2 = pd.Series(np.random.rand(3), index =['Wang','Jack','Marry'])print(s1)print(s2)# Series 和 ndarray 之间的主要区别是,Series 上的操作会根据标签自动对齐# 空值和任何值计算结果扔为空值
删除:.drop
s = pd.Series(np.random.rand(5), index =list('ngjur'))print(s)
s1 = s.drop('n')
s2 = s.drop(['g','j'])print(s1)print(s2)print(s)# drop 删除元素之后返回副本(inplace=False)
添加
import numpy as np
import pandas as pd
s1 = pd.Series(np.random.rand(5))
s2 = pd.Series(np.random.rand(5), index =list('ngjur'))print(s1)print(s2)print('*****'*5)
s1[5]=100
s2['a']=100print(s1)print(s2)print('*****'*5)# 直接通过下标索引/标签index添加值
s3 = s1.append(s2)print(s3)print(s1)# 通过.append方法,直接添加一个数组# .append方法生成一个新的数组,不改变之前的数组
修改
import numpy as np
import pandas as pd
s = pd.Series(np.random.rand(3), index =['a','b','c'])print(s)print('*****'*5)
s['a']=100
s[['b','c']]=200print(s)# 通过索引直接修改,类似序列
Dataframe 数据结构
# Dataframe是一个表格型的数据结构,“带有标签的二维数组”。# Dataframe带有index(行标签)和columns(列标签)import numpy as np
import pandas as pd
df ={'name':['xiaoming','xiaogang','xiaoli'],'age':[18,19,20],'gender':['m','m','f']}
s1 = pd.DataFrame(df)print(s1)print(type(s1))print('*****'*5)print(s1.index,'\n该数据类型为:',type(s1.index))print(s1.columns,'\n该数据类型为:',type(s1.columns))print('*****'*5)print(s1.values,'\n该数据类型为:',type(s1.values))# 查看数据,数据类型为dataframe# .index查看行标签# .columns查看列标签# .values查看值,数据类型为ndarray
数据查看import numpy as npimport pandas as pd s = pd.Series(np.random.rand(50))print(s.head(10))print(s.tail())# .head()查看头部数据# .tail()查看尾部数据# 默认查看5条# 重新索引reindex# .reindex将会根据索引重新排序,如果当前索引不存在,则引入缺失值s = pd.Series(np.random.rand(3), index = ['a','b'