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,504
questions
0
votes
1
answer
17
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 ...
- 196k
-1
votes
0
answers
17
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
0
votes
1
answer
43
views
How to import csv file in MySQL to avoid the appearance incorrect symbols
I imported a CSV file into MySQL. Before that, I checked the encoding of the file and confirmed it was UTF-8. When I imported the file, I ensured that my database was set to the utf8mb4_0900_ai_ci ...
- 41
1
vote
2
answers
43
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 ...
- 10.8k
26
votes
5
answers
18k
views
Ruby - Creating a file in memory
Is there anyway to write the following code in Ruby without writing the file to disk?
temp_file = 'path/to/file.csv'
users = [[email protected], [email protected]]
CSV.open(temp_file, "w") do |csv|
csv << ...
- 647
0
votes
3
answers
55
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 ...
- 28.2k
1
vote
1
answer
26
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,984
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
1
vote
1
answer
47
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
-1
votes
0
answers
39
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
0
votes
2
answers
74
views
Looker Studio Failed to fetch data from the underlying data set (data comes from csv in google drive loaded to BQ)
source of data:
the original data that I have problems with resides on my google drive, in the form of a .csv file. It then gets uploaded to bigquery using the add > google drive, no issues here.
...
- 1,164
1
vote
2
answers
7k
views
How to save response data in to CSV in Jmeter
I am trying to save Jmeter response in CSV file. I have tried some of the answers from StackOver Flow but those are not working.
Can anyone suggest me how can I achieve this?
Note: I have tried this ...
- 1
13
votes
2
answers
3k
views
CSV.foreach Not Reading First Column in CSV File
Learning Ruby for the first time to automate cleaning up some CSV files.
I've managed to piece together the script below from other SO questions but for some reason the script does not read the ...
-4
votes
0
answers
61
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 ...
- 518k
2
votes
3
answers
5k
views
Split a string on commas unless comma is inside single quotes
I have a problem, I want to split a string variable using the explode function but there are a limitation, imagine having the next string variable with the next value :
$data = "3, 18, 'My name ...
- 46.6k