python - 如何删除 csv 文件中除我输入的列之外的所有列?
问题描述
all_filenames = [i for i in glob.glob("/home/greenvulcano/Scrivania/File_csv/*.csv")]
dest_file = "/home/greenvulcano/Scrivania/Unione_files.csv"
tag = ["inclination","deformation","temperature"]
content = []
for file_name in sorted(all_filenames):
with open(file_name, "r") as f:
lines = f.readlines()
for i, l in enumerate(lines):
if len(content) == 0:
content.append(l)
elif i != 0:
content.append(l)
with open(dest_file, "w") as f:
f.writelines(content)
seleziona = input("Inserisci le colonne che vuoi visualizzare: ") with open(dest_file, "r") as f:
titoli = f.readline().split(",")
indici = []
for titolo in titoli:
titolo_split = titolo.split('*')
if seleziona in titolo_split:
indice = titoli.index(titolo)
indici.append(indice)
righe = f.readlines()
lista = []
for riga in righe:
rigasplit = riga.split(",")
for i in indici:
lista.append(rigasplit[i])
解决方案
我想你可以使用:
测试.csv
id,name,dob
1,pedro,2000-01-01
2,nuno,1999-01-01
import csv
csv_file = "test.csv"
seleziona = input("Inserisci le colonne che vuoi visualizzare: ").strip()
with open(csv_file) as f:
reader = csv.DictReader(f, delimiter=',')
for row in reader:
print(row[seleziona])
pedro
nuno
推荐阅读
- c++ - 内联 constexpr 和匿名命名空间变量?
- node.js - Node模块的依赖在更新或安装后不会更新?
- flutter - 如何比较颤动中的类对象列表?
- angular - 简单的应用程序路由不起作用 - Angular
- python - Python 中的 C++ 类和 C++ 中的 Python 类
- python - Hazelcast 和 python 没有适合 -120 类型的反序列化器
- oracle-apex - 创建新记录并返回新 ID
- java - 具有相同签名的 2 个应用程序之间的文件提供程序
- angular - 角度:我想要一个角度构建。但是有一个错误
- powershell - 如何在 PowerShell 7 上获取 UWP DisplayName 属性?