-
Notifications
You must be signed in to change notification settings - Fork 0
/
Copy pathscriptToCreateCSV.py
15 lines (15 loc) · 24.3 KB
/
scriptToCreateCSV.py
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
import re
import pandas as pd
import numpy as np
in_str = """<option value="0.963699648">Abiyuch, raw</option><option value="0.414221778">Acerola, (west indian cherry), raw</option><option value="1.217304818">Adobo fresco</option><option value="0.139482844">Alfalfa seeds, sprouted, raw</option><option value="0.4015415198">Almonds, ground</option><option value="0.38886126128">Almonds, sliced</option><option value="0.45648930672">Almonds, slivered</option><option value="0.60442565612">Almonds, whole</option><option value="1.05668821">Almond butter</option><option value="0.160616608">Amaranth flakes</option><option value="0.11834908">Amaranth leaves, raw</option><option value="0.815763298">Amaranth, uncooked</option><option value="1.010193929">Apple juice, from concentrate, prepared</option><option value="1.048234704">Apple juice, unsweetened</option><option value="0.25360517">Apples, dehydrated</option><option value="1.039781199">Applesauce, canned, sweetened</option><option value="1.077821974">Applesauce, canned, sweetened, with salt</option><option value="1.031327693">Applesauce, canned, unsweetened</option><option value="1.060914963">Apricot nectar, canned</option><option value="0.502983588">Apricots, dehydrated</option><option value="1.022874187">Apricots, frozen, sweetened</option><option value="0.710094477">Artichokes</option><option value="0.084535057">Arugula, raw</option><option value="1.022874187">Asparagus, canned</option><option value="0.566384881">Asparagus, raw</option><option value="1.069368469">Baked beans, canned</option><option value="0.934">Baking soda (sodium bicarbonate), average</option><option value="2.16">Baking soda (sodium bicarbonate), compacted</option><option value="0.88">Baking soda (sodium bicarbonate), low moisture</option><option value="0.721">Baking powder, average</option><option value="1.1">Baking powder, compacted</option><option value="0.202884136">Balsam-pear (bitter gourd), leafy tips, raw</option><option value="0.422675284">Bananas, dehydrated, or banana powder</option><option value="0.777722523">Barley, hulled</option><option value="0.845350568">Barley, pearled, raw</option><option value="1.073595221">Beans, baked, canned</option><option value="0.727001488">Beans, black, mature seeds, cooked</option><option value="0.819990051">Beans, black, mature seeds, raw</option><option value="0.532570858">Beans, fava, in pod, raw</option><option value="0.748135253">Beans, french, mature seeds, cooked, boiled</option><option value="0.777722523">Beans, french, mature seeds, raw</option><option value="1.107409244">Beans, great northern, mature seeds, canned</option><option value="0.77349577">Beans, great northern, mature seeds, raw</option><option value="1.082048727">Beans, kidney, canned</option><option value="0.748135253">Beans, kidney, cooked</option><option value="0.777722523">Beans, kidney, raw</option><option value="0.879164591">Beans, navy, raw</option><option value="0.439582295">Beans, navy, sprouted, raw</option><option value="1.014420682">Beans, pinto, canned</option><option value="0.722774736">Beans, pinto, cooked</option><option value="0.815763298">Beans, pinto, raw</option><option value="0.511437094">Beans, snap, green, frozen, all styles, unprepared</option><option value="0.160616608">Beet greens, raw</option><option value="1.039781199">Beets, canned</option><option value="0.574838386">Beets, raw</option><option value="0.608652409">Blackberries, raw</option><option value="0.663600196">Blackberries, wild, raw (Alaska Native)</option><option value="0.62555942">Blueberries, raw</option><option value="1.348334156">Blueberries, wild, canned, heavy syrup, drained</option><option value="0.456489307">Bread crumbs, dry, grated, plain</option><option value="0.507210341">Bread crumbs, dry, grated, seasoned</option><option value="0.845350568">Bread stuffing, bread, dry mix, prepared</option><option value="0.845350568">Bread stuffing, cornbread, dry mix, prepared</option><option value="0.929885625">Breadfruit, raw</option><option value="0.634012926">Broadbeans (fava beans), mature seeds, raw</option><option value="0.46071606">Broadbeans, immature seeds, raw</option><option value="0.659373443">Broccoli, frozen, chopped, unprepared</option><option value="0.777722523">Broccoli, frozen, spears, cooked, boiled, drained</option><option value="0.37195425">Brussels sprouts, raw</option><option value="0.718547983">Buckwheat</option><option value="0.710094477">Buckwheat groats, roasted, cooked</option><option value="0.693187466">Buckwheat groats, roasted, dry</option><option value="0.769269017">Bulgur, cooked</option><option value="0.591745398">Bulgur, dry</option><option value="0.866484332">Butter oil, anhydrous</option><option value="0.959472895">Butter, salted</option><option value="0.638239679">Butter, whipped, with salt</option><option value="0.959472895">Butter, without salt</option><option value="0.397314767">Butterbur, (fuki), raw</option><option value="0.634012926">Cabbage, japanese style, fresh, pickled</option><option value="0.541024364">Cabbage, mustard, salted</option><option value="0.46071606">Cabbage, napa, cooked</option><option value="0.769269017">Candies, gum drops, low calorie (sorbitol)</option><option value="0.824216804">Candies, M&M's Almond Chocolate Candies</option><option value="0.879164591">Candies, M&M's Milk Chocolate Candies</option><option value="0.858030827">Candies, M&M's Peanut Butter Chocolate Candies</option><option value="0.718547983">Candies, M&M's Peanut Chocolate Candies</option><option value="0.866484332">Candies, SKITTLES Original Bite Size Candies</option><option value="0.629786173">Candies, milk chocolate coated peanuts</option><option value="0.760815511">Candies, milk chocolate coated raisins</option><option value="0.794629534">Candies, REESE'S PIECES Candy</option><option value="0.31277971">Carrot, dehydrated</option><option value="0.870711085">Cassava, raw</option><option value="1.014420682">Catsup</option><option value="0.270512182">Cauliflower, green, raw</option><option value="0.659373443">Celeriac, raw</option><option value="0.152163102">Chard, swiss, raw</option><option value="0.908751861">Cheese fondue</option><option value="0.477623071">Cheese food, pasteurized process, American</option><option value="0.959472895">Cheese, cottage, 1% milkfat</option><option value="0.980606659">Cheese, cream</option><option value="1.014420682">Cheese, cream, low fat</option><option value="0.566384881">Cheese, limburger</option><option value="0.473396318">Cheese, Mexican, blend, reduced fat</option><option value="0.422675284">Cheese, parmesan, dry grated, reduced fat</option><option value="0.422675284">Cheese, parmesan, grated</option><option value="1.048234704">Cheese, ricotta</option><option value="0.756588758">Cherries, sweet, canned, pitted, heavy syrup, drained</option><option value="0.845350568">Chickpeas (garbanzo beans), mature seeds, raw</option><option value="0.013525609">Chives, freeze-dried</option><option value="0.557931">Chocolate, Baking chocolate, unsweetened, squares (grated)</option><option value="1.325">Chocolate, Nestle Semi-Sweet Morsels</option><option value="0.641">Chocolate, powder</option><option value="1.268025852">Chocolate syrup</option><option value="1.183491">Chocolate, syrup, HERSHEYS Genuine Lite Syrup</option><option value="0.650919937">Chokecherries, raw, pitted (Northern Plains Indians)</option><option value="0.363500744">Cocoa, dry powder</option><option value="0.473396">Cookies, chocolate wafers (crumbled)</option><option value="0.067628045">Coriander (cilantro) leaves, raw</option><option value="0.612879162">Corn, sweet, yellow, raw</option><option value="0.701640971">Corn, white</option><option value="0.701640971">Corn, yellow</option><option value="0.59597215">Corn, yellow, whole kernel, frozen, microwaved</option><option value="0.663600196">Cornmeal, degermed</option><option value="0.515663846">Cornmeal, self-rising, plain</option><option value="0.718547983">Cornmeal, self-rising, with wheat flour added</option><option value="0.583291892">Cornmeal, self-rising, degermed, enriched</option><option value="0.515663846">Cornmeal, whole-grain</option><option value="0.541024364">Cornstarch</option><option value="0.731228241">Couscous, dry</option><option value="0.486076577">Cracker meal</option><option value="0.512333165">Cranberries, dried, sweetened</option><option value="0.397314767">Cream substitute, powdered</option><option value="1.022874187">Cream, fluid, half and half</option><option value="0.972153153">Cream, sour, cultured</option><option value="1.022874187">Cream, sour, reduced fat, cultured</option><option value="0.25360517">Cream, whipped, cream topping, pressurized</option><option value="0.211337642">Cress, garden, raw</option><option value="0.126802585">Croutons, plain</option><option value="0.169070114">Croutons, seasoned</option><option value="0.473396318">Currants, raw</option><option value="0.608652409">Currants, zante, dried</option><option value="0.65514669">Edamame, frozen, prepared</option><option value="0.498756835">Edamame, frozen, unprepared</option><option value="1.02710094">Egg, white, raw, fresh</option><option value="0.929885625">Egg, whole, cooked, scrambled</option><option value="1.02710094">Egg, yolk, raw, fresh</option><option value="1.073595221">Eggnog</option><option value="0.574838386">Eggplant, pickled</option><option value="0.612879162">Elderberries, raw</option><option value="1.065141716">Ensure plus, liquid nutrition</option><option value="0.422675284">Eppaw, raw</option><option value="0.866484332">Fat, animal meat</option><option value="0.629786173">Figs, dried, uncooked</option><option value="0.921432119">Fish oil</option><option value="0.528344105">Flour, U.S. all-purpose</option><option value="0.541024364">Flour, Arrowroot</option><option value="0.62555942">Flour, Barley</option><option value="0.68473396">Flour, Barley malt</option><option value="0.507210341">Flour, buckwheat, whole-groat</option><option value="0.435355543">Flour, Carob</option><option value="0.388861261">Flour, chickpea (besan)</option><option value="0.532570858">Flour, corn, degermed</option><option value="0.481849824">Flour, corn, masa</option><option value="0.494530082">Flour, corn, whole-grain</option><option value="0.25360517">Flour, peanut, defatted</option><option value="0.25360517">Flour, peanut, low fat</option><option value="0.676280454">Flour, potato</option><option value="0.667826949">Flour, rice</option><option value="0.541024364">Flour, rye, dark</option><option value="0.43112879">Flour, rye, light/medium</option><option value="0.511437094">Flour, sorghum</option><option value="0.443809048">Flour, soy, defatted</option><option value="0.549477869">Flour, triticale, whole-grain</option><option value="0.528344105">Flour, wheat, white, all-purpose</option><option value="0.579065139">Flour, wheat, white, bread, enriched</option><option value="0.507210341">Flour, wheat, whole-grain</option><option value="0.11834908">Fungi, Cloud ears, dried</option><option value="0.574838386">Garlic, raw</option><option value="0.634012926">Gooseberries, raw</option><option value="0.05917454">Grape leaves, raw</option><option value="0.388861261">Grapes, american type, raw</option><option value="0.638239679">Grapes, red or green (European type), raw</option><option value="0.591745398">Groundcherries, (cape-gooseberries or poha), raw</option><option value="0.697414219">Guavas, common, raw</option><option value="1.031327693">Guavas, strawberry, raw</option><option value="0.617105915">Hearts of palm, canned</option><option value="0.697414219">Hominy, canned, white</option><option value="0.676280454">Hominy, canned, yellow</option><option value="1.432869213">Honey</option><option value="0.984833412">Horned melon (Kiwano)</option><option value="1.039781199">Hummus</option><option value="0.887618096">Hyacinth beans, mature seeds, raw</option><option value="0.338140227">Hyacinth-beans, immature seeds, raw</option><option value="0.570611633">Java-plum, (jambolan), raw</option><option value="0.245151665">Jellyfish, dried, salted</option><option value="0.11834908">Jute, potherb, raw</option><option value="0.727001488">Kamut, cooked</option><option value="0.786176028">Kamut, uncooked</option><option value="0.228244653">Kanpyo, (dried gourd strips)</option><option value="0.570611633">Kohlrabi, raw</option><option value="0.866484332">Lard</option><option value="0.376181003">Leeks, (bulb and lower leaf-portion), raw</option><option value="0.013525609">Leeks, (bulb and lower-leaf portion), freeze-dried</option><option value="0.28319244">Lemon grass (citronella), raw</option><option value="1.031327693">Lemon juice</option><option value="0.811536545">Lentils, raw</option><option value="0.325459969">Lentils, sprouted, raw</option><option value="0.693187466">Lima beans, immature, frozen, baby, unprepared</option><option value="0.676280454">Lima beans, immature, frozen, fordhook, unprepared</option><option value="0.659373443">Lima beans, immature, raw</option><option value="0.752362006">Lima beans, large seeds, raw</option><option value="0.853804074">Lima beans, thin seeded (baby), mature seeds, raw</option><option value="1.022874187">Lime juice</option><option value="0.80308304">Litchis, raw</option><option value="0.760815511">Lupins, mature seeds, raw</option><option value="1.060914963">Mango nectar, canned</option><option value="0.912978613">Mangosteen, canned, syrup pack</option><option value="0.959472895">Margarine</option><option value="1.352560909">Marmalade, orange</option><option value="1.010193929">Mayonnaise dressing</option><option value="1.039781199">Milk, 1% milkfat</option><option value="1.039781199">Milk, 2% milkfat</option><option value="0.507210341">Milk, buttermilk, dried</option><option value="1.035554446">Milk, buttermilk, fluid</option><option value="1.293386369">Milk, canned, condensed</option><option value="1.065141716">Milk, canned, evaporated</option><option value="0.287419193">Milk, dry, instant</option><option value="0.507210341">Milk, dry, nonfat, regular</option><option value="0.541024364">Milk, dry, whole</option><option value="1.031327693">Milk, goat</option><option value="1.039781199">Milk, nonfat</option><option value="1.035554446">Milk, sheep</option><option value="1.031327693">Milk, whole</option><option value="0.502983588">Millet flour</option><option value="0.735454994">Millet, cooked</option><option value="0.08876181">Millet, puffed</option><option value="0.845350568">Millet, raw</option><option value="1.162357031">Miso</option><option value="1.424415707">Molasses</option><option value="0.634012926">Mollusks, mussel, blue, raw</option><option value="1.048234704">Mollusks, oyster, eastern, wild, raw</option><option value="0.828443557">Mothbeans, mature seeds, raw</option><option value="0.591745398">Mulberries, raw</option><option value="0.874937838">Mung beans, mature seeds, raw</option><option value="0.439582295">Mung beans, mature seeds, sprouted, raw</option><option value="0.874937838">Mungo beans, mature seeds, raw</option><option value="0.228244653">Mushrooms, Chanterelle, raw</option><option value="0.278965687">Mushrooms, morel, raw</option><option value="1.052461457">Mustard, prepared, yellow</option><option value="0.739681747">Natto</option><option value="0.190203878">Noodles, chinese, chow mein</option><option value="0.160616608">Noodles, egg, dry</option><option value="0.190203878">Noodles, flat, crunchy, Chinese restaurant</option><option value="0.4015415198">Nuts, almonds, ground</option><option value="0.38886126128">Nuts, almonds, sliced</option><option value="0.45648930672">Nuts, almonds, slivered</option><option value="0.60442565612">Nuts, almonds, whole</option><option value="1.05668821">Nuts, almond butter</option><option value="0.507210341">Nuts, butternuts, dried</option><option value="0.612879162">Nuts, chestnuts, european, raw, unpeeled</option><option value="0.65514669">Nuts, chestnuts, japanese, dried</option><option value="0.507210341">Nuts, hickorynuts, dried</option><option value="0.579065139">Nuts, mixed nuts, dry roasted</option><option value="0.464942812">Nuts, pecans, oil roasted</option><option value="0.507210341">Nuts, pilinuts, dried</option><option value="0.570611633">Nuts, pine nuts, dried</option><option value="0.519890599">Nuts, pistachio nuts</option><option value="0.397314767">Oat bran, raw</option><option value="0.659373443">Oats</option><option value="0.591745398">Oheloberries, raw</option><option value="0.921432119">Oil, almond, coconut, cottonseed, flaxseed</option><option value="0.946792636">Oil, corn and canola</option><option value="0.921432119">Oil, mustard, nutmeg, oat, hazelnut, grapeseed</option><option value="0.912978613">Oil, olive, palm, peanut</option><option value="0.422675284">Okra, raw</option><option value="0.236698159">Onions, dehydrated flakes</option><option value="1.048234704">Orange juice, raw</option><option value="0.718547983">Oranges, raw, with peel</option><option value="0.490303329">Peaches, dehydrated (low-moisture), uncooked</option><option value="1.090502233">Peanut butter</option><option value="0.617105915">Peanuts, all types, raw</option><option value="0.849577321">Pears, canned, heavy syrup, drained</option><option value="0.612879162">Peas, green, raw</option><option value="0.507210341">Peas, mature seeds, sprouted, raw</option><option value="0.832670309">Peas, split, mature seeds, raw</option><option value="0.101442068">Pepeao, dried</option><option value="0.524117352">Pepper, banana, raw</option><option value="0.680507207">Plums, wild (Northern Plains Indians)</option><option value="1.014420682">Poi</option><option value="0.676280454">Pokeberry shoots, (poke), raw</option><option value="0.629786173">Prickly pears, raw</option><option value="0.557931375">Prunes, dehydrated (low-moisture), uncooked</option><option value="0.164843361">Pumpkin leaves, raw</option><option value="1.141223267">Pumpkin pie mix, canned</option><option value="1.035554446">Pumpkin, canned</option><option value="0.181750372">Purslane, raw</option><option value="0.718547983">Quinoa, uncooked</option><option value="0.160616608">Radish seeds, sprouted, raw</option><option value="0.519890599">Raspberries, raw</option><option value="0.549477869">Raspberries, wild (Northern Plains Indians)</option><option value="0.317006463">Reddi Wip Fat Free Whipped Topping</option><option value="0.498756835">Rice bran, crude</option><option value="0.781949275">Rice, brown, long-grain, raw</option><option value="0.80308304">Rice, brown, medium-grain, raw</option><option value="0.781949275">Rice, white, raw</option><option value="0.676280454">Rice, wild, raw</option><option value="0.536797611">Rose Hips, wild (Northern Plains Indians)</option><option value="0.963699648">Rowal, raw</option><option value="0.71432123">Rye</option><option value="1.234211829">Salt, table</option><option value="0.600198903">Sauerkraut, canned, solids and liquids</option><option value="0.473396318">Seaweed, spirulina, dried</option><option value="0.676280454">Seeds, breadnut tree seeds, dried</option><option value="0.397314767">Seeds, cottonseed flour, partially defatted (glandless)</option><option value="0.135256091">Seeds, lotus seeds, dried</option><option value="0.545251116">Seeds, pumpkin and squash seed kernels, dried</option><option value="0.608652409">Seeds, sesame seeds, whole, dried</option><option value="0.31277971">Seeds, sisymbrium sp. seeds, whole, dried</option><option value="0.270512182">Seeds, sunflower seed flour, partially defatted</option><option value="0.591745398">Seeds, sunflower seed kernels, dried</option><option value="0.456489307">Seeds, watermelon seed kernels, dried</option><option value="0.705867724">Semolina</option><option value="0.060865241">Shallots, freeze-dried</option><option value="0.866484332">Shortening, vegetable, household</option><option value="0.811536545">Sorghum</option><option value="0.972153153">Sour cream</option><option value="0.515663846">Soy meal, defatted, raw</option><option value="1.082048727">Soybeans, green, raw</option><option value="0.786176028">Soybeans, mature seeds, raw</option><option value="0.295872699">Soybeans, mature seeds, sprouted, raw</option><option value="1.02710094">Soymilk (All flavors)</option><option value="1.02710094">Soymilk (All flavors), enhanced</option><option value="0.735454994">Spelt, uncooked</option><option value="0.126802585">Spinach, raw</option><option value="0.659373443">Succotash, (corn and limas), frozen, unprepared</option><option value="0.845350568">Sugar, granulated</option><option value="0.5072103408">Sugar, powdered, unsifted</option><option value="0.422675284">Sugar, powdered, sifted</option><option value="0.853804074">Sugar, turbinado</option><option value="0.798856287">Sweeteners, brown, contains sugar and sucralose</option><option value="0.853804074">Sweeteners, contains sugar and sucralose</option><option value="0.828443557">Sweeteners, tabletop, fructose, dry, powder</option><option value="1.284932863">Syrups, chocolate, fudge-type</option><option value="1.386374932">Syrups, corn, dark</option><option value="1.31029338">Syrups, corn, high-fructose</option><option value="1.441322718">Syrups, corn, light</option><option value="1.014420682">Syrups, dietetic</option><option value="1.403281943">Syrups, malt</option><option value="1.331427145">Syrups, maple</option><option value="1.394828437">Syrups, sorghum</option><option value="1.331427145">Syrups, table blends, cane and 15% maple</option><option value="1.335653897">Syrups, table blends, corn, refiner, and sugar</option><option value="1.327200392">Syrups, table blends, pancake</option><option value="1.014420682">Syrups, table blends, pancake, reduced-calorie</option><option value="1.331427145">Syrups, table blends, pancake, with 2% maple</option><option value="1.331427145">Syrups, table blends, pancake, with butter</option><option value="1.044007951">Tangerine juice, raw</option><option value="0.642466432">Tapioca, pearl, dry</option><option value="0.11834908">Taro leaves, raw</option><option value="0.815763298">Teff, uncooked</option><option value="0.701640971">Tempeh</option><option value="1.107409244">Tofu yogurt</option><option value="1.065141716">Tofu, firm</option><option value="0.515663846">Tofu, okara</option><option value="1.065141716">Tofu, raw, firm</option><option value="1.048234704">Tofu, raw, regular</option><option value="1.022874187">Tomato and vegetable juice</option><option value="1.107409244">Tomato products, canned, paste</option><option value="1.05668821">Tomato products, canned, puree</option><option value="1.035554446">Tomato products, canned, sauce</option><option value="1.035554446">Tomato sauce</option><option value="0.760815511">Tomatoes, green, raw</option><option value="1.014420682">Tomatoes, red, ripe, canned, packed in tomato juice</option><option value="1.077821974">Tomatoes, red, ripe, canned, stewed</option><option value="1.014420682">Tomatoes, red, ripe, cooked</option><option value="0.228244653">Tomatoes, sun-dried</option><option value="0.464942812">Tomatoes, sun-dried, packed in oil, drained</option><option value="0.634012926">trail mix, regular</option><option value="0.811536545">Triticale</option><option value="0.879164591">Vanilla extract</option><option value="0.921432119">Vegetable oil, palm kernel</option><option value="0.591745398">Vermicelli, made from soy</option><option value="1.077821974">Vinegar, balsamic</option><option value="1.010193929">Vinegar, cider</option><option value="1.005967176">Vinegar, distilled</option><option value="1.010193929">Vinegar, red wine</option><option value="1.001740423">Water, bottled, generic</option><option value="0.245151665">Wheat bran, crude</option><option value="0.486076577">Wheat germ, crude</option><option value="0.811536545">Wheat, durum, hard red, hard white</option><option value="0.710094477">Wheat, soft red winter, soft white</option><option value="0.456489307">Wheat, sprouted</option><option value="0.240924912">Whey, acid, dried</option><option value="1.039781199">Whey, acid, fluid</option><option value="0.612879162">Whey, sweet, dried</option><option value="1.039781199">Whey, sweet, fluid</option><option value="0.769269017">Winged beans, mature seeds, raw</option><option value="0.549477869">Yambean (jicama), raw</option><option value="0.705867724">Yardlong beans, mature seeds, raw</option>"""
matches = re.findall("<option value=\"([\d\.]+)\">([^<]+)<\/option>", in_str)
d = {'density': [], 'ingredient': []}
df = pd.DataFrame(data=d)
for match in matches:
# df = df.append(list(match))
df.loc[len(df)] = list(match)
# print(match)
# print(match.group(1))
# print(match.group(2))
# print(match.group(3))
df.to_csv("ingredient_density.csv", index=False)