Skip to main content
SimilarExport ZIP
100%

CVS to JSONL example

✓ Published0🌍 Public
CCliffordAnderson
Last edited Nov 1, 2019
Created on Nov 1, 2019

This example shows a practical data-transformation workflow that converts a CSV file into JSONL format, producing one JSON object per line. It fetches a remote CSV file from a GitHub gist using the `fetch:text` function, parses it into records with `csv:parse`, and iterates through each record to build key-value pairs. The code distinguishes between integer and string values using `castable as xs:integer`, then constructs JSON maps with `xml-to-json` using XQuery 3.1. The output is unindented JSONL, suitable for streaming or line-oriented processing.

AI-generated description

Similar vizzes

Loading thumbnail…

CSV EV Data

This example shows a web page that attempts to load a CSV file containing electric vehicle data from a GitHub Gist. The page’s JavaScript uses the `fetch` API to request the remote CSV and logs the response object to the browser console. The code relies on the standard `fetch` method without using any external visualization libraries, and the page does not render any graphics or charts. The data source is a raw CSV file hosted on GitHub, and the current behavior is limited to demonstrating the initial network call.

Lltvonkoch
62% match
Loading thumbnail…

{$doc/RecordTitle/text()}

This example extracts bibliographic records from a collection of quarterly publications and serializes them into CSV format. It queries a local XML document store containing full-text articles, capturing fields such as title, publication, volume, issue, date, pagination, and a document link. The XQuery 3.1 script uses the `csv:serialize` function to convert the generated `element csv` tree into a delimited text file, demonstrating a straightforward data-wrangling pipeline for export and downstream analysis.

CCliffordAnderson
62% match
Loading thumbnail…

Gist 585199

This visualization loads an external CSV file and parses its rows into JavaScript objects, mapping each column name from an array to the corresponding values in each line. It handles quoted fields that contain commas by merging split segments until the quote count is even, and it logs warnings for malformed lines that do not match the expected number of columns. The example demonstrates a reusable CSV-asynchronous-loading helper, but does not show any charting, layout, or rendering code beyond the data preparation stage.

RRandomEtc
61% match
Loading thumbnail…

CSV Fetch and Parse

This example demonstrates a minimal workflow for fetching and parsing remote CSV data with D3. It shows the resulting dataset’s size in kilobytes, row count, and column count in large text on the page. The code uses `d3.csv` to load a CSV file from a GitHub gist and `d3.csvFormat` to measure its string length, while also logging the parsed array to the console. A commented-out alternative shows manual fetching via the Fetch API and parsing with `d3.csvParse`.

AAndres de la Garza
61% match
Loading thumbnail…

XQuery Conversion for MDID

This example demonstrates an XQuery conversion that transforms a collection of XML records into a structured CSV file, preserving field mappings for VRA and VU metadata. The code iterates over all records in a collection, extracts specific child elements and attributes, and constructs new `<record>` elements with standardized tags. It then wraps the records in a `<csv>` root element and uses the `csv:serialize` function with a map specifying `'header': true()` to generate a CSV with column headers. Finally, it writes the output to a file named "vrc.csv". The process relies on XQuery functions like `fn:collection()`, `fn:data()`, and `file:write()`, along with the `csv` module’s serialization API.

CCliffordAnderson
60% match
Loading thumbnail…

Loading and parsing CSV data

This example demonstrates the simplest possible workflow for fetching an external CSV file from a GitHub gist URL using JavaScript's built-in `fetch` API. The page shows no visualization, instead logging the raw `Response` object to the console, which would contain the CSV text if parsed. The code relies on the modern `fetch` function and a hardcoded URL pointing to a CSS color dataset hosted on GitHub, but it does not parse or render the data, making it a minimal first step toward loading external tabular data.

RRonandLion
60% match
Loading thumbnail…

Fork of Loading and Parsing CSV Data

This example demonstrates a minimal workflow for fetching and logging remote CSV data using the JavaScript `fetch` API. The program defines an asynchronous `fetchText` helper that retrieves text from a raw GitHub Gist URL, then chains a promise to output the CSV content directly to the browser console. It does not parse, transform, or visualize the data, and shows no charts or graphical output. The code relies solely on native `fetch` and promise handling, with no external libraries. A commented-out alternative using `response.text()` is included for reference.

AAnthony Grant
60% match
Loading thumbnail…

CSV Data Pt 1 - Loading and Parsing

This example demonstrates the initial step of working with CSV data by loading a remote file and outputting its raw contents to the browser console. It fetches a plain-text CSV file containing CSS color names from a GitHub gist using the Fetch API, wrapped in an async function called `fetchText`. The program then calls `console.log(text)` to display the parsed response, showing the data before any visualization or transformation occurs. The code includes a commented-out alternative using chained `.then()` promises, illustrating both fetch patterns for handling asynchronous text responses.

Jjulesgentry
60% match