Skip to main content
SimilarExport ZIP
100%

Script Python (pour Emeric) pour supprimer une colonne d'un CSV

✓ Published0🌍 Public
RRCura
Last edited Nov 12, 2012
Created on Nov 12, 2012

This example shows a Python script that removes a specified column from a CSV file, using the file path, separator, and column name defined at the top of the script. It first reads the header row to locate the column index, then copies all rows into a temporary CSV file while omitting that column via `pop()`. The process relies on the `csv` module’s `reader` and `writer` classes with a semicolon delimiter, and includes commented code for deleting the original file and renaming the temporary output using `os.remove` and `os.rename`.

AI-generated description

Similar vizzes

Loading thumbnail…

script de correction des tableaux

This script corrects malformed CSV traffic tables from network simulations, ensuring every row has a uniform length of 21 columns. It reads input files named with network and simulation indices, processes rows that are either too long or too short, and writes corrected versions. For short rows, it pads missing values with "NA" while preserving the row’s name and trailing data. Using Python’s `csv.reader` and `csv.writer` with `QUOTE_NONNUMERIC`, it overwrites the original files after cleaning. The code demonstrates a batch-processing workflow for raw simulation output across multiple networks.

RRCura
56% match
Loading thumbnail…

handle tsv data (ex. delete column)

This example demonstrates how to preprocess tab-separated value (TSV) data by removing a column, such as the second field, from a dataset. It reads a TSV file into Python using the `csv.reader` function with a tab delimiter, converts the rows into a list, and then employs NumPy’s `np.delete` function to remove the specified column (index 1). The result is written back to a new TSV file using `csv.writer` with a tab delimiter. The code relies on the standard `csv` module and the NumPy library, with the data sourced from a local file named `test.tsv`.

HHirosaji
53% match
Loading thumbnail…

csv concatenation

This example demonstrates the simple concatenation of multiple CSV files into a single output file, combining rows from all input files without any transformation or filtering. The script uses the `csv.reader` and `csv.writer` APIs from Python’s standard library to parse and write each row, while the `glob` module collects every `.csv` filename in a specified directory, and `os.chdir` changes the working directory to that folder. All rows are appended into a flat list, then written to a designated output path. The visualization shows the raw data-merging process, not a graphical chart, and relies solely on file I/O and CSV handling.

IIanHopkinson
45% match
Loading thumbnail…

Python code voor het downloaden van een bestand

This example demonstrates a simple Python workflow for downloading a remote CSV file and loading it into a pandas DataFrame for inspection. It first uses `urllib.request.urlretrieve` to fetch the wine quality dataset from an AWS S3 bucket and save it locally. Then, `pandas.read_csv` reads the file with a semicolon delimiter, and the head of the resulting DataFrame is printed. The code highlights basic data acquisition and import steps, with the dataset sourced from the UC Irvine Machine Learning Repository via a DataCamp-hosted URL.

FFrieseWoudloper
44% match
Loading thumbnail…

First steps

This example shows the initial steps of loading and inspecting a malformed CSV file in Python using pandas and basic file handling. It opens the file with the built-in `open()` function, reads it line by line, strips whitespace, and splits each line into a list of values with `split(",")`. The resulting nested list is converted into a pandas DataFrame via `pd.DataFrame`, and the first 20 rows are displayed to examine the data structure. The snippet highlights data cleaning challenges, as many fields contain `None` values and numeric entries are in scientific notation.

RRobinL
43% 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
43% match
Loading thumbnail…

CSV process

This example demonstrates how to load and process a CSV file containing correlation data for BERT, transforming each row into a flat list of source-target-value objects. The code uses D3 v7’s `d3.csv` to fetch the data from a GitHub gist URL, then applies custom mapping and flattening functions to restructure the dataset. The processed result is logged to the console, showing a manual approach to data wrangling without any visual rendering or chart output.

MMark Lam
41% 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
41% match