Statwing integrates with Quandl

Next time you use Quandl, click the “Statwing” button to statistically analyze a Quandl dataset.

Let’s say you were looking at this Quandl dataset of bitcoin prices over time.

Screen Shot 2014-09-29 at 9.21.36 PM Screen Shot 2014-09-29 at 9.21.14 PM
You’d click the “Statwing” button in the right sidebar, find yourself in Statwing, and then start playing with the data.

In two clicks you can get a nice histogram and descriptive statistics for a column of values, like Bitcoin trade volumes:

volume-histo

 

Or click two more times and find out if a trend is statistically significant:

Screen Shot 2014-09-29 at 8.59.42 PM

 

time-stats-output

Screen Shot 2014-09-29 at 8.44.36 PM

 

 

 

 

 

 

 

 

 

 

 

 

 

Or create a new variable in a few seconds, like transforming dates to days (for example, “9/29/2014″ to “Monday”):

new-var-date

 

Or bucketing the days of the week into “Weekday” and “Weekend”, then seeing how they differ:

weekday-vs-end2

There’s a lot more to explore, but we’ll leave that to you. Enjoy!

Creating new variables and cleaning data in Statwing

You can now create new variables for analysis in Statwing: Type Example Bucketing numbers into groups 6-7 → “Satisfied” 3-5 → “Neutral” 1-2 → “Unsatisfied” Grouping categories together USA & Mexico & Canada → “North America” Colombia & Venezuela & (etc.) → “South America” Mathematical functions and formulas =median(Score1, Score2, Score3) → median of theContinue Reading

Yelp Dataset Challenge

Yelp is awarding $50k+ in prizes for interesting analyses as part of its Dataset Challenge.We’ve loaded its dataset of ~42k businesses, their ratings, and their attributes into Statwing to make them easy to explore.Check it out.

Data from Defense Department Program 1033

The New York Times just released a dataset with every order from state and local governments for surplus military items (the result of a Freedom of Information Act request).We’ve loaded the dataset into Statwing to make it easy to explore.Check it out.

Every MLB pitch thrown in 2014

We found a really fun dataset to play around with: every Major League Baseball pitch thrown so far in 2014, as tracked by the PITCHf/x system. It includes everything you’d want to know about a pitch: it’s speed, the type of pitch, how much it broke on each spatial axis, how many men were onContinue Reading

Could we beat Germany if players born in December weren’t discriminated against?

Players in the 2014 World Cup tended to be born in the earlier months of the year:What gives?Most countries’ youth soccer teams are broken up such that all players born in a given year are in one age group together. Players born in January are 11 months older than December-born players on their same team.Continue Reading

Statwing Pricing Change

We’re changing our pricing structure:We’re eliminating the free Public planThe Silver plan will now be $50/month, up from $25/monthSilver plan users will remain at $25/month until August 1, at which point any new charges will be $50/month. We’ll email again at that time to remind you.Existing Public plan users will also continue to have free accessContinue Reading

Results of Stack Overflow survey of 20,000 software developers

There’s some fun stuff in this dataset. We’ll skip the pre-analysis and let you dive right in yourself: https://www.statwing.com/demos/dev-survey-2 Enjoy!

Visualizing crime in Chicago

We just put up a fun guest blog post over on Socrata’s blog: http://www.socrata.com/blog/crime-time-visualizing-crime-data-chicago/ Here’s a little teaser from that post, the daily rhythms of various crimes in Chicago: Enjoy the post!

Results of HN poll: Half think bootcamp grads as good as fresh CS majors

We wanted to get a sense of how well code bootcamps prepare their graduates for work. So we asked Hacker News readers who had worked with a graduate to evaluate them.(See methodology) Most importantly we asked, “Would you rather work with the graduate, or the median fresh-out-of-college Computer Science-major you’ve worked with?”  While on averageContinue Reading