python-3.x - 如何从多个文本文件中检索特定列，并在 Python 中创建一个 df

Question

我有一个包含 506 个股票代码的列表：AAPL、MSFT、AMZN、TSLA、FB....

我还有 506 个具有以下格式和文件名ADBE.txt的文本文件

Date,Open,High,Low,Close,Volume,OpenInterest
2021-01-11 09:27,477.91,477.91,477.91,477.91,228,0.0
2021-01-11 09:28,478.055,478.055,478.055,478.055,104,0.0
2021-01-11 09:30,478.38,478.38,478.38,478.38,265,0.0
2021-01-11 09:32,478.42,478.6,478.42,478.6,308,0.0
2021-01-11 09:34,478.71,478.71,478.62,478.62,401,0.0

我想为每个交易品种创建一个带有日期和收盘价的 df，格式如下所示

标签： python-3.x