TripSit / drugs

https://tripsit.me/
17 stars 9 forks source link

Update multiple substances with nonsensical/non-uniform data #67

Closed ELLEation closed 8 months ago

ELLEation commented 9 months ago

Below are the line items that have nonsensical/non-uniform data at present:

Data is not uniform: 2-methylamphetamine | Method: Undefined | formatted_onset
could not convert string to float: 'Insufflated'
Data will be defaulted to None: 2-methylamphetamine | Method: Undefined | formatted_onset

Data is not uniform: 2-methylamphetamine | Method: Undefined | formatted_duration
could not convert string to float: 'Insufflated'
Data will be defaulted to None: 2-methylamphetamine | Method: Undefined | formatted_duration

Data is not uniform: 4-aco-dpt | Method: Undefined | formatted_duration
could not convert string to float: 'Insufflated'
Data will be defaulted to None: 4-aco-dpt | Method: Undefined | formatted_duration

Data is not uniform: 4-cbc | Method: Oral | formatted_onset
invalid literal for int() with base 10: '60mg'
Data will be defaulted to None: 4-cbc | Method: Oral | formatted_onset

Data is not uniform: 4-cmc | Method: Undefined | formatted_aftereffects
could not convert string to float: 'Few'
Data will be defaulted to None: 4-cmc | Method: Undefined | formatted_aftereffects

Data is not uniform: 4f-php | Method: Undefined | formatted_onset
could not convert string to float: 'Insufflated'
Data will be defaulted to None: 4f-php | Method: Undefined | formatted_onset

Data is not uniform: 5-eapb | Method: Undefined | formatted_onset
could not convert string to float: 'Oral'
Data will be defaulted to None: 5-eapb | Method: Undefined | formatted_onset

Data is not uniform: 6-mapb | Method: Insufflated | formatted_onset
could not convert string to float: 'Within'
Data will be defaulted to None: 6-mapb | Method: Insufflated | formatted_onset

Data is not uniform: 6-mapb | Method: Oral | formatted_onset
could not convert string to float: 'Within'
Data will be defaulted to None: 6-mapb | Method: Oral | formatted_onset

Data is not uniform: bromo-dragonfly | Method: Undefined | formatted_onset
could not convert string to float: 'Up'
Data will be defaulted to None: bromo-dragonfly | Method: Undefined | formatted_onset

Data is not uniform: cyclizine | Method: Oral | formatted_duration
invalid literal for int() with base 10: '8 hours.'
Data will be defaulted to None: cyclizine | Method: Oral | formatted_duration

Data is not uniform: flubromazepam | Method: Undefined | formatted_aftereffects
could not convert string to float: '36+'
Data will be defaulted to None: flubromazepam | Method: Undefined | formatted_aftereffects

Data is not uniform: marinol | Method: Undefined | formatted_onset
could not convert string to float: 'Oral'
Data will be defaulted to None: marinol | Method: Undefined | formatted_onset

Data is not uniform: mem | Method: Undefined | formatted_onset
could not convert string to float: 'Within'
Data will be defaulted to None: mem | Method: Undefined | formatted_onset

Data is not uniform: metaclazepam | Method: Undefined | formatted_onset
could not convert string to float: 'duration'
Data will be defaulted to None: metaclazepam | Method: Undefined | formatted_onset

Data is not uniform: morpheridine | Method: Undefined | formatted_onset
could not convert string to float: 'Oral'
Data will be defaulted to None: morpheridine | Method: Undefined | formatted_onset

Data is not uniform: morpheridine | Method: Undefined | formatted_duration
could not convert string to float: 'Oral'
Data will be defaulted to None: morpheridine | Method: Undefined | formatted_duration

Data is not uniform: mxm | Method: Undefined | formatted_onset
could not convert string to float: 'Varying'
Data will be defaulted to None: mxm | Method: Undefined | formatted_onset

Data is not uniform: naphyrone | Method: Undefined | formatted_onset
could not convert string to float: 'Within'
Data will be defaulted to None: naphyrone | Method: Undefined | formatted_onset

Data is not uniform: parafluorobutyrfentanyl | Method: Undefined | formatted_onset
could not convert string to float: 'Insufflated'
Data will be defaulted to None: parafluorobutyrfentanyl | Method: Undefined | formatted_onset

Data is not uniform: pce | Method: Undefined | formatted_onset
could not convert string to float: 'Insufflated'
Data will be defaulted to None: pce | Method: Undefined | formatted_onset

Data is not uniform: phenazepam | Method: Undefined | formatted_aftereffects
could not convert string to float: '36+'
Data will be defaulted to None: phenazepam | Method: Undefined | formatted_aftereffects

Data is not uniform: phenazepam | Method: Undefined | formatted_duration
could not convert string to float: '18+'
Data will be defaulted to None: phenazepam | Method: Undefined | formatted_duration

Data is not uniform: quetiapine | Method: Oral | formatted_onset
could not convert string to float: 'IR'
Data will be defaulted to None: quetiapine | Method: Oral | formatted_onset

Data is not uniform: quetiapine | Method: Undefined | formatted_aftereffects
could not convert string to float: 'Can'
Data will be defaulted to None: quetiapine | Method: Undefined | formatted_aftereffects

Data is not uniform: thiopropamine | Method: Insufflated | formatted_onset
invalid literal for int() with base 10: '15mg.'
Data will be defaulted to None: thiopropamine | Method: Insufflated | formatted_onset

Data is not uniform: tma-2 | Method: Undefined | formatted_aftereffects
could not convert string to float: 'Possibility'
Data will be defaulted to None: tma-2 | Method: Undefined | formatted_aftereffects

Data is not uniform: tma-6 | Method: Undefined | formatted_aftereffects
could not convert string to float: 'Possibility'
Data will be defaulted to None: tma-6 | Method: Undefined | formatted_aftereffects

This data should be fact checked for accuracy and reformatted to only include floats/integers if possible to follow suit with the other substances in the dataset.

LunaUrsa commented 8 months ago

Thanks a ton @ELLEation !