how do i get a report of potassium grams of a food and a daily total of pot. grams. URGENT

Answers

  • MoroMojo
    MoroMojo

    All of the nutrients in every commercial food in the USA is available at https://fdc.nal.usda.gov/download-datasets
    The file I downloaded is FoodData_Central_csv_2024-10-31.zip
    The files with the word 'food' and 'nutrient' in them are linked database files that can give you the information you asked for to generate a report of potassium grams of a food.
    I'm not sure what you mean by a daily total of pot. grams. If you the want the amount consumed you would just need to modify your report to add the total potassium for each food consumed.
    The 'food.csv' file alone is too big to load into Excel. If you have Microsoft Access you could get a usable database going fairly quickly. The Microsoft Access format was supplied until October 2021 and those files are still available for download. Otherwise you will have to use the JSON or CSV files they have now.
    If you don't know what I am talking about you have a steep learning curve ahead of you.

    · Share on Facebook

Categories