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,452
questions
-2
votes
0
answers
16
views
How do I import csv to woocommerce from SQL Database [closed]
I'm trying to upload about 500,000 products on WooCommerce and it's taking forever. I've seen a couple of answer by @Ayman using dbForge studio, but I'm not entirely sure about step by step process. ...
0
votes
2
answers
37
views
Ignoring text at the start of a CSV file
I'm trying to download a CSV file from the web. However, the first 20 lines are column definitions with the data starting at line 24 (the lines in between are blank).
The code I have is:
data = pd....
- 71
1
vote
1
answer
23
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 ...
- 31
2
votes
0
answers
59
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 ...
- 31
-1
votes
0
answers
37
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
-3
votes
0
answers
16
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 ...
- 5
0
votes
1
answer
25
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 ...
- 130
-1
votes
0
answers
20
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
28
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
42
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
64
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
50
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
49
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
54
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
30
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