All Questions
33,483 questions
-1
votes
0
answers
63
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
90
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
48
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
-2
votes
0
answers
59
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-...
- 19
2
votes
2
answers
157
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 ...
- 106
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
-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
0
votes
1
answer
40
views
Azure Blob CSV Appending Data Instead of Overwriting for Each Patient Processing using python
I have a Python script that processes person data and appends the results to an Azure Blob Storage CSV file. However, the issue is that for each new patient the generated csv is appending to the ...
