函数功能:
读取csv文件,每隔20行取一行,写入新的csv文件。
def InterlacedAccess(read_path,write_path):
import pandas as pd
# read_path = r'E:\data\manual\处理后20211127093020.csv'
# write_path =r'E:\data\manual\processData\处理后20211127093020.csv'
data = pd.read_csv(read_path,encoding='gbk') #解决中文字符乱码问题
df = pd.DataFrame(data)
a=[]
for i in range(0,len(df),20):##每隔20行取数据
a.append(i)
file = df.iloc[a]
f = pd.DataFrame(file)
f.to_csv(write_path, index=False,encoding='utf_8_sig')
print('ok')
"""
调用隔行取数函数
"""
InterlacedAccess(r'E:\data\manual\处理后20211127093020.csv',r'E:\data\manual\processData\处理后20211127093020.csv')