Repository navigation
Expand file tree
/
Copy pathrestaurantcsv_parser.py
More file actions
87 lines (75 loc) · 2.69 KB
/
Copy pathrestaurantcsv_parser.py
File metadata and controls
87 lines (75 loc) · 2.69 KB
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
import argparse
import csv
from pymongo import MongoClient
dbclient = MongoClient('localhost', 27017)
db = dbclient.foodoptionsdb
restaurant_location = {
'Chick-fil-a' : {
'lat':33.773872,
'lng':-84.398900,
'floor' : 1
},
'Panda Express' : {
'lat':33.773670,
'lng':-84.398213,
'floor' : 1
},
'Taco Bell' : {
'lat':33.773807,
'lng':-84.398724,
'floor' : 1
}
}
def main(file, restaurant):
with open(file, 'r') as csvfile:
reader = csv.reader(csvfile, delimiter=',')
next(reader, None)
for row in reader:
item = {}
item['name'] = row[0]
item['restaurant'] = {
'name': restaurant,
'location' : restaurant_location[restaurant]
}
item['nutrition'] = {}
item['nutrition']['Calories'] = convert(row[1])
item['nutrition']['Calories From Fat'] = convert(row[2])
item['nutrition']['Total Fat (g)'] = convert(row[3])
item['nutrition']['Saturated Fat (g)'] = convert(row[4])
item['nutrition']['Trans Fat (g)'] = convert(row[5])
item['nutrition']['Cholesterol (mg)'] = convert(row[6])
item['nutrition']['Sodium (mg)'] = convert(row[7])
item['nutrition']['Carbohydrates (g)'] = convert(row[8])
item['nutrition']['Fiber (g)'] = convert(row[9])
item['nutrition']['Sugars (g)'] = convert(row[10])
item['nutrition']['Protein (g)'] = convert(row[11])
item['nutrition']['Vitamin A (% DV)'] = convert(row[12])
item['nutrition']['Vitamin C (% DV)'] = convert(row[13])
item['nutrition']['Calcium (% DV)'] = convert(row[14])
item['nutrition']['Iron (% DV)'] = convert(row[15])
item['price'] = convert(row[16])
item['allergens'] = []
if row[17] == '1':
item['allergens'].append('dairy')
if row[18] == '1':
item['allergens'].append('soy')
if row[19] == '1':
item['allergens'].append('tree_nut')
if row[20] == '1':
item['allergens'].append('wheat')
if row[21] == '1':
item['allergens'].append('egg')
item['rating count'] = 0
item['rating sum'] = 0
db.foods.insert_one(item)
def convert(val):
try:
return float(val)
except:
return ''
if __name__ == '__main__':
parser = argparse.ArgumentParser()
parser.add_argument('file')
parser.add_argument('restaurant')
args = parser.parse_args()
main(args.file, args.restaurant)