So you are looking to relocate to the United States of America but feel discourage coz you heard the state you're moving into have not legalized the use of marijuana . Which also means it is a criminal offence to have in your possession marijuana or weed like some may call it.

Feeling sad and confused about the next step to take, you hire a data analyst (me of course ) to help you analyze a dataset you saw online. A dataset that shows all the states in America and its legality status, per capital income, median rent etc...… and you believe with the insights and findings the analyst shares with you, you are able to make a decision on which state in America to relocate to.

And just to be clear you only use marijuana for medical use and not for recreational use


Hello! my name is Jamer the analyst. I have been able to analyze the dataset and this are my findings...…..

BUT before I go into sharing my findings, I would love to start from the beginning and show you the step by step process into my findings.


Here We Go:

As you can see in the picture below, this dataset has two tables. The REGULATIONS table and the WEED_CLEAN table

a) The first picture shows the values in the REGULATIONS table
b) The second picture shows the values in the WEED_CLEAN table
c) The third shows a virtual table (state_weed_data) I created to join both the REGULATIONS and the WEED_CLEAN table together. The blue line represent the regulations table and the red line represent the weed_clean table.

My Findings:

a) The first pics shows the legality status In America. Marijuana is fully illegal, fully legal or medical in some of the states in America.

b) The second pics shows the number of states in America and its legality status. And as you can see below there are six(6) that have not legalized the use of marijuana either for recreational use or medical use.

Lets Check Out The States;

a) The first pics shows the six(6) state that have not legalized the used of marijuana. And not only is it illegal, it is also a criminal offense. The decriminalized field shows all state as false i.e. it is a criminal offense except for South Dakota.

b) The second pics shows all 16 states that have legalized the use of marijuana. These are the states you should bear in mind when you are ready to relocate. And as you can see all 16 states show true i.e. it is not a criminal offense.

c) The third pics shows states that have approved the use of marijuana for medical use only. That means you can use marijuana as a form of medicine only and not for recreational use. If caught smoking you can be penalized as you can see below all values in the decriminalized field shows false i.e. it is a criminal offense.

d) The fourth pics shows states that have legalized the use of marijuana for both medical and recreational use. You don't need to worry anymore one of this states should work for you.

legalization of marijuana in the state you are looking to relocate to shouldn't be your only reason for wanting to relocate. Checking out the Per Capital Income and the average rent paid per month should also help in you decision making. You are not just moving to smoke weed or use it for medicine. You also want to work and earn so that you can afford to buy as many ounce of weed you can afford

Lets Check It Out;

a) The first pics shows the fully legal states and its per capital income. Ranging from the state with the highest per capital income to the state with the lowest. It also shows the average rent paid per month in those states. As you can see below District Of Columbia has the highest per capital income but is that the state you would love to move to. Take your time and choose the fully legal state and its income that is best for you.

b) The second and third pics shows the per capital income and average rent of states where marijuana is fully illegal or used for medical purpose. Lets say for instance you've always wanted to move to New York but the legality status is medical i.e. you can't smoke but only use only for medical purpose. The per capital income and rent can help you decide if you want to move to New York or find some where else.

Apart from just relocating to a state in America, you might just find you self visiting friends and family or going for a business trip in state where marijuana is fully illegal and also a criminal offense. To avoid breaking the law here the number of states and also the name of the states where possession of marijuana is a criminal offense.

Lets Check It Out;

a) The first pics shows the states that have criminalized and decriminalized the use of marijuana. True means It is not a criminal offense in 32 states and False means it is a criminal offense in 19 states.

b) The second pics show the 19 states that have criminalized the use of weed. Just incase you find yourself in one of theses states try as much as possible not to break the law. Whether for medical use (unless approved by a doctor) or recreational use do not be caught with marijuana.


I hope my client is happy with my findings

Thank You For Your Time

More Data Analysis Coming Your Way

Peace.

Absolutely didn't expect this. Expected another stoner fantasy. It's been nice watching your portfolio grow over the year (s).

Can you leave the SQL behind and let's see your visuals? Would be more stimulating.

Nice.

For the weed analysis, visuals. Didn't know there's more.

BRATISLAVA:
Absolutely didn't expect this. Expected another stoner fantasy. It's been nice watching your portfolio grow over the year (s).

Can you leave the SQL behind and let's see your visuals? Would be more stimulating.

Nice.

For the weed analysis, visuals. Didn't know there's more.

Thanks Man I appreciate. And for the visuals; definitely. I'll be working on it. Using Power BI, more findings can be gotten from this weed dataset. Thanks once again.

jamerflepz:
Thanks Man I appreciate. And for the visuals; definitely. I'll be working on it. Using Power BI, more findings can be gotten from this weed dataset. Thanks once again.

By all means, do. I'll check on your posts when you do.

Nice work.