时间戳

首页 > 解决方案 > 标记数据时出错。C 错误：第 7 行中应有 1 个字段，看到 2

python - 标记数据时出错。C 错误：第 7 行中应有 1 个字段，看到 2

问题描述

import pandas as pd
import numpy as np
import os 
from datetime import datetime
import glob
from datetime import timedelta
from dateutil.relativedelta import relativedelta

from_date = "20160101"
end_date = "20181201"
from_date = datetime.strptime(from_date, '%Y%m%d').date()
end_date = datetime.strptime(end_date, '%Y%m%d').date()

from_year = from_date.year
end_year = end_date.year
from_month = from_date.month
end_month = end_date.month


path = r"C:\Users\krishna gupta\Global_trader\GFDLNFO files\csv"
load = []
while from_date <= end_date:
    path1 = (path + "\\" + str(from_date.year)+"\\" + str(from_date.month))
    from_date += relativedelta(months =+ 1)
    #final_date_str = str(from_date)
    dir_list = os.listdir(path1)
    for files in dir_list:
        extension = "csv"
        os.chdir(path1)
        for i in glob.glob(files.format(extension)):
            load.append(path1+"\\"+i)
combined = pd.concat([pd.read_csv(i) for i in load], error_bad_lines=False)
# print(combined)
df = combined
df

在此处输入图像描述

我不明白为什么我会收到此错误，而我在 VS 代码上运行此代码，因此它完美地运行在那里，但我在 jupyter 笔记本上运行此代码，所以我收到此错误 - 错误标记数据。C 错误：第 7 行中应有 1 个字段，看到 2 在此处输入图像描述

标签： pythonpandas

解决方案

推荐阅读