Remove first line of a csv file with 'sed'

100%

Remove first line of a csv file with 'sed'

✓ Published0🌍 Public

Last edited Feb 9, 2015

Created on Jan 28, 2015

This example demonstrates how to remove the first line of a CSV file using the `sed` command-line utility. The code shows two separate commands: `sed -i '1d' file.csv` deletes the first line, while `sed -i '2d' file.csv` removes the second line. Both commands modify the file in place with the `-i` flag, and the `d` command specifies which line number to delete. The data source is a generic CSV file named `file.csv`.

AI-generated description

Similar vizzes

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

59% match

Loading thumbnail…

Windows equivalent of head, pipe, write to file

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.

WWilliamQLiu

51% match

Loading thumbnail…

Load CSV

This example demonstrates how to load and parse a CSV file using D3.js v4. The page fetches the classic Iris dataset from a local CSV file and uses the `d3.csv` method with a row-accessor function to convert numeric string values into numbers for all four measurement columns (petalLength, petalWidth, sepalLength, sepalWidth). The parsed data is then logged to the browser console. This simple yet essential example highlights D3's data-loading capabilities, showing how raw CSV text is transformed into an array of JavaScript objects with properly typed fields, ready for further visualization or analysis.

335degrees

50% match

Loading thumbnail…

Split large file by number of lines

This example demonstrates how to split a large file into smaller, more manageable pieces by specifying a line count. It shows the command-line utility `split` dividing a source file into multiple output files, each containing exactly one million lines. The code uses the `-l` flag to set the line limit and a prefix (`data.`) to generate sequential filenames like `data.aa`, `data.ab`, and `data.ac`. The rendering approach is purely text-based, illustrating a shell command and its expected output files.

WWilliamQLiu

50% match

Loading thumbnail…

Using tr

This example demonstrates how to convert CSV files with non-Unix line endings into Unix format using the command-line utility `tr`. It shows two conversion scenarios: replacing carriage returns (`\r`) with line feeds (`\n`) for files with Mac OS 9 endings, and deleting carriage returns to handle Windows-style `\r\n` endings. The code processes the DC Metrorail ridership dataset, which contains daily totals, and verifies the results by comparing output files with `md5sum`. Alternative tools like `mac2unix` and `dos2unix` are also presented for the same task.

LLeeMendelowitz

50% match

Loading thumbnail…

Loading and Parsing CSV Data

This example demonstrates how to load and parse a CSV file using D3.js, displaying the file size, row count, and column count in a large text container. It fetches a CSV of CSS named colors from a GitHub gist and processes it with `d3.csv` and `d3.csvFormat`. The code also includes an alternative commented-out approach using the Fetch API and `d3.csvParse`, highlighting two common methods for handling CSV data in D3 v6.

SSandra

49% match

Loading thumbnail…

Parsing CSV Data with D3

This example displays a brief summary of a CSV file’s contents—the number of rows, columns, and approximate file size in kilobytes—as large text on a blank page. It loads the CSS-named-colors dataset from a GitHub gist using the `d3.csv` function, which parses the remote file asynchronously. The code then computes the summary values from the parsed data object and the formatted output of `d3.csvFormat`, writing the result into a `<pre>` element.

Kkatjur01

49% match

Loading thumbnail…

Replace nested double quotes with single quotes in these CSV strings.

This example demonstrates a text-processing routine that cleans malformed CSV data by replacing nested double quotes with single quotes. It operates on two hardcoded strings containing street names and player nicknames with embedded quoted terms, such as `"Dearil "DJ""` and `"Calvert "C.J.""`. The code uses Ruby string interpolation with `%()` literals to define the input strings, then applies a regular expression to substitute the inner quote pairs. The output is not visualized but rendered as plain corrected CSV lines, showing how the transformation standardizes quote usage for downstream parsing.

CCaged

49% match