Questions tagged [csv]

Comma-Separated Values or Character-Separated Values (CSV) is a common "flat file database" (or spreadsheet-style) format for storing tabular data in plain text, with fields separated by a special character (comma, tab, etc). Rows are typically denoted by newline characters. Use for any delimited file formats, including tab delimited (TSV)

85,011 questions
0votes
0answers
11views

Powershell script and Excel

I had coded a powershell executable in a evaluation windows server, where it worked fine. That is because it had Office (Excel) installed, hence it was possible to run $ExcelObj = New-Object -...
0votes
1answer
9views

How can I read values in an exponential format from csv into a numpy array?

I have values in this format, where e+002 and so on is the exponent: 1.25663709640503E+0000 2.33967334032059E-0001 2.51327419281006E+0000 4.85565841197968E-0001 3.76991128921509E+0000 3....
-2votes
1answer
22views

How can I add multiple values from multiple txt files to csv using python

I have 5 different txt files, each containing not more than 5 values, each value in a new line. These txt files are rewritten whenever the python program runs, i need to create a csv file that stores ...
0votes
1answer
21views

How do we perform repeated function calls with arguments in incremental orders?

I have devised a code which works, but it is too tedious to repeat the code multiple times. Let's say my function is def merge_data(first_excel, sheet_name, second_csv, outfile): .... and all my ...
1vote
1answer
28views

Convert JsonArray to to csv file in right format without using third party library

My dependency which is not third party <dependency> <groupId>javax.json</groupId> <artifactId>javax.json-api</artifactId> <version&...
0votes
1answer
22views

Loading data from a file and converting into an array in Python

I am trying to load the data from a file. There are 3 rows and columns and I want to convert into an array A with shape (3,3). How do I go about doing it? import numpy as np np.loadtxt('A.csv')[:, 0] ...
0votes
1answer
28views

Convert a directory of JSON files to one CSV file

I have a directory with hundreds of JSON files, and would like to convert and merge them into one CSV file. I found this question. One answer explains how to convert one JSON file to CSV: import ...
  • 213
0votes
2answers
29views

selecting one specific column out of a text file

I want to select just the second column of the below text file which is: 500, 1000, 1500, ..., 4500, 5000, 5500, ... , 21000 I have attached a picture of my text file below. I have used the script ...
1vote
1answer
29views

how to convert this format csv file to a json file?

The CSV file looks like this way, I have the id and tags. But some tag may have multiple value, each value take one column, so some tag may have multiple columns. id,tags 403744,[""] 403745,[...
0votes
0answers
19views

How can you compare a day average value to all values on that day?

I have created two dataframes in Python: one with an average heart rate frequency per day, and another dataframe with the heart rate frequency during multiple moments on each day. I now want to ...
-2votes
1answer
26views

Postman Pre-Request Script to Read Variables from CSV file and Append to JSON Body

I have a JSON body with template to pass to an API endpoint in Postman/Newman as follows: { "total": [ { "var1a": "ABCDE", "var1b": { &...
0votes
0answers
14views

Folium Chloropleth not showing colors

Geojson File: https://raw.githubusercontent.com/sejal234/heatmaps_by/main/Zip_Codes.geojson CSV: https://raw.githubusercontent.com/sejal234/heatmaps_by/main/oyzipsattempt.csv (this is labelled new in ...
0votes
1answer
35views

Saving big data in csv file

I am trying to save a large matrix, 1000x1000 which follows log-normal distribution. But the saved file turns out to be empty. What am I doing incorrectly here? import numpy as np import csv with ...
2votes
2answers
24views

Replace coded text by unicode text in Vietnamese

I have a csv file saved under the name as sample.csv as follows: No,duong 1, Ðu<U+1EDD>ng ÐT 605 2, Ðu<U+1EDD>ng Nam K<U+1EF3> Kh<U+1EDF>i Nghia 3, Ðu<U+1EDD>ng Duy Tân ...
  • 23
0votes
1answer
18views

How to handle dataset which is a csv file that contains image names in one column and image path in other column?

I am new to python and machine learning. I am just practicing with model training and dataset thingy. I came across this dataset that have test and train folder. In that folder there are several ...

153050per page