Ch 6 data missing

[sandraleebatista]

Hello,
where can we find the food_nutrient.csv file to trace through the Chapter 6 code?
Thanks,
Sandra

[rlbarter]

Hello Sandra,

Since this file is too large to host on GitHub, you can access it by following the instructions on the front page of this Git repo. https://github.com/Yu-Group/vds-book-supplementary

Scroll down to the "Downloading the supplementary materials in this repository" section

[sandraleebatista]

Thank you. I downloaded the most recent data from October 2024. The problem that I still had but think I fixed is that in nutrient_name.csv file. The nutrient_id in that file was just the ID in the file; it was not matching when I did join in the cleaning function. When I went to the data website, it looks like the nutrient_nbr is the actually nutrient ID.
Can you please let me know if this is correct or not?

[rlbarter]

Unfortunately, without seeing your code, it's quite difficult to understand what's gone wrong. The R and Python code on this repository should work with the downloaded version of the file.

There are several ID variable columns in the provided nutrient.csv file (1) id, (2) fdc_id, (3) nutrient_id. The nutrient_id column can be used to join to the nutrient_name.csv file and the fdc_id column can be used to join to the food.csv file.

You can also follow the code in the relevant .qmd or .ipynb files on this repository.

I hope that helps!

[sandraleebatista]

nutrient_name.csv
This is the nutrient_name.csv file in the repo.
There is no nutrient.csv file, but was able to download from original site.
I tried to run the Python code directly from the repo when I had these issues.

thanks for your responsiveness and help.