讀取csv文件中指定的行數據-轉載
######創建csv文件,并按行讀取數據#######
import numpy as np
import pandas as pd
import csv
# 1.創建csv文件
with open('123.csv','w',newline='') as file:
csv_writer=csv.writer(file)
# 2.讀取csv指定行的數據
with open('C:\\Users\\86178\\Desktop\\python\\pythonProject\\ethylene_methane.csv', 'r') as f:
reader = csv.reader(f)
index = 0
for row in reader:
index = index + 1
# 3.要求
if index %30000 ==0:
# 4.寫入滿足要求的行數據
csv_writer.writerow(row)
######添加表頭#######
# 1.讀取csv文件
dg = pd.read_csv('C:\\Users\\86178\\Desktop\\python\\pythonProject\\123.csv',header=None)
# 2.添加表頭
dg = dg.rename(columns = {0:'Num', 1:'Time (seconds)', 2:'Methane conc (ppm)',3:'Ethylene conc(ppm)',4:'Sensor1',5:'Sensor2',6:'Sensor3',7:'Sensor4',8:'Sensor5',9:'Sensor6',10:'Sensor7',11:'Sensor8',12:'Sensor9',13:'Sensor10',14:'Sensor11',15:'Sensor12',16:'Sensor13',17:'Sensor14',18:'Sensor15',19:'Sensor16'})
# 3.保存csv文件
dg.to_csv('123.csv')
————————————————
版權聲明:本文為CSDN博主「熊不勝」的原創文章,遵循CC 4.0 BY-SA版權協議,轉載請附上原文出處鏈接及本聲明。
原文鏈接:https://blog.csdn.net/asdfghjkl9514/article/details/123595144
工程師必備
- 項目客服
- 培訓客服
- 平臺客服
TOP




















