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,473
questions
-1
votes
0
answers
44
views
How to split a info in a single row in excel into columns using python [duplicate]
I have read a CSV file using pd.read_csv()
I am trying to clean up this data but it is proving a bit difficult.
Essentially all of the information is in a single column and row 1 and I need to split ...
- 1
-8
votes
1
answer
43
views
Split large Jason File into different excel CSV files [closed]
I have a very large JSON file that I like to open in excel. File size is 1,479,555 kb. Does anybody has any script that I can use to split data into different excel files?
- 83
-1
votes
0
answers
25
views
NameError Traceback (most recent call last) <ipython-input-3-9ec55f7a7976> in <module> : NameError: name 'books' is not defined
I am trying to plot the evolution of degree centrality over the books for some of the characters from Game of Thrones .I have a list evol that contains the computed degree centrality from all the ...
- 1,237
-2
votes
4
answers
93
views
How to append some static content within a single cell of an existing CSV file
Let's assume I need to append the below content within the first cell (not be row by row) of the existing CSV file which has details of the customer. How can I achieve it?
Content to be added:
"...
0
votes
0
answers
22
views
Crash when parsing a CSV file (stored on iCloud)
When trying to read a csv file (which is stored in the download folder of icloudDrive) my app is always crashing with this error:
The view service did terminate with error: Error Domain=...
- 29
1
vote
0
answers
14
views
Find unescaped line breaks from middle of RFC4180 CSV [closed]
I am writing parsing logic for an RFC4180 csv file.
I am wondering if it is possible to seek to an arbitrary position in the file, then scan either forwards or backwards to the nearest unescaped line ...
- 96
1
vote
1
answer
23
views
Read CSV with epoch timestamp column as timestamp
I'm using pyarrow.csv to read and convert a CSV file to parquet. This CSV file has a timestamp column with an int representing Unix time.
Nevertheless, it reads it as an int64, and if I try to use ...
- 535
-1
votes
0
answers
67
views
C# - is the this the right way to code a tax calculator
I am in my first year of a programming course and have an assignment using c sharp where we have to make a payroll calculator which calculates gross pay, tax, net pay and superannuation contribution. ...
0
votes
0
answers
35
views
Why does csv consider data in one column to be an empty string
I have a powershell script, which basically takes an xlsx file with data, converts it to csv and then fills certain cells in another (template) xlsx file with values from certain columns. There are ...
- 133
0
votes
0
answers
10
views
Title: CSV Files Created in PyCharm Show Only Headers, No Values
I'm working on a data analysis project in PyCharm and have been creating and manipulating CSV files. However, when I open these files, they only display the headers and not the actual data values. The ...
1
vote
1
answer
34
views
How to download and read .csv file (daily streamflow) from Water Survey of Canada website?
I'm trying to have R automatically download and read a .csv file (daily streamflow) from Water Survey of Canada website to a local directory. To do this manually, I have to click on the "Download?...
- 850
-4
votes
0
answers
23
views
What are 0-3 effective general debugging practices to id the points and specific line #s of possible errors? [closed]
Context:
Currently my only normal strategy is adding print() statements at the end of methods, usually multiple at different checkpoints of a given python program.
The logic behind this is that if ...
0
votes
0
answers
13
views
Random forest_CSV_ArcGIS [closed]
I have a CSV file from ArcGIS Pro including 10 influencing factors on wildfire which I did train and test file already under ArcGIS as well.
Now I want to fit random forest to export a susceptibility ...
0
votes
2
answers
72
views
How To Import a Big .csv(~2GB) Into a PostgreSQL Table
I am new into databases and PostgreSQL and today I wanted to import this dataset: https://www.kaggle.com/datasets/wilmerarltstrmberg/recipe-dataset-over-2m/data into a PostgreSQL so I can make a ...
- 13
0
votes
1
answer
54
views
How to update a BigQuery table with data from a local csv file while using Python?
Every day, I migrate data from a MySQL database to BigQuery. For most processes, I use LoadJobConfig().writedisposition with WRITE_APPEND. However, for my raw_stock table, using WRITE_APPEND doesn't ...
