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,461
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 ...
- 114
-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
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
-1
votes
0
answers
38
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
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 ...
- 1
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 ...
- 11
0
votes
1
answer
47
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
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
23
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:
...
- 507
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
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 ...
- 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
0
votes
0
answers
30
views
CSV files showing different date formats in a single column
I'm receiving CSV files from a vendor, and these files contain date columns with various formats. When I open the CSV files on the server using vi filename.csv, I notice that a single date column can ...
0
votes
0
answers
10
views
VBA Runtime Error -2147467259(80004005) while using "Microsoft.ACE.OLEDB.12.0" to read CSV file
I am using a Win11(Language=Japanese) Laptop with Office LTSC 2021 installed.
I've written enclosed VBA Code to convert a csv file into excel(xlsx) file.
There is error message popping-up when ...
1
vote
2
answers
90
views
Is there a Pandas idiom for reading a CSV file with categorical data that has spelling variants?
I have a CSV file with multiple categorical columns, but most of these columns contain messy data due to typing mistakes (e.g., 'spciulated', 'SPICULATED', etc. for the category 'spiculated' of the ...
- 111