pandas学习笔记

import numpy as np
import pandas
import pandas as pd
from pandas import MultiIndex

# # 创建series对象
# ser_obj=pandas.Series(data=["python","java","c","javascript","php","go"],index=['a','a','c','d','e','f'])
# print(ser_obj)
# year_dict={
#     "a":2022,"b":2023,"c":2024,"d":2025,"e":2026
# }
# arr_2d=np.arange(1,32).reshape(6,5)
# df_obj=pandas.DataFrame(arr_2d,columns=['a','b','c','d','e','f'])
#
# print(arr_2d)
# # print(ser_obj)
#
# # 索引 重要
# ser_index=ser_obj.index #获取索引
# new_dt=ser_obj.reindex(index=["s","a","e"],fill_value=0)
# arr=np.arange(12).reshape(3,4)
# print(arr)
# # 设置索引
# df_obj=pd.DataFrame(arr,columns=['a','b','c','d','e','f'],index=["r1","r2","r3","r4","r5","r6"])
# print(df_obj["a"])
# # loc,iloc
# print(df_obj.iloc[0])
# df_obj.to_csv(r"info.csv",index=False,encoding='utf-8')

# 嵌套索引
list_tup=[('A','A1'),
          ('A','A2'),
          ('B','B1'),
          ('B','B2'),
          ]
multi_index=MultiIndex.from_tuples(list_tup,names=['外层索引','内存索引'])

df_qian=np.arange(12).reshape(3,4)
df=pd.DataFrame(df_qian,index=multi_index)
print(df)

# 保存到csv
df.to_csv("data.csv")