lockefox/dict_query.py

## dict_query.py
import pymongo
import pandas as pd

conn = pymongo.MongoClient(MONGO_CONNECTION_STRING)

exclude_data = {'_id': False, 'attackers': False, 'items': False}
raw_data = list(conn.db.zkb.find({}, projection=exclude_data))

kill_df = pd.DataFrame(raw_data)

## result_df.csv

          
            killID
            killTime
            moonID
            position
            solarSystemID
            victim
            zkb

            
              64158479
              2017-08-19 16:28:48
              0
              {'y': -327762003.54411,...}
              30000157
              {'shipTypeID': 583,...}
              {'locationID': 40009948,...}

            
              64158462
              2017-08-19 16:27:14
              0
              {'y': -13468995620.414,...}
              30001398
              {'shipTypeID': 17476,...}
              {'locationID': 50000196,...}
	import pymongo
	import pandas as pd

	conn = pymongo.MongoClient(MONGO_CONNECTION_STRING)

	exclude_data = {'_id': False, 'attackers': False, 'items': False}
	raw_data = list(conn.db.zkb.find({}, projection=exclude_data))

	kill_df = pd.DataFrame(raw_data)
killID	killTime	moonID	position	solarSystemID	victim	zkb
64158479	2017-08-19 16:28:48	0	{'y': -327762003.54411,...}	30000157	{'shipTypeID': 583,...}	{'locationID': 40009948,...}
64158462	2017-08-19 16:27:14	0	{'y': -13468995620.414,...}	30001398	{'shipTypeID': 17476,...}	{'locationID': 50000196,...}