Windows equivalent of head, pipe, write to file

100%

Windows equivalent of head, pipe, write to file

✓ Published0🌍 Public

Last edited May 14, 2015

Created on May 14, 2015

This example demonstrates a PowerShell command that reads the first 10,000 lines of a CSV file named `load_me.csv` and writes them to a new file called `test.csv`. It shows how to truncate a large dataset for quick inspection or further processing. The code uses the `Get-Content` cmdlet with the `-TotalCount` parameter to limit the line count, and pipes the output through `Out-File` to save the result. This approach provides a lightweight, command-line method for sampling data before loading it into a visualization tool.

AI-generated description

Similar vizzes

Loading thumbnail…

Gist f5904c4a8279840f341742d30c5d9a9e

This example demonstrates a PowerShell script that processes a text file by replacing caret characters with semicolons and writes the result to a new file. It shows a batch text-transformation workflow using the `Get-Content` cmdlet to read input in chunks of 1000 lines, a custom filter function `replace-chars` that applies the `-replace` operator, and `Add-Content` to append the processed lines to the output file. The script first checks if the output file exists and clears it to ensure a fresh write. The approach highlights pipeline-based file handling and character encoding preservation without additional libraries.

HHugoberry

58% match

Loading thumbnail…

Writing 10M lines of a query result to a table in Power Query via R

This example demonstrates how to write 10 million rows of a query result to a CSV file from Power Query by invoking an R script. It shows the integration of Power Query’s table generation with R’s file-export capabilities, specifically using the `R.Execute` function to run `write.csv` on a dataset. The Power Query code creates a list of numbers from 1 to 10,000,000 via `{1..10000000}`, converts it to a table with `Table.FromList`, and passes that table as the `dataset` parameter to the R script. The R script then writes the data to `d:\Downloads\out.csv`.

HHugoberry

56% match

Loading thumbnail…

Useful csvkit commands

This example demonstrates the versatility of csvkit, a command-line toolkit for working with tabular data, by presenting a collection of common workflows. It shows how to inspect, filter, merge, and transform CSV files using commands like `csvstat`, `csvcut`, `csvlook`, and `csvgrep`. The visualization highlights chaining commands with pipes to combine operations, such as using `csvsql` for SQL queries and joins across multiple files, `csvjson` to convert data into JSON or GeoJSON, and `csvstack` to merge datasets. It also covers importing and exporting data to and from SQL databases via `csvsql` and `sql2csv`, using Postgres and MSSQL connection strings.

WWilliamQLiu

55% match

Loading thumbnail…

Gist fdfdd728007f46922fdc

This example demonstrates how to read and write text and CSV files in Ruby, using the CSV library. It reads names from a text file into an array, prints the array, and then appends the word "likes" to each name before saving the result to another text file. The code also writes the original names to a CSV file. This is a file-processing utility rather than a data visualization, focusing on data manipulation and storage.

AAndrelton

55% match

Loading thumbnail…

Using R.Execute() in Power Query to export the contents of a table to CSV

This example demonstrates how to use R.Execute() in Power Query to export a table’s contents to a CSV file. The code generates a seed list of numbers from 1 to 1,000,000, converts it into a table, and then passes that dataset to R’s write.csv() function via the R.Execute() API. The R script writes the data to a specified file path. The visualization highlights the integration between Power Query and R, showing how R’s data-export capabilities can be invoked directly within a query pipeline, without additional manual steps.

HHugoberry

54% match

Loading thumbnail…

Fork of Loading and Parsing CSV Data

This example displays a simple text summary of a remotely loaded CSV file, showing its size in kilobytes, row count, and column count. The visualization uses D3.js version 5 and the `d3.csv` method to fetch and parse the data from a GitHub gist containing CSS named colors. The code also includes commented-out alternatives using `fetch` with async/await and a nested promise “pyramid of doom” to illustrate different approaches to asynchronous data loading, though only the `d3.csv` path is active.

Mmrthnkwn

54% match

Loading thumbnail…

Loading CSV

This example demonstrates how to load a CSV file and display a summary of its contents. It shows the file size in kilobytes, the number of rows, and the number of columns. The code uses D3 version 7’s `d3.csv` function to fetch and parse the data from a GitHub gist, then formats the message with `textContent`. It also includes an alternative async/await approach using `fetch` and `d3.csvParse`.

MMiguel Salazar

54% match

Loading thumbnail…

Add , to end of each line

This example shows a simple command-line text-processing workflow that appends a comma to the end of every line in a CSV file. The code uses the Unix stream editor `sed` with the substitution expression `s/$/,/g` to insert a comma at each line’s end, then redirects the output to a new file. It demonstrates a lightweight, scriptable approach for formatting tabular data without a visualization library, relying instead on standard shell tools. The data source is the input CSV file, and the rendering approach is plain text output rather than graphical display.

WWilliamQLiu

54% match