10 pandas 数据填充

初始数据

初步填充，去掉空格，增加序号

import pandas as pd
path='C:\\Users\\Augustine\\Desktop\\us-countries\\自动填充.xlsx'
data=pd.read_excel(path,skiprows=8,usecols='F:I',dtype={'序号':str,'性别':str,'日期':str})#skiprows跳过几行,usecols选择区域列
for i in data.index:
    data['序号'].at[i]=i+1
print(data)

填充性别

import pandas as pd
path='C:\\Users\\Augustine\\Desktop\\us-countries\\自动填充.xlsx'
data=pd.read_excel(path,skiprows=8,usecols='F:I',dtype={'序号':str,'性别':str,'日期':str})#skiprows跳过几行,usecols选择区域列
for i in data.index:
    data['序号'].at[i]=i+1
    data['性别'].at[i]='男' if i%2==0 else '女'
print(data)

CSV文件（csv永远都是从头开始的）

import pandas as pd
path='C:\\Users\\Augustine\\Desktop\\us-countries\\自动填充.csv'
data=pd.read_csv(path,dtype={'序号':str,'性别':str,'日期':str})#csv永远都是从头开始写的
for i in data.index:
    data['序号'].at[i]=i+1
    data['性别'].at[i]='男' if i%2==0 else '女'
print(data)