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.
Throwing this one out there. I’m scratching my head. I am just on the trial of Microsoft Reporting Server to see if I can find a workaround for a client. Unable to alter a CSV column header to suit our import needs. Anyone know of a fix or suggestion? Trying to push a forward slash in but CLS compliance is kicking my butt along with the “trial” version of SSRS not allowing me to modify the config file for a CSV no header output… #ssrs #csv
"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
Parsing CSV with units in the header · Issue #166 · hgrecco/pint-pandas
https://github.com/hgrecco/pint-pandas/issues/166
Now we can read a #csv file with a header like `time / s,mass / g` into #pandas and call `.pint.quantify()` to get a #dataframe in which the columns have #units as in #Pints !
Handy for CSV restricted to single-row headers, as in Confluence Databases and Microsoft Lists.
#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
#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
#Wochenrückblick #Bikerouter #QRCode #UberBlogr #Webring #Absaugschlauch #Werkstatt #Woodworking #Holz #Drechseln #snips.sh #Gist #Gitea #GitHub #Opengist #CLI #Shell #xsv #CSV #TSV #Techno
XAN: A Modern CSV-Centric Data Manipulation Toolkit for the Terminal
How to Split Comma-Separated Values with Multiple Items in Brackets?
Efficiently parsing comma-separated values (CSV) in DB2 LUW strings, even with delimiters within the data, is now possible! Learn how XMLTABLE handles complex string formats for accurate data extraction. #DB2 #XMLTABLE #StringParsing #CSV #DataExtraction #DB2LUW
https://tech-champion.com/programming/how-to-split-comma-separated-values-with-multiple-items-in-brackets/
...
Unreal Engine and Version Control https://frederickkdp.github.io/game_dev/ue_journal/2025/03/28/ue-vc.html #UnrealEngine5 #version_control #csv
#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
Oh, the sheer #romance of spreadsheets—because nothing says "I love you" like wrestling with comma placement while your eyes bleed from staring at mismatched rows. GitHub's love letter to CSV: a tale of passion, punctuation, and why #AI needs #therapy.
https://github.com/medialab/xan/blob/master/docs/LOVE_LETTER.md #spreadsheets #CSV #GitHub #humor #HackerNews #ngated
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: