Gyan Prakash Tripathi prakashthegyan

## store to file
df.to_csv('StructuredData.csv',index=False)

## storing to a dataframe
import pandas as pd
samples=table.find().sort("_id",pymongo.DESCENDING)[:100]
df=pd.DataFrame(samples)

df.head()

## insert in created
testInsert=mycoll.insert_one({"country":'India'}).inserted_id
client.list_database_names()

## create
mydb=client.testDB
mycoll=mydb.testColl

## delete many
myquery = ({ "name":{"$in": ["Gyan","Eliot"]}})
x = table.delete_many(myquery)

print(x.deleted_count, " documents deleted.")

## delete mike
table.delete_one({'name':'Mike'})

## mike
table.find_one({'name':'Mike'})

## find multiple
from bson.objectid import ObjectId
post_id=final.inserted_ids[0]
def parser(post_id):
    document = table.find_one({'_id': ObjectId(post_id)})
    return document

parser(post_id)

## filter 1
table.find_one({"name":'Gyan'})

## multiple insert
import datetime
new_posts = [{"name": "Mike",
            "username": "latestpost!",
            "date": datetime.datetime(2009, 11, 12, 11, 14)},
            {"name": "Eliot",
            "title": "onceAgain",
            "text": "and pretty easy too!",
            "date": datetime.datetime(2009, 11, 10, 10, 45)}]

final = table.insert_many(new_posts)
	import pandas as pd
	samples=table.find().sort("_id",pymongo.DESCENDING)[:100]
	df=pd.DataFrame(samples)

	df.head()
	testInsert=mycoll.insert_one({"country":'India'}).inserted_id
	client.list_database_names()
	from bson.objectid import ObjectId
	post_id=final.inserted_ids[0]
	def parser(post_id):
	document = table.find_one({'_id': ObjectId(post_id)})
	return document

	parser(post_id)