Questions tagged [csvreader]

A CsvReader represents a reader that provides forward-only access to a CSV text data source. A CsvReader may also support other delimited-separator formats.

172 questions
0
votes
0 answers

How to plot data from a CSV file into a figure using matplotlib?

So my objective is to make a visualistation of the best prices on the marktet. The market exists of timestamps with the value of 100 while it counts up to 100000. Every time stamp also has two products. So you'll need to split those best prices up…
Martijn Z.
  • 19
  • 3
0
votes
1 answer

How to use python csv library to extract each row as 2 values irrespective of the number of values it has

I have a csv file with first 2 entries like this: "objectId","url" "1","someUrl1" "2","[\"SomeUrl2\",\"SomeUrl3\"]" I want to read the csv in python such that I can extract the id and the url as has to be a single variable irrespective of whether…
0
votes
1 answer

ASP.NET Core: Sending a CSV email attachment

I'm trying to create a CSV file (using the popular CsvHelper library) in memory and attach it to an email. See the following code: public async Task Send() { using var memoryStream = new MemoryStream(); await…
nfplee
  • 7,643
  • 12
  • 63
  • 124
0
votes
1 answer

Read in csv files in a folder and output to one single csv

I have a folder with many csv files. I want to read them in and depending on certain criteria output the records to specific output files. So in my case I have 3 different output files. So I have many of csv files. Let's consider one file looking…
PSt
  • 97
  • 11
0
votes
0 answers

How to read a huge CSV file efficiently and convert CSV values into objects based on a user-defined class in Java

I have to read a large CSV file with about 700,000 records and compare the CSV data to an API response. I was able to use OpenCSV and make the code work. However, the deserialization process is extremely slow. It takes about an hour just to…
ychaulagain
  • 73
  • 1
  • 8
0
votes
2 answers

I'm trying to read in a csv file in pycharm that I downloaded on my mac and when I run my code it says no such file exists

#import necessary modules import csv with open ("C:/iCloud Drive/Desktop/Python/o.csv") as f: data = csv.reader(f) for row in data: print(row) Heres the error message Traceback (most recent call last): File…
Noah H
  • 1
0
votes
1 answer

CSVReader doesnt read special letters

I want to read data from CSV file. File csvfile = new File("/sdcard/Download/" + returnFileName(Integer.parseInt(year))); CSVReader reader = new CSVReader(new FileReader(csvfile.getAbsolutePath())); List nextLine = reader.readAll(); This…
0
votes
2 answers

Trying to read csv data and compare to web table in java

I'm trying to compare the data on my csv file to web table. ` WebElement mytable1 = driver.findElement(By.cssSelector("#dStocks1")); // To locate rows of table. List rows_table1 = mytable1.findElements(By.tagName("tr")); …
Michael
  • 3
  • 2
0
votes
1 answer

How to detect if a row has extra columns (more than the header)

While reading a CSV file, how can I configure CsvHelper to enforce that each row has no extra columns that are not found in the header? I cannot find any obvious property under CsvConfiguration nor under…
colbster
  • 3
  • 2
0
votes
2 answers

Remove some coma separated header values from a csv file and create a datatable from that csv in C#

I have a very big csv file like this (more than 12K rows) ; Comment, DateTime Name, Age, Class, Place, --> these are the header columns Good, 03/10/2022, John, 12, 3, UK, Bad, 12/10/2022, Tom, 15, 2, US This…
Micheal
  • 13
  • 4
0
votes
1 answer

List index out of range error caused by empty cells when using CSV reader in Python

I'm trying to figure out how to deal with empty cells when iterating through a CSV file. I am currently receiving an IndexError whenever I run the loop. This is because the rows are not empty, just some of the cells in the columns that I am…
Gwart
  • 3
  • 2
0
votes
0 answers

Smooks CSV to XML failing to parse double quote

Smooks transformations fails to parse when CSV column has a double quote
Vicky
  • 1
  • 1
  • 3
0
votes
1 answer

Apache Arrow C++: How to set nondefault options for the csv_reader in the official GitHub example "example.cc"?

The example comes from here. The source file is example.cc. I was able to follow these instructions to build Arrow C++ on Ubuntu 22.04.1 LTS: out-of-source build with cmake .. and make ... And despite getting errors from running build_arrow.sh and…
xyzabc
  • 23
  • 5
0
votes
0 answers

CSVREADER FILE NOT FOUND

Good morning. I've been looking for a solution to my problem for a long time and I can't find it. I have reviewed and tried the similar solutions shown on Stackoverflow and they do not work with my application. What I am trying to do is import the…
jarrapiu
  • 9
  • 3
0
votes
1 answer

Impossible to get out of "gsReference.getFile(Objects.requireNonNull(localFile)).addOnSuccessListener"

I am trying to get a value from the first line of a csv file ( header excluded) store in Firebase Storage Here is the code : private String readFromCsv() { StorageReference refCompteActifs =…
Coco
  • 13
  • 3