Last time I checked rice didn't swim around in the ocean and vegetarians could still eat it, need to check what's going on.
> product_conc
# A tibble: 330 x 5
id name product_unit product_group other_id
* <int> <chr> <int> <int> <chr>
1 1 Rice (Milled Equivalent) 1 5 c001
2 2 Wheat and products 1 5 c002
...
> product_group_conc
# A tibble: 6 x 2
id name
* <int> <chr>
1 1 Primary crops
2 2 Crop products
3 3 Livestock
4 4 Livestock products
5 5 Fish
6 6 Wood
Suggested way to go about it:
[x] Prepare second database to insert general info into (i.e. product and region data) and make sure that product_groups are correct (ensures that insertion code is correct)
[ ] Change the product_group for affected products in the current database
Last time I checked rice didn't swim around in the ocean and vegetarians could still eat it, need to check what's going on.
Suggested way to go about it:
product_group
for affected products in the current database