All Questions
33,484 questions
0
votes
1
answer
47
views
How to process CSV exports from an expense tool for visualization in a custom dashboard?
I’m currently using an Indonesian expense management tool (Mekari expense) that provides a solid built-in dashboard and allows exporting detailed expense reports as CSV files. However, I need more ...
- 1
0
votes
0
answers
87
views
.csv -> .db taking WAY too long
My code (python) works, but at the rate it's running it'll take 72 hours to finish. I'm trying to turn a csv file into a database file in hopes that it'll be easier to use and access the data in it (...
- 11
1
vote
2
answers
69
views
Python Pandas.read_csv header and index column not lining up
I have a bunch of csv files read from a teensy adc onto an SD card and am trying to extract them to be able to do some basic stats over each row.
I have tried everything I can think of to try and fix ...
- 11
2
votes
2
answers
47
views
How can I delete a row from a csv file?
enter image description here
enter image description here
When I try to delete a row from my csv file, it deletes everything else and then turns that row sideways and separates the characters into ...
- 23
-1
votes
0
answers
56
views
Regardless, the double quotes are written to a CSV file in Python [duplicate]
My Python script reads data in JSON format, and then save data to the csv file (output.csv). Before it writes data to the csv file, it calls the function remove_double_quotes() to remove the double-...
- 21
2
votes
2
answers
156
views
How to efficiently process a large CSV file with pandas when memory is limited?
I'm working with a very large CSV file (around 10GB) that doesn't fit into my computer's memory. When I try to load it into a pandas DataFrame using pd.read_csv(), I get a MemoryError.
What's the most ...
- 96
2
votes
1
answer
61
views
How to correct a ParserError when respecting the CSV delimiter and a second ParserError on URL string not expected with the delimiter defined?
I'm new here so I hope that I will put all needed information
As the CSV is a huge one (10Go), the URL link is in the code below if needed
URL link to the data description (column type...)
Delimiter ...
- 21
-4
votes
2
answers
79
views
CSV File Data limit [closed]
I have always wondered if there is a limit to the amount of data that i can store within a CSV file? I have set up my MVP to store data within a CSV file and currently the project grew to a very large ...
-1
votes
0
answers
54
views
How to incorporate a csv into an exe file in python?
I am trying to incorporate a csv into the executable file in python, so that the csv is not necessary for the exe to work. I tried two methods, both fail (exe works only when csv is present in the ...
0
votes
4
answers
142
views
replace CRLF characters in middle of row for unquoted csv file using python
I am receiving below sample data in a txt file from source. The file contains a header row which signifies how many columns are expected per row
ID~First name~last name~description~birth date<CR/LF&...
- 43
1
vote
1
answer
44
views
how to export data frame with color to csv [duplicate]
I want to add color to cells of Status Pass and Fail. I tried following code it will print a colored data frame but exported csv was not colored.
And when I applied two rules (green and red), only ...
- 13
3
votes
2
answers
71
views
How to preprocess multivalue attributes in a dataframe?
Description:
Input is a CSV file
CSV file contains columns of different data types: Ordinal Values, Nominal Values, Numerical Values and Multi Value
For the multivalue columns. Minimum is 1, ...
1
vote
4
answers
106
views
How to strip quotes from CSV table?
I'm using the pandas library to convert CSVs to other data types. My CSV has the fields quoted, like this:
"Version", "Date", "Code", "Description", "...
- 1,096
0
votes
3
answers
76
views
How to replace hashed value retrieved from API to human-readable in a CSV
I am retrieving a hashed value from an API and storing that value in a CSV. Is it possible to translate that value into its matching human-readable form before writing it to the CSV, perhaps using a ...
- 11
1
vote
2
answers
79
views
How to use csv module to make a generator of lines of a csv?
import csv
from typing import Generator
def get_csv_lines(rows: list[list[str]]) -> Generator[str, None, None]:
"""
Generates lines for a CSV file from a list of rows.
...
- 360