Why is wine so expensive in New York?

[ElinaMak]

The fast answer is because New York is not California...*

So, my second research starts from the basic question: "Why is wine so expensive in New York?"

In order to reply to this question I need to examine demand / offer, exports / imports of wine in US.

I built my own dataset as it combines data from different sources and as I didn't find any csv / excel with all information I wanted.

It would be nice to compare them with statistics from Europe even though the data from the European Commission do not make it an easy task...

Also the measurements change, Europe uses the "liter" or "hectoliter", US the "gallon".

The charts I will use, are simple bar charts because I believe they are the simplest for the audience and pass the message directly.

From the research so far, I found out that California produces an average of 85 percent of total U.S. wine production.

Checklist

This checklist must be completed before you submit your draft.

• [x] I have already spent time with my data set, opening it, exploring it, etc
• [ ] I have created a "DIARY.md" file to save links and list all of the terrible, no good problems I come across
• [ ] My issue links to my data set(s)
• [x] My issue links to my code repository
• [x] My issue explains what I'd like to explore in the data set
• [x] My issue includes images - either inspiration or what I've done so far

[ElinaMak]

Few updates

the notebook: https://github.com/ElinaMak/data_studio/blob/master/Why%20is%20wine%20expensive%20in%20New%20York%3F.ipynb

With a little bit of accompanying text: https://github.com/ElinaMak/data_studio/blob/master/Why%20wine%20is%20so%20expensive%20in%20NY.pdf

[jsoma]

• I'm not sure my eyes work any more after seeing that dashboard
• Smaller axis labels! Although honestly having no axis labels is my preference, and instead making it be "0 gallons" / "80 gallons", let's at least change your defaults to be a bit smaller.
• ax.legend_.remove() is your friend to get rid of legends that just take up space

In order to reply to this question I need to examine demand / offer, exports / imports of wine in US.

Honestly you should probably just call up someone who sells wine for a living and ask them if they know! They'll point you in the right direction as to why, and then you can find the data. Thirty minutes of calling places and asking will save you 20 hours of scraping and cleaning maybe-useless datasets!

[ElinaMak]

I am not sure which dashboard are you referring to? The EC one? This was a screenshot of how messy they publish the data, I didn't do it....

Also I think you are commenting on the first "issue" not my update...

[playfairbot]

Howdy! I'm a little robot, just having a little look around.

You need some feedback, let me summon @collleenwang, @vpenney, @linleysanders for you

It looks like we need to fix up your your update a little bit! Edit it by clicking the pencil in the top right-hand corner. It requires:

• New, updated content for your project
• The checklist (be sure you're using the template!)
• Exported, cleaned-up visuals of your project. Screenshots are okay if it's interactive. Links are no good, though - upload by editing your post and dragging the image in.

Maybe you just didn't use the template? If not, edit your comment, cut and paste the template in, and then fill it out.

[linleysanders]

Wow, you're a girl after my own heart with this topic. I understand that your charts are stating how America is exporting more wine annually, importing a ton, and California makes up a bulk of American production, but was there any data that showed how wine is cheaper closer to the source? Just curious since that was the original question, but I know these things change.

• I think you could use more space after your headline by adding "pad=30" to your title
• I figured out you can change the legend location and spacing by modifying this code if that helps at all: _plt.legend(loc="upper right", bbox_toanchor=(1.25,1))
• On the third one, American Wine Exports, I'd make the headline bigger than the axis titles so that the hierarchy draws your eye to the top
• I think subheads below the titles would help tie all of the charts together!

[vpenney]

Nice topic! I agree that the axis labels could be a bit smaller and some space between the headline and legend could help visually.

• For the bar charts of U.S. production vs. California production, have you considered a stacking bar chart showing the percentage of the total U.S. wine production that CA is responsible for?

• If you're still interested in wine is more expensive in NY, maybe take a look at alcohol excise taxes or transportation costs (anything liquid is going to be heavy and therefore expensive to ship, especially over land).

[collleenwang]

I do like this topic! Comparing with the displayed charts, I'm more interested in the country rank tables, why don't you list them in a colorful chart way?

[ElinaMak]

Final

Published website version: https://elinamak.github.io/FirstProject/

Code repository: https://github.com/ElinaMak/data_studio/blob/master/Why%20is%20wine%20expensive%20in%20New%20York%3F.ipynb

What did you find to be the most difficult part of this project?

Finding the right data.

Are you satisfied with what you produced? Is there anything you would like to change or improve?

Have better wine imports data for US and some reporting / interviews from local wine makers and wine merchants.