获取数据帧中的语法错误

Question

我得到一个语法错误，我不知道为什么。你能帮帮我吗？ 我正在尝试读取多个.csv文件

import pandas as pd
from glob import glob

gas_prices= sorted(glob('Gas prices/2020****_EEXGasFutures_SettlementPrices.csv'))
gas_prices

pd.concat((pd.read_csv(file).assign(filename = file)
           for file in gas prices), ignore_index = True)

错误消息：

File "<ipython-input-17-cacfa11dbcf0>", line 2
    for file in gas prices), ignore_index = True)
                         ^
SyntaxError: invalid syntax

Answer 1

您犯了一个语法错误，在pd.concat()gas prices中应该是gas_prices：

import pandas as pd
from glob import glob

gas_prices= sorted(glob('Gas prices/2020****_EEXGasFutures_SettlementPrices.csv'))

pd.concat((pd.read_csv(file).assign(filename = file)
           for file in gas_prices), ignore_index = True)