Vienna.rb Talk Notes: Mining for Gold Using the World's #1 and Most Popular Data Format (w/ Ruby and CsvReader)

Gerald Bauer <[email protected]>
Newsgroups gmane.comp.lang.ruby.general
Message-ID <CAAxEZd83dQs1QKxu81jFE2VMLMR__kg9N22QG42-_fAr_syZuQ@mail.gmail.com>
Hello,

   the talk notes from yesterday's Vienna.rb meetup titled Mining for
Gold Using the World's #1 and Most Popular Data Format (w/ Ruby and
CsvReader) [1]. The contents reads:

- Q: The World's Most Popular Data Format?
  - Data Format Timeline / History - Past, Present, Future
  - Data Formats @ Statistics Austria
    - Triva Quiz: Who Invented the Space Character in Writing (and When)?
    - Triva Quiz: Who Invented the Space Character in CSV (and When)?
  - Data Formats @ Open Gov Data Austria
  - Data Formats @ Open Gov Data United States of America (U.S.A.)
  - Data Formats @ DataHub v1
    - Data Formats @ DataHub v2  - (Tabular) Data Packages
  - And the Winner is ... Lies, Damned Lies and Statistics
-  What's Comma-Separated Values (CSV) - One Format? Many Formats?
   - CSV Basics - What about commas in values?
   - CSV Basics - What about quotes in quotes?
   - CSV Basics - Many Formats / Dialects / Variants?
   - CSV Basics - Edge Cases
   - CSV Basics - Type Inference and Data Converters
- CSV Formats / Variants
  - CSV "The Right Way"
  - CSV "Strict"
  - CSV <3 Numeric
  - CSV <3 JSON
  - CSV <3 YAML
  - Database Export
    - PostgreSQL CSV
    - PostgreSQL Text
    - MySQL
- CsvReader Library Usage
  - What about type inference and data converters?
  - What about Enumerable?
  - What about headers?
  - What about symbol keys for hashes?
  - What about (typed) structs?
  - What about tabular data packages with pre-defined types / schemas?
- Triva Quiz - Mining for Gold - What's the country with the biggest
gold mining / production per year today?

  Happy data wrangling / mining with Ruby. Cheers. Prost.

PS: The talk slides from the 2nd talk titled Designing HexaPDF:
Iterarative Design, Orthogonality and Other Design Tools [2] by Thomas
Leitner

[1] https://github.com/geraldb/talks/blob/master/csv.md
[2] https://talks.gettalong.org/2018-10-viennarb

Unsubscribe: <mailto:[email protected]?subject=unsubscribe>
<http://lists.ruby-lang.org/cgi-bin/mailman/options/ruby-talk>
lmpx.com only provides a reader for public news (NNTP) servers. It is not affiliated with the servers or forums shown here and is not responsible for the content of articles, which is written by their respective authors.