search

ssdavenport / lcb2018

2018 lcb data analysis
0 stars 0 forks source link

Update Gquery Retail dataset for new datacleaning #5

Open ssdavenport opened 6 years ago

ssdavenport commented 6 years ago

Re-make all the variables you made for the ISSDP project.

E.g., create the new TotalTHC and TotalCBD values. Then you can query those easily

ssdavenport commented 6 years ago

Make a "wt" column. For usableweight-types, this will just equal "usableweight" x "weight". Otherwise, equate it to units (for simplicity). In more advanced methods, you may want to not weight by units, but some other weighting-variable e.g. price or netweight or grams THC content