mongodb

pymongo

• 安装配置mongodb数据库，增加集合test_news,增加字段customer_id,age,hobby,系统默认生成_id,除了_id,其它可重复

from pymongo import MongoClient
import pandas as pd
conn = MongoClient("mongodb://127.0.0.1:27017/local")
db = conn.local
collection = db["save_file"]
result = collection.aggregate([
	{
	    "$match":{"age":27}
	},
	{
	"$group":{
	    "_id":"$customer_id",
	    "numbers":{"$sum":1},
	    "hobby":{"$first":"$hobby"}
	    }
	},
    {
            "$project":{
                "customer_id":"$_id",
                "numbers":"$numbers",
                "hobby":"$hobby",
                "_id":0
            }
    }
])

data = pd.DataFrame(result)
print(data)
data.to_csv("123.csv",encoding='utf-8')
conn.close()

mongodb导入csv文件至数据库

mongoimport --db local --collection news_data --type csv --headerline --ignoreBlanks --file ./documents.csv
mongoimport -d test -c students students.dat