1环境
mongodb3.4.7
python2.7.5(centos7自带版本)
pymongo-2.7
pydata.csv(自己的数据文件)
2.dataTrans.py
# -*- coding:utf-8 -*-
import pymongo
import csv
import datetime
#build connection
conn = pymongo.MongoClient('192.168.1.6',20000)
#connect dataBase
mydb = conn.test
#get collection
myCollect = mydb.testCollect
#get data
csvfile = file('/mongodbData/pydata.csv','rb')
#csv_reader = csv.reader(csvfile)
csv_reader = csv.DictReader(csvfile)
#get time befor writing
print datetime.datetime.now()
for i in range(3,10003):
for row in csv_reader:
#print data, for test
#print row
#print(row['deviceId'])
row['deviceId'] = int(row['deviceId'])
#row['deviceId'] = row['deviceId']+ i
#print row
myCollect.insert(row