There's no need to be shy about asking: why is #CSV better?
Our new course ‘Quality and Consistent Data with #OpenDataEditor’ takes you by the hand.
In this lesson, you learn the anatomy of CSV and why it's a key format for #opendata.
There's no need to be shy about asking: why is #CSV better?
Our new course ‘Quality and Consistent Data with #OpenDataEditor’ takes you by the hand.
In this lesson, you learn the anatomy of CSV and why it's a key format for #opendata.
"Excel hates CSV - It clearly means CSV must be doing something right"
-- xan, the #CSV magician https://github.com/medialab/xan/blob/master/docs/LOVE_LETTER.md
#TIL about #Visidata: https://jsvine.github.io/intro-to-visidata/
If you ever need to wrangle, filter, sort, edit, navigate, subset or get basic statistics out of #data in #CSV format (comma-separated values), this is a super useful piece of software. It takes raw data and implements a very handy subset of functionality from spreadsheets directly on top, with both a keyboard (modal Vi-style operation) and menu/mouse driven operation.
Nice one to have in the toolchest.
The Week in Review, Edition 85 (2025-13)
Topics:
New Feature for bikerouter.de: Short Links and Improved QR Codes
Automatically Ping the Uberblogr Webring on Blog Updates
New Hose for Workshop Dust Extractor
Discovered Unknown Wood Type
snips.sh: SSH-Based Pastebin, Opengist as Another Alternative to GitHub Gists
CLI Tool of the Week: xsv
Listened to This Week: SOS U-Ground B2B Tobias Sommer, Taberia
#Wochenrückblick #Bikerouter #QRCode #UberBlogr #Webring #Workshop #Woodworking #Wood #Woodturning #snips #Gist #Gitea #GitHub #Opengist #CLI #Shell #xsv #CSV #TSV #Techno
Wochenrückblick, Ausgabe 85 (2025-13)
Themen:
Neues Feature für bikerouter.de: Kurzlinks und verbesserte QR Codes
Automatisch bei Blog-Updates den Uberblogr-Webring pingen
Neuer Schlauch für die Absaugung in der Werkstatt
Unbekannte Holzart entdeckt
snips.sh: SSH-basiertes Pastebin, Opengist als weitere Alternative für GitHub Gists
CLI-Tool der Woche: xsv
In dieser Woche gehört: SOS U-Ground B2B Tobias Sommer, Taberia
#Wochenrückblick #Bikerouter #QRCode #UberBlogr #Webring #Absaugschlauch #Werkstatt #Woodworking #Holz #Drechseln #snips.sh #Gist #Gitea #GitHub #Opengist #CLI #Shell #xsv #CSV #TSV #Techno
#Fediverse を調べています。
(2025年3月分)
/api/v1/instance/peers
で、各 domain の繋がりを調べ、
生きている domain に対し、
/.well-known/nodeinfo
で nodeinfo に取得方法を調べ、nodeinfoの中の
domain名、アプリ名、バージョン、アカウント数(ユーザー数)、MAU(1ヶ月アクティブユーザー数)、HYAC(半年間アクティブユーザー数)、投稿数
を取得しています。
peers では 105,521 件(前月10,3860件)
通信可能 では 54,008 件(前月53,122件)
nodeinfo可能では 27,550件(前月27297 件)
でした。
(前回スキャンで存在し、今回スキャンで落ちている domain について、再度nodeinfoを集めました)
データは
https://github.com/ottoto2017/fediverse
の
target20250321.csvで upload
Not sure who needs this (apart from me, of course), but just pushed my rof2csv tool:
https://github.com/branch-predictor/rof2csv
Use it to convert Rigol's ROF files (produced by Rigol DP800 series programmable power supplies) into CSV files that can be fed into Excel or LibreOffice Calc.
#programming #SoftwareDevelopment #rigol #rof #csv
Days since ad-hoc #csv parsing has ruined my day:
Looking forward to #DFD2025. What #FLOSS tools do you use to read #CSV files? Any FOSS #ETL tools to copy CSVs to/from databases? Is there a #Free, #OpenSource ODBC driver for connecting to CSV files?
#AskFedi #AskFediverse #DFF
Dans les coulisses du fonds #ÉricRouleau : faciliter la #rétroconversion dans #Calames avec #Python #Archives #MMSH
https://phonotheque.hypotheses.org/49828
Un billet qui décrit précisément l'écriture d'un bout de #code pour passer d'un #CSV à des notices #EAD, avec en prime les infos sur un type incroyable Éric Rouleau
Comparing #CSV data files, are there any great (offline) tools? Ideally somehow visual, like there are plenty of nice visual interfaces for "diff" output for source code. #analytics #dataQuality
[Utiliser des données en #opendata n°6] Vous avez téléchargé des données et souhaitez ouvrir le fichier.
L'équipe de data.gouv.fr propose un rappel de quelques options possibles pour les formats #CSV, #JSON, #XML, #GeoJSON, #shapefile et #KML dans son guide : https://guides.data.gouv.fr/reutiliser-des-donnees/guide-traitement-et-analyse-de-donnees/manipuler-des-donnees/ouvrir-des-donnees
• Customizable configuration with rules, allowlists, and entropy checks to reduce false positives
• Flexible reporting in multiple formats (#JSON, #CSV, #JUnit, #SARIF) with custom template options
https://github.com/gitleaks/gitleaks
The oldschool web/tech side of me is smiling.
"A love letter to the #CSV format"
https://github.com/medialab/xan/blob/master/docs/LOVE_LETTER.md
"Or why people pretending CSV is dead are wrong... #Excel hates CSV which clearly means CSV must be doing something right."