Category "csv"

Plotting CSV data on a map in Python

I have to plot data from 1200 isotopic measuring stations (worldwide) in a map for a thesis. For this I have downloaded them in a CSV file. Afterwards I have di

Upload large csv file to cloud storage using Python

Hi I am trying to upload a large csv file but I am getting the below error: HTTPSConnectionPool(host='storage.googleapis.com', port=443): Max retries exceeded w

How to read a csv file with commas in field with pandas python?

Hi I have a csv file with items like this product_id,url 100,https://url/p/Cimory-Yogurt-Squeeze-Original-120-g-745133 "1000,""https://url/p/OREO-Biskuit-Dark-

ASP.NET download csv file as zip?

I've been reading through: https://www.aspsnippets.com/Articles/Export-data-from-SQL-Server-to-CSV-file-in-ASPNet-using-C-and-VBNet.aspx Rather than only have t

Plot histogram from two columns of csv using pandas

I have a csv file containing two columns. What I'd like to do is to plot a histogram based on these two columns. My code is as follows: data = pd.read_csv('data

Grouping duplicates in CSV file and ranking data based on certain values

I have a CSV file like so - "user_id","age","liked_ad","location" 2145,34,true,USA 6786,25,true,UK 9025,21,false,USA 1145,40,false,UK The csv file goes on. I

How to capture the field values in the csv file using bufferedreader

The csv file looks like this I'm trying to get the field values like name, it is the value after $$NAME$$ (there is a space after the identifier). How do I st

Zipping a list of folders with Python

everyone. I'm really new to Python, so I need some help here. I have a list of folders names inside a .CSV file. All these folders are inside the same path. I n

Write data in CSV with Java

I'm trying to write data in a new CSV generated automatically after reading and extracting my data. However, always write one record only and it hasn't got the

Import and Edit a CSV file with validation rules

I am very new to Python / coding in general so excuse me if this is a simple question I'm just struggling to find an answer. I have been tasked to create a very

Check if a value in a list exist in a column and if not, write the non existing value to the next column

I have a csv file containing metadata exported from a pst e.g from, to, cc, bcc. I have a list i can query: \*\*my list \*\* Wayne, John little, Joe I have mul

How to find the frequency of words in a list created from a .csv file

I am trying to write a program that first reads in the name of an input file and then reads the file using the csv.reader() method. The file contains a list of

unrecognized character in header of csv

import csv def readCSV(filename, begin_date="01/07/2020", end_date="30/09/2020"): file = open(filename) csvreader = csv.reader(file) header = []

Reading numbers from array in javascript and plotting these using plotly

I'm trying to make an interface that lets a user upload CSV files and plots these using plotly, only using javascript and obviously the plotly library. I'm clos

CSV to PHP class properties

I'm working on an assignment right now, and I'm trying to take the data from a CSV and make them into class objects. So each item in the CSV row needs to be a c

Can I read other than the first sheet with the Read Delimited Spreadsheet.vi function in LabVIEW?

I am using Read Delimited Spreadsheet.vi in LabVIEW and need to read data from other than the first sheet. How do I tell LabVIEW that want to use other than the

Split a row in a csv file into multiple rows using powershell

this is my first post on this website so please be gentle :) (Also a powershell noob) I have received a .csv file and a .txt file. My job is to input data from

Export folder size to CSV

I'm putting together a script that will import a CSV with a list of folder names (and other fields) to get folder sizes (in this case SamAccountName matches the

COUNTIFS: Excel to pandas and remove counted elements

I have a COUNTIFS equation in excel (COUNTIFS($A$2:$A$6, "<=" & $C4))-SUM(D$2:D3) where A2toA6 is my_list. C4 is current 'bin' with the condition and D*

Join large set of CSV files where the header is the timestamp for the file

I have a large set of CSV files. Approx. 15 000 files. And would like to figure out how to join them together as one file for data processing. Each file is in a