使用Python将DLY文件转换为CSV

import pandas as pd
import csv

df = pd.read_csv('input.dly', header=None)

# 删除不需要的列
df = df.drop(columns=[2, 3, 4, 5, 6, 7, 8, 9])

# 处理缺失值（如果有）
df = df.fillna(0)

with open('output.csv', 'w', newline='') as csvfile:
    writer = csv.writer(csvfile)
    writer.writerows(df.values)

import pandas as pd
import csv

# 读取DLY文件
df = pd.read_csv('input.dly', header=None)

# 删除不需要的列
df = df.drop(columns=[2, 3, 4, 5, 6, 7, 8, 9])

# 处理缺失值（如果有）
df = df.fillna(0)

# 将数据写入CSV文件
with open('output.csv', 'w', newline='') as csvfile:
    writer = csv.writer(csvfile)
    writer.writerows(df.values)