TOOL & DATA

プログラマーではない人でも使える、データ分析や可視化のツール／アプリの紹介です。
作例やデータフォーマットについても出来るかぎり記載しています。

Transcript

1. Code For Tokyo πʔϧͱσʔλ TOOL & DATA
2. TOOL πʔϧ
3. CARTO https://carto.com/ ஍ཧۭؒ https://ukinedori.carto.com/viz/eb85cf30-3526-11e6-af13-0ea31932ec1d/public_map ࡞ྫ ΢ΣϒΞϓϦ https://carto.com/gallery/ ΪϟϥϦʔ
4. https://carto.com/docs/carto-editor/datasets/ σʔλϑΥʔϚοτ • Dropbox • Google Drive • ArcGIS ΢ΣϒαʔϏε • CSV, XLS, ZIP, KML, GPX ϑΝΠϧϑΥʔϚοτ ίϩϓϨεϚοϓΛ࡞Γ͍ͨ ৔߹͸஍ܗσʔλΛಡΈࠐΉ ඞཁ͋Γɻ • http://maps.gsi.go.jp/ development/ ichiran.html ࠃ౔஍ཧӃͷ஍ཧӃλΠϧΛಡ ΈࠐΉ͜ͱ͕Մೳ
5. • CSV • TSV • Microsoft Excel • Google Docs • Apple Numbers σʔλܗࣜ https://github.com/densitydesign/raw/wiki/FAQs#what-format-should-i-use-for-my-data σʔλϑΥʔϚοτ ֤छνϟʔτʗάϥϑ ΢ΣϒΞϓϦ RAW http://raw.visualizing.jp/
6. https://bl.ocks.org/enjalot/c0e1634fb919c37575b8 1. ϒοΫϚʔΫϨοτΛΠϯετʔϧ͢Δ ΢ΣϒΞϓϦ BlockBuilder http://blockbuilder.org/ https://bl.ocks.org/mbostock/6264239 2. fork͍ͨ͠gistΛbl.ocks͔Β୳ͯ͠දࣔ͢Δ http://blockbuilder.org/mbostock/6264239 3. block builder্ͰforkϘλϯΛԡ͢ D3.jsͷαϯϓϧΛfork
7. • ݁ՌΛ΢Σϒʹެ։͢Δ͜ͱΛ৚݅ʹແঈͰར༻Ͱ͖Δɻ ػೳ ֤छνϟʔτʗάϥϑ σεΫτοϓΞϓϦ Tabeau Public https://public.tableau.com/s/ • https://public.tableau.com/s/gallery ࡞ྫ
8. σʔλϑΥʔϚοτ • .xlsɺ.xlsx, .xlsm Excel • .txtɺ.csvɺ.tabɺ.tsv ςΩετϑΝΠϧ • .sas7bdat SASϑΝΠϧ • .sav SPSSϑΝΠϧ • .rdataɺ.rda RϑΝΠϧ
9. • σʔλͷதͷݴ༿΍ͦͷ࢖ΘΕํΛݕࡧ • ؔ࿈͢Δݴ༿Λநग़ • ৚݅Λࢦఆͯ͠ूܭ͢Δ • ֊૚తΫϥελʔ෼ੳ ػೳ • ଟ࣍ݩई౓ߏ੒๏ʢMDSʣ • ରԠ෼ੳ • ڞىωοτϫʔΫ • ࣗݾ૊৫ԽϚοϓ • จॻதͰίʔυ͕ଟ͘ग़ݱ͍ͯ͠ΔՕॴ • จॻͷΫϥελʔ෼ੳ RΛཪͰಈ͔͢෼ੳ ςΩετܕσʔλ ςΩετ෼ੳ σεΫτοϓΞϓϦ KH Coder http://khc.sourceforge.net/ • http://khc.sourceforge.net/diagram.html ࡞ྫ
10. Exploratory ࡞ྫ http://docs.exploratory.io/tutorials/quick-start.html http://qiita.com/tags/Exploratory σʔλ෼ੳ σεΫτοϓΞϓϦ https://exploratory.io/
11. http://docs.exploratory.io/data_import.html σʔλϑΥʔϚοτ • CSV - Comma Separated Files • TSV - Tab Separated Files • Delimited Files • Excel • Statistical Files - SPSS / SAS / STATA • R Data Files - RDS, RData • JSON Local file import • Amazon Redshift • PostgreSQL • HP Vertica • MySQL • MariaDB • Google BigQuery • MongoDB Databases • Google Analytics • Google Spreadsheet • Twitter • Github Issues Cloud Apps • REST APIs / Remote JSON • Web Page Scraping Others
12. kumu ؔ܎ੑ ΢ΣϒΞϓϦ https://kumu.io/ • https://kumu.io/embed/483d0849245928cf40b48ea8a5c08821#whos-who ࡞ྫ
13. http://docs.kumu.io/guides/import.html σʔλϑΥʔϚοτ • Label • Type (optional) • Description (optional) For elements • From • To • Type (optional) • Label (optional) For connections csv or tsv
14. D3.jsͷαϯϓϧΛfork ΢ΣϒΞϓϦ BlockBuilder http://blockbuilder.org/ gist΁ܝࡌͯ͠ɺbl.ocks.orgͰදࣔ͢ΔϫʔΫϑϩʔΛϒϥ΢βͰ׬݁ͤ͞Δ
15. ϒϥ΢βʹද͍ࣔͯ͠ΔSVGΛμ΢ϯϩʔυͰ͖ΔϒοΫϚʔ ΫϨοτ ϒϥ΢β্ͰɺσʔλΛݩʹνϟʔτΛඳըɻSVGϑΝΠ ϧͱͯ͠μ΢ϯϩʔυͰ͖Δɻ ϒϥ΢β্ͰɺD3.jsͰίʔσΟϯάɻଞͷਓͷgist͔ΒϑΥʔ Ϋ͢Δ͜ͱ΋ɻBlockBuilderͰSVG Crowbar͸࢖͑ͳ͍ͷ Ͱɺ࢖͏ͱ͖͸Bl.ocks΁Ҡಈ͔ͯ͠Β࢖͏ɻ σβΠφʔ޲͚ • http://nytimes.github.io/svg-crowbar/ SVG Crowbar • http://creativedroplets.com/export-svg-for-the-web-with-illustrator-cc/ ΠϥϨͰ࡞ͬͨάϥϑΟοΫΛɺ΢Σϒ༻SVG΁ม׵͢Δίπ Illustrator to SVG • http://bl.ocks.org/jhellier/fb4772b5ca6f2a5ee51a • http://raw.visualizing.jp/ RAW • http://blockbuilder.org/ BlockBuilder
16. DATA σʔλ
17. https://github.com/codefortokyo/ndl-dataset-2016