92 questions
- Bountied 0
- Unanswered
- Frequent
- Score
- Trending
- Week
- Month
- Unanswered (my tags)
Advice
0
votes
1
replies
37
views
Pandas segfaults when attempting to read a multi-line cell
I have a set of TSV files that are filled by serializing pandas dataframes built on the responses I get from querying a large database using GraphQL. In the response I get, I have a field that hosts ...
-1
votes
1
answer
91
views
Pandas 'sep' Command Not Working for Text File [closed]
I have the following (shortened) list of data (State Vector for an arbitrary satellite):
0.0000000000000000e+00 6.0513311190355308e+06 -2.3889553726207524e-10 -3.9014601994371545e+06 4....
2
votes
1
answer
159
views
How to fix broken German special characters when reading CSV file?
I am trying to load a German CSV file into R on Fedora Linux 42, but the region names containing special characters (like u-umlaut, o-umlaut, eszett) are not rendered correctly.
Here's a simplified ...
0
votes
1
answer
75
views
Able to read FileInfo, but cannot read contents within the file: urlopen error [Errno 5] Input/output error
I have 2 environments, Staging & Production.
Both using the exact code, but one environment can read the contents within the file, while other cannot.
I can see both FileInfo using 2 codes:
Python:...
-3
votes
1
answer
88
views
How to read log files in Pandas dataframe having multiple delimiters? [closed]
My log file format is as below :
2016年09月28日 04:30:30, Info CBS Loaded Servicing Stack v6.1.7601.23505 with Core: C:\Windows\winsxs\amd64_microsoft-windows-...
1
vote
4
answers
439
views
Handling bad lines when reading csv files with pd.read_csv()
I am trying to parse some csv files with a few thousand rows. The csv is structured with comma as a delimiter and quotation marks enclosing each field. I want to use pd.read_csv() to parse the data ...
0
votes
2
answers
137
views
UnicodeDecodeError codec can't decode error using pandas read_csv
I'm opening a csv file using pandas.
import pandas as pd
df = pd.read_csv('/file/planned.csv')
I'm opening a file that contains about 2,000 records collected from all over the places in the world. ...
0
votes
1
answer
75
views
Pandas text file import: automate selection of 1 table when many exist within each file
Using Pandas 2.2.1 within Python 3.12, I'm importing data from text files that have a varying number of rows of metadata and multiple tables that precede the actual data to be imported. The number of ...
1
vote
2
answers
60
views
Reading large multi-part table from file and combing its parts into one tibble
I have this huge file (> 25 Mb) of the following structure:
ITEM: TIMESTEP
0
ITEM: NUMBER OF ATOMS
14748
ITEM: BOX BOUNDS ss ss ss
-1.3314357502021994e+02 1.1517122459132779e+02
-1....
0
votes
0
answers
32
views
How to save JMeter Response Body to the same CSV File used for the request
I am using a csv file for a POST request in JMeter.
sample POST body data
sample list of names on CSV file
The API will return a response body and I want to save the data from the response body into ...
1
vote
1
answer
69
views
customize header pandas to html
I created a web application to search content in CSV files.for now i only able to put all content into 1 column with comma as delimiter ,
I want to display the data as shown in the image.
My python ...
0
votes
2
answers
104
views
How to best use read_csv parameters when headers are on different rows, and then make 1st column datetime index
Ive been having trouble reading and updating a csv from yfinance, due to the data in the first few rows of the downloaded csv:
1st row contains the column headers I want (also header - 'Price' - I ...
-2
votes
1
answer
82
views
pd.read_csv: error when "," comma is present in string column
I am reading in a csv file locally.The sep for the data is "|", so I specify pd.read_csv(repo, sep="|"). The data loads.
However, when I examine the data, any time there is a comma ...
0
votes
0
answers
112
views
Read CSV - There should be a unique row for each daily entry combining health metrics and supplement usage
Can you help me with the interpretation of this sentence ?
Does this mean you should group by date rows with different supplement usage?
Or should I have 2 rows, one for magnesium and one for ...
1
vote
3
answers
133
views
Randomly shard large CSV into smaller CSVs
I am aiming to shuffle a csv file too large to load into the RAM of my device at once. My plan was to use csv.DictReader to go through the entire file and write each line randomly into one of a set of ...