从csv文件插入一个文件pymongo时出错

Question

我是一个Python和mongob的新手，我试图从一个cvs文件写入一个pymongo文档。错误如下： TypeError：'str'对象是不可调用的因为？我附上相关代码谢谢

import csv
import sys
import json
from pymongo import MongoClient

client = MongoClient(host="localhost", port=27017)
db=client["test"]
mycol=["movimenti"]
print(mycol)

with open ('Movimenti.csv','r') as f:
    reader=csv.reader(f, delimiter=';')
    next(reader, None)
    data = []


    try:
        for row in reader:
            for col in row:
                mydict = {"datacontabile": col(1), "datavaluta":   col(3),"causale": col(4), "descrizione": col(5), "importo": col(6)  }                x = mycol.insert_one(mydict)
    except csv.Error as e:
        sys.exit('file{} , line{}: {}')

Answer 1

您的错误不是来自pymongo，而是在定义字典时试图调用cols。这是因为你的列是字符串：

with open('some_csv_file.csv', 'r') as f:
   reader = csv.reader(f)
   next(reader, None)

   for row in reader: # each row
       for col in row: #each value in your row
           print(type(col)) #outputs "<class 'str'>"

括号仅用于调用函数。如果要获取字符串的第一个字符，请使用括号：

s = "Hello world"
print(s[0]) # outputs "H"
print(s(0)) # outputs TypeError: 'str' object is not callable

通常，csv中的一行是数据库中的一个条目。因此，我认为您的代码应该是：

        for row in reader:
            mydict = {"datacontabile": row[1], "datavaluta":  col[3], "causale": col[4], "descrizione": row[5], "importo": [6]}