Code Monkey home page Code Monkey logo

2016-06_spreadsheets's Introduction

2016-06_spreadsheets

Talks given at

Slides

Browse on Speakerdeck

PDFs here in this repo

People, credits, links, inspiration, etc.

Me, in other places

csv, conf, v1
http://csvconf.com/2014/

Felienne Hermans

Rich FitzJohn

"50 million accountants use monads in Excel. They just don't go around explaining monads to everyone..."
https://twitter.com/tomaspetricek/status/687947134088392704

Felienne Hermans shows an example of monads in Excel @14:45 in this talk: https://vimeo.com/162206549

My middle finger gif re: Excel having had reactivity for years
https://twitter.com/JennyBryan/status/713198745022693377

Not So Standard Deviations (NSSD) Podcast by Hilary Parker and Roger Peng
Episode 9 - Spreadsheet Drama
https://soundcloud.com/nssd-podcast/episode-9-spreadsheet-drama

Philip Guo https://twitter.com/pgbovine blog posts about command bullshittery

Sources for approximate facts re: Excel, R, Python usage

Tools used in /r/DataIsBeautiful posts
http://www.randalolson.com/2016/03/11/what-data-visualization-tools-do-rdataisbeautiful-oc-creators-use/

Donald Rumsfeld: "As you know, you go to war with the army you have, not the army you might want or wish to have at a later time."

Chris Albon https://twitter.com/chrisalbon riffing on that w/r/t to a crazy web form: "You go to production with the features you know, not the features you need."
https://twitter.com/chrisalbon/status/720613507457093632

Me https://twitter.com/JennyBryan/status/735671032636276736: "The more spreadsheets I look at, the more I realize ppl use them like I use a git repo. It's how they manage data + "code" + figs & results."

Thread of CRAZY spreadsheet stories, in response to my tweet:
https://twitter.com/JennyBryan/status/722954354198597632

The Kinsey report:
https://en.wikipedia.org/wiki/Kinsey_Reports
https://en.wikipedia.org/wiki/File:Kinsey-Male.jpg

Enron corpus:

Excel color-formatted table with exploding pie chart:
http://pubpages.unh.edu/~mjp262/excel_spreadsheet.jpg

Dog shaming

xkcd comic:
http://xkcd.com/1667/
http://imgs.xkcd.com/comics/algorithms.png

Advice re: organizing data in spreadsheets

Examples of new spreadsheet implementations

Some of the other csvconf talks from Stencila contributors

Tweet: If your collaborator asks, “In what form would you like the data?” you should respond, “In its current form.”
https://twitter.com/JeanVAdams/status/707241263645392896

Some of the other csvconf talks re: dealing with data in suboptimal form

TableToLongForm R package

R packages that talk to Excel (there are even more!):

Mango blog post about R packages to read/write Excel:
http://www.mango-solutions.com/wp/2015/05/r-the-excel-connection/

googlesheets package

rsheets organization holds several packages, mostly WIPs

David Robinson RPub tidying one of the Enron sheets
http://rpubs.com/dgrtwo/tidying-enron

UBC Master of Data Science program
http://mds.science.ubc.ca

2016-06_spreadsheets's People

Watchers

 avatar  avatar

Recommend Projects

  • React photo React

    A declarative, efficient, and flexible JavaScript library for building user interfaces.

  • Vue.js photo Vue.js

    🖖 Vue.js is a progressive, incrementally-adoptable JavaScript framework for building UI on the web.

  • Typescript photo Typescript

    TypeScript is a superset of JavaScript that compiles to clean JavaScript output.

  • TensorFlow photo TensorFlow

    An Open Source Machine Learning Framework for Everyone

  • Django photo Django

    The Web framework for perfectionists with deadlines.

  • D3 photo D3

    Bring data to life with SVG, Canvas and HTML. 📊📈🎉

Recommend Topics

  • javascript

    JavaScript (JS) is a lightweight interpreted programming language with first-class functions.

  • web

    Some thing interesting about web. New door for the world.

  • server

    A server is a program made to process requests and deliver data to clients.

  • Machine learning

    Machine learning is a way of modeling and interpreting data that allows a piece of software to respond intelligently.

  • Game

    Some thing interesting about game, make everyone happy.

Recommend Org

  • Facebook photo Facebook

    We are working to build community through open source technology. NB: members must have two-factor auth.

  • Microsoft photo Microsoft

    Open source projects and samples from Microsoft.

  • Google photo Google

    Google ❤️ Open Source for everyone.

  • D3 photo D3

    Data-Driven Documents codes.