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)
90,450
questions
1
vote
0
answers
10
views
Import Array to Godot via CSV
I'm currently making a game in Godot using CSV tables to help keep track of things. Most stuff works, except when I want to import a column as an array. How would I format this array in a CSV so ...
- 21
1
vote
0
answers
46
views
How to compare rows within the same csv file faster
I have a csv file containing 720,000 rows with and 10 columns, the columns that are relevant to the problem are ['timestamp_utc', 'looted_by__name', 'item_id', 'quantity']
This File is logs of items ...
- 21
-1
votes
0
answers
31
views
How do i search two files to know if the values are similar or not
I have two CSV files that I want to compare their contents and print the contents that doesn't have the same data. Most contents will have the same name but not all their data are accurate. I want to ...
- 109
-2
votes
0
answers
12
views
Display Enclosed CSV in Bash [duplicate]
I'd like to use column command to display the content of a CSV file in mt terminal in a tabular way, but I don't know how to deal with the enclosing?
My CSV file has fields that contain commas, and ...
- 7
0
votes
1
answer
23
views
CSV backslash create issue while procession file data
I am trying to process a CSV file in which one column contains JSON formatted data. In this JSON data, some fields use backslashes, which creates a problem when mapping fields with their values.
Link ...
- 114
-1
votes
0
answers
19
views
How to prevent csv.DictReader from setting values as strings when converting a csv into a list of dictionaries? [duplicate]
I'm making a list of dictionaries from a csv file, and want certain values in each dictionary (columns in the csv) to be set as integer/list/boolean instead of string.
My csv looks like
csv
My code is
...
- 1
1
vote
1
answer
27
views
Reading .csv column with decimal commas and trailing percentage signs as floats using Pandas
I am faced with reading a .csv file with some columns like this:
Data1 [-]; Data2 [%]
9,46;94,2%
9,45;94,1%
9,42;93,8%
I want to read Data1 [%] column as a pandas DataFrame with values [94.2, 93.4, ...
- 1,982
-1
votes
0
answers
41
views
Java: Trouble writing a µ character to a csv file [closed]
The code has to create a simple csv file but one of the column headers has a µ character and the output to the file is µ.I have tried UTF-16, UTF-16LE, UTF-16BE, ASCII, and Hex for example ...
- 1
-4
votes
0
answers
62
views
How to split CSV data with newline, commas, quotes in the column of data? [closed]
I want to split the data line by line, but I am receiving newline and quotes in the data which is not allowing me that to split it by either newline.
CSV Data Received:
ISSUE ID,FACTOR NAME,ISSUE TYPE ...
- 1
1
vote
2
answers
47
views
When using PyPDF2 for Python, how do I transfer data in CSV format to an existing PDF with blank form fields?
I am currently using the PyPDF2 extension with Python and have my data (which was originally a Google Form) and then downloaded as a CSV file and am hoping to copy this data into an existing PDF with ...
- 11
0
votes
1
answer
48
views
Export sheet in a workbook to CSV file in the same location every week
I have a sheet in a workbook I would like to export to a csv file that gets updated every week.
So ideally, I want the VBA code to export whatever data is in the sheet and overwrite what was existing ...
- 3
1
vote
1
answer
52
views
Loading CSV files with double quotes in field values via Oracle Loader External table
Requesting your help and expertise on the below:
Oracle DB 19c on UNIX server
Requirement:
CSV files come in on a daily basis in a Unix directory (where the database resides) and gets loaded to a ...
- 41
-2
votes
0
answers
29
views
Create a csv file from a list of objects and each row correspond three objects [duplicate]
I got a file that looks like this
Name
address
number
James
Avn philips 2
555 555 55
Peter
Colton 34 postmen
444 444 44
Claudia
Rainssaw 345 sq three
333 333 33
How can I convert in a csv like this:
...
- 505
0
votes
0
answers
39
views
Disregard Carriage Return or Line Break when Importing CSV with Macro
I am trying to import a CSV into Excel using a macro but some of the CSV data contains what appears to be CR Carriage Returns or LB Line Breaks. Instead of the CSV entry importing into the next one ...
- 65
0
votes
3
answers
59
views
Python Pandas extract csv column containing json
I want to learn Pandas framework, so I find free csv with Euro data from kaggle.com
https://www.kaggle.com/datasets/piterfm/football-soccer-uefa-euro-1960-2024/data
But there're plenty of columns ...
- 1