python - 删除文本文件python中的列

Question

我有以下文本文件，并想从文件中完全删除（打开、高、低）。我想留下：日期，时间，关闭，向上，向下

这是示例文本文件：

"Date","Time","Open","High","Low","Close","Up","Down"
08/09/2018,17:00:00,2852.50,2852.50,2852.50,2852.50,109,0
08/09/2018,17:00:00,2852.25,2852.25,2852.25,2852.25,0,1
08/09/2018,17:00:00,2852.25,2852.25,2852.25,2852.25,0,2
08/09/2018,17:00:00,2852.50,2852.50,2852.50,2852.50,1,0
08/09/2018,17:00:00,2852.50,2852.50,2852.50,2852.50,1,0
08/09/2018,17:00:00,2852.50,2852.50,2852.50,2852.50,1,0
08/09/2018,17:00:00,2852.50,2852.50,2852.50,2852.50,2,0
08/09/2018,17:00:00,2852.50,2852.50,2852.50,2852.50,1,0
08/09/2018,17:00:00,2852.25,2852.25,2852.25,2852.25,0,2
08/09/2018,17:00:00,2852.25,2852.25,2852.25,2852.25,0,5
08/09/2018,17:00:00,2852.25,2852.25,2852.25,2852.25,0,1
08/09/2018,17:00:00,2852.50,2852.50,2852.50,2852.50,3,0
08/09/2018,17:00:00,2852.50,2852.50,2852.50,2852.50,1,0
08/09/2018,17:00:00,2852.50,2852.50,2852.50,2852.50,3,0
08/09/2018,17:00:00,2852.75,2852.75,2852.75,2852.75,3,0
08/09/2018,17:00:00,2852.25,2852.25,2852.25,2852.25,0,1
08/09/2018,17:00:00,2852.75,2852.75,2852.75,2852.75,7,0
08/09/2018,17:00:00,2852.75,2852.75,2852.75,2852.75,4,0
08/09/2018,17:00:00,2852.75,2852.75,2852.75,2852.75,1,0
08/09/2018,17:00:00,2852.75,2852.75,2852.75,2852.75,12,0
08/09/2018,17:00:00,2852.75,2852.75,2852.75,2852.75,2,0
08/09/2018,17:00:00,2852.75,2852.75,2852.75,2852.75,2,0
08/09/2018,17:00:00,2852.75,2852.75,2852.75,2852.75,1,0

标签： pythonparsingtext

Answer 1

虽然这可能不是最好的方法，但我建议使用 pandas 库Pandas将这样的文本文件读入数据框。（如果您想对该数据执行实际的数据分析操作，最好使用 Pandas 之类的工具，而不是简单的文件 io 读取/拆分。）创建数据框后（查看 Pandas 的文档），使用 pandas drop命令Pandas drop。

对于您的情况，它将是这样的：

#import pandas as pd
#Following creation of Pandas dataframe df
df = df.drop(["Open", "High", "Low"], axis = 1)

确保在进行更改后重新分配数据框。我将把它作为练习留给您查阅文档并实际导入数据框。稍微看一下 pandas，你就应该明白了。