shakedown.social is one of the many independent Mastodon servers you can use to participate in the fediverse.
A community for live music fans with roots in the jam scene. Shakedown Social is run by a team of volunteers (led by @clifff and @sethadam1) and funded by donations.

Administered by:

Server stats:

268
active users

#csv

0 posts0 participants0 posts today

Oh boy, this is gonna be fun.

I need to parse #CSV in #Java. Parsing it into String[][] is easy enough, but here's the hard part: I also need to parse the numbers in the CSV file (into a double, BigDecimal, or the like), and those numbers could be formatted in any of the myriad number/currency formats that Excel might produce.

Web searching isn't getting me very far, and Excel itself is of course closed source so I can't look there.

Any advice would be much appreciated!

#Vivaldi :vivaldi_red:#ReadingList#CSV でのインポート・エクスポートに対応してるから、サービス終了する #Pocket からエクスポートしたデータをインポートできるかもしれない。
CSV のフィールドとかを揃えるために事前にごにょごにょやる必要はあるかも

A solid 24-hour sprint later -- I had to wrangle data from tables in PDFs to get a solid baseline to work with (#csv here: pastebin.com/JGLxQMbT) -- and I've got all of the polling stations for tomorrow's #election in Tarrant county mapped out in #osm #OpenStreetMap :D

overpass-turbo.eu/s/23ok

I experimented a bit within the polling_station:* namespace. Thinking I might be settling into a pattern, at least for #Texas. I dunno if I want to build up explicit relations between polling places and their (typical) associated buildings/areas or not. So for now, I chucked the relation data in a tag instead.

Ideally, future elections won't be such a pain to get bootstrapped; most polling stations tend to stay the same across elections.

Replied in thread

@0xF21D it is a #TSV file, but aside from out-commented lines, all entries are just one after the other, thus should just import fine.

I don't use #CSV as I want to be able to write full sentences in data fields and standardized on this since some fields may need #commas and #spaces, whereas #tabs work perfectly fine as seperators...

What are some of your favorite #Open #Document formats? Do you use #csv, #ical, #html and #css, odt, xml, json, #wav, #flac regularly? What #Free formats do you rely on? You can also use plain text files for a variety of functions from telling stories and taking notes to creating #todo.txt or similar files or #emacs org mode files. Have a favorite use for plain text files? Share it with us. Join us in celebrating #DocumentFreedomDay on March 26, 2025. #DFF #FLOSS

@falcennial it's helpful for #sysadmins and anyone who is running their own #firewall (regardpess if WAF, hosted/managed or DIY/bare metal), as they can just pull that Feed-URL to (un)block stuff automatically...

  • I wished #Mastodon #developers would realize that supporting a Blocklist Feed is kinda crucial function as noome wants to spin up *yet another git just to diff&merge stuff because they only offer "add" and "replace" when it.comes to #CSV / #TSV input.
GitHubBlocklist Feed Support · Issue #28605 · mastodon/mastodonBy kkarhan

Today I used a #tool I wrote last year, in earnest, and I think it saved me a good few hours of effort. 😇

JsonToSmartCsv can reshape #JSON data into #CSV by following predefined rules. You can use it to flatten rich objects into human readable rows.

instantiator.dev/post/hammer-j

instantiator.dev · Hammering JSON into CSVjson-to-smart-csv is a tool to help build CSV records from arbitrary JSON…

Example #164: Piechart SVG generation/visualization of CSV data using thi.ng/geom & thi.ng/csv

(Like the previous/recent hexgrid example, this one too relies on still unreleased features & API updates of the geom package. If you want to try it out yourself, currently you'll need to clone & build the repo yourself, see instructions in the readme/wiki...)

Demo:
demo.thi.ng/umbrella/geom-csv-

Source code:
github.com/thi-ng/umbrella/blo

Replied in thread

@rmflight
I just took a look at this based on your recommendation. It's kind of pretty. But I would never use it because it is not scriptable. Scriptable data manipulations (such as header cleanup, column and row filtering) are QA-able, repeatable, and easily modified for similar data sets.

[#archives] C'est discret MAIS les données de l'inventaire de la sous-série 2U #Courdassises du #Morbihan 1811-1940 sont décrites au dossier ET téléchargeables en #CSV ! rechercher.patrimoines-archive (2e icône inventaire pdf)

De quoi :
- faire des stats faciles (plus de 5200 individus jusqu'en 1921, avec des vols, des faux, meurtres ou encore infanticides, attentats à la pudeur)
- prémacher le travail pour croiser avec #généalogie

#justice #faitsdivers #archives #histoire @archivistodon

Patrimoines & Archives départementales du MorbihanCour d'assises du MorbihanPrésentation des fonds et collections des Archives du Morbihan par grandes thématiques.
Replied in thread

@chessert @VoxofGod @CassandraZeroCovid @null

Weird, cuz TSV also works on infosec.space , mstdn.social and social.tchncs.de ...

After all, I merely put one domain per line and use # to put comments in entire lines. So the only " failing " entries are the comment lines...

The difference between #TSV and #CSV is the usa of #Tabs instead of #Commas and in all tests I could.perform this doesn't make a difference as it's basically #ASCII-compatible #UTF8-formatted #Text without even any indentations whatsoever...

Mastodon hosted on infosec.spaceInfosec.SpaceA Mastodon instance for info/cyber security-minded people. This instance blocks threads.net

#HowToThing #008 — CSV parsing & filtering into structured data via thi.ng/csv and creating a multi-plot data visualization via thi.ng/viz (along with a range of other helpful packages for various side aspects).

The attached visualization shows a lin-log plot of new COVID cases between March 2020 - Dec 2021:

- Daily world total as line plot
- UK (red) and USA (blue) cases as interleaved bar plots

(All data from: ourworldindata.org/coronavirus)

Full source code:
gist.github.com/postspectacula