目录标题
1. 导入数据和修改数据
# 导入pandas库
import pandas as pd
读取csv数据
datafile="D:/scene_choice/DataWsu.csv/deviceid.csv"
device=pd.read_csv(datafile)
# 如果csv中没有表头,就要加入head=None参数
创建空的dataframe
df1=pd.DataFrame(columns=['a','b','c','d'])
用字典生成dataframe
data = {
'BoolCol': [1, 2, 3, 3, 4],
'attr': [22, 33, 22, 44, 66],
'BoolC': [1, 2, 3, 3, 4],
'att': [22, 33, 22, 44, 66],
'Bool': [1, 2, 3, 3, 4]
}
df4=pd.DataFrame(data)
print(df4)
给空的dataframe添加数据
df2=pd.DataFrame([[1,2,3,4]],columns=['a','b','c','d'])
df1=df1.append(df2,ignore_index=True)
print(df1)
参数ignore_indwx=True和flase的区别:ignore_indwx=True忽略原来的index重新生成index;
df3=pd.DataFrame([[5,6,7,8]],columns=['a','b','c','d'])
df1=df1.append(df3)
print(df1)
df1=df1.append(df3,ignore_index=True)
print(df1)
在指定位置插入列,在b后面插入f:1.更新列明 2.插入数据
方法1:
col_name=df1.columns.tolist()
print(col_name)
col_name.insert(2,'f')
print(col_name)
df1=df1.reindex(columns=col_name) # DataFrame.reindex() 对原行/列索引重新构建索引值
df1['f']=['2','3','5']
print(df1)
方法2:
print(df1)
newdata=[9,8,3