Questions tagged [csv]

Comma-Separated Values are a list of plain text values delimited by commas, or a file containing one or more lists in that format.

13 questions with no upvoted or accepted answers
Filter by
Sorted by
Tagged with
2
votes
1answer
5k views

File converter: from CSV to HDF5

Can anyone recommend any command line tool for converting large CSV file into HDF5 format?
1
vote
0answers
9 views

Is high school GPA included in IPEDs NCES databases?

I’m currently developing a computer tool which will sort through the US college and university NCES data provided in the IPEDs website to match users with potential universities. NCES shows university ...
1
vote
2answers
514 views

Getting some data from a csv file into a list of tuples using Python

I have a csv file of almost 2 million rows and about 20 columns. I am interested in about 40000 of these rows, and in 5 of the columns 'squat', 'bench', 'deadlift', 'bodyweight', 'total'. I'd like to ...
1
vote
0answers
253 views

Dask error when reading data from a large zip file

I have a .zip folder with a lot of .csv files which I read into a Dask DataFrame like this: ...
1
vote
1answer
118 views

Extract or subset hundreds of columns from a data frame

I need to extract many columns from a dataset. I have a very large csv file with thousands of columns and rows, and I read it into R using: ...
1
vote
1answer
614 views

Whole time column in csv file convert into UTC (epoch) using python

I have a datset with time and column. I want to plot a graph with time and value. I tried many methods but didn't come proper graph. Because I have a time series. Then I thought I will convert time ...
1
vote
0answers
555 views

How to create separate nodes for each column in a spreadsheet using Neo4J?

I have an excel file containing lot of columns. I want to create a graph database in Neo4J with all these columns as a separate node so that I can establish relationship between them and play around ...
0
votes
1answer
29 views

How to specify different columns stacked vertically within CSV using pandas?

I have a CSV file that looks like below with columns labeled below data, and I'm have trouble trying to retrieve said data with pandas. I'm only able to address the columns at the top with the ...
0
votes
1answer
185 views

How do I get Multiple CSV files (csv file names will be column names) from a folder to a pandas dataframe?

I think the title is enough for what is my problem here. I have 100 tickers in a folder. I got all csv files to one list. but I wanna see the tickers name which these are csv file names. what should ...
0
votes
0answers
111 views

Unexpected arguments error appearing on the command line when running mapreduce job (MRjob) using python

I am fairly new to this process. I am trying to run a simple map-reduce job using python 3.8 with a csv on a local Hadoop cluster (Hadoop version 3.2.1). I am currently running it on Windows 10 (64-...
0
votes
0answers
19 views

What's the best way to store and then call 3 Million+ records for training?

Good afternoon all, I am working on a Deep Learning project where I'm proceeding in batches (rather than a continuous pipeline). Essentially I've built a function that can convert raw data into ...
0
votes
0answers
28 views

Parse JSON to CSV using Python

I have a request that is giving me a JSON answer: ...
-2
votes
2answers
652 views

How to calculate occurance of a name per hour basis of monthly csv data using python

I have csv file which have DateTime and application OS name. DateTime have for 1 month ,per hour basis. The csv looks as follows, ...