search

jsoma / data-studio-projects

12 stars 18 forks source link

[Project] Cryptocurrency ICOs in 2018 #309

Open angelareplica opened 6 years ago

angelareplica commented 6 years ago

Please complete all of the following sections, or the ghost of Joseph Pulitzer will spookily dance around your issue! A completed version of this template can be found at https://github.com/jsoma/data-studio-projects/issues/1

Pitch

Summary

In 2017, a lot of people, myself included, wrote about the wildly unregulated industry surrounding Initial Coin Offerings (ICOs), the cryptocurrency analog of IPOs. Cryptocurrency markets soared throughout 2017, into January of this year, but have since crashed spectacularly. Coverage has died down -- but have ICOs? I wanted to look at ICOs in 2018, so I scraped the "Completed ICOs" section of Smith & Crown's website, a reputable curated list of ICOs. It's certainly not representative of the entire market, but it should provide a decent picture, especially of more "legitimate" projects. I'd like to look into how much ICOs have made in 2018, comparing it to previous years. I'd also like to look into what kinds of projects have launched/completed ICOs in 2018.

Details

Possible headline(s): Initial Coin Offerings Have Quietly Raised Billions of Dollars in 2018

Data set(s): https://github.com/angelareplica/data-studio/blob/master/code/07-icos/smith_crown_scraped_8_18_2018.csv

Code repository: https://github.com/angelareplica/data-studio/tree/master/code/07-icos

Possible problems/fears/questions: Unless it's included in the one-line summaries of projects, the data don't include what blockchain(s) projects are building on (Ethereum, Bitcoin, etc). It'd be ideal to have that info for a more comprehensive idea of what ICOs look like now.

Work so far

Hideous cursory matplotlib charts that I'll make prettier for my next update, along with more stuff.

screen shot 2018-08-20 at 11 15 33 pm screen shot 2018-08-20 at 11 15 43 pm

Checklist

This checklist must be completed before you submit your draft.

angelareplica commented 6 years ago

Update

Your project content: images/words/etc

I don't really have updated visuals besides some light illustrator work. I'm still trying to figure out what to do with my data.

Amount of money made by ICOs by year: icos_by_year_edited

2018's biggest ICOs: biggest_icos_2018_edited

Any changes in direction or topic?

Problems/Questions

Not really sure what to do next, but playing around with some things -- will maybe try to plot an Ethereum price line chart with a bar chart of how much ICOs raise by month.

Biggest problem is that the data is really imperfect, since Smith + Crown is curated, and not all the dates are updated after ICOs finish.

Checklist

sarahslo commented 6 years ago

nice typography. one thing tho, if you have a scale on your chart you don't also need to have numbers on your bars. one or the other. belt, or suspenders.

angelareplica commented 6 years ago

Thanks for the feedback, Sarah!

Update 2:

Update

Your project content: images/words/etc

I decided to turn my bar chart from the last update into a stacked chart to show how many ICOs are completed each year. Not sure if this was the right decision -- maybe it could evolve into the regular bar chart, with an interactive component that turns it into the stacked chart? idk.

icos_by_year_stacked_edited

And the top 10 most common words (not including prepositions or articles). Haven't edited this one in Illustrator yet, hence the horrible appearance. Also need to lose the x/y axes and clean it up so that contract/contracts and blockchain/blockchain. are counted together.

freq_words_treemap

Any changes in direction or topic?

Problems/Questions

Checklist

angelareplica commented 6 years ago

Final

Project visuals/text

icos_by_year_edited

icos_by_year_stacked_edited

biggest_icos_2018_edited

freq_words_treemap2_edited

Details

Headline: Initial Coin Offerings Have Quietly Raised Billions of Dollars in 2018

Published website version: https://angelareplica.github.io/ds-icos

Code repository: https://github.com/angelareplica/data-studio/tree/master/code/07-icos

Final data set(s): https://github.com/angelareplica/data-studio/blob/master/code/07-icos/smith_crown_scraped_8_18_2018.csv

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

Working with data that only gives a glimpse into what ICOs are like. Also, could not figure out how to plot a line chart of Ethereum's price over a bar chart of the amount of $$ ICOs rasied per month. (Both were plotted with datetime + resampling.)

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

I don't really think my charts are super meaningful. Would definitely like to keep working on them.

Checklist