289,229 questions
1
vote
1
answer
28
views
graph_objects.Surface axis tic spacing inconsistent on x and y
Given hemi.csv data of:
244,1000,1500,2000,2500,3000,3500,5000
0,14,18,-42,-72,-84,-86,-94,-119
12.5,277,231,185,139,144,150,161,158
25.1,416,394,370,348,361,374,404,396
37.6,483,587,633,653,566,585,...
- 11
-3
votes
0
answers
36
views
Excel Data Merge with Sheet-Based Status Priority [closed]
I need to process an Excel file with multiple sheets, where each sheet contains a list of companies with different statuses. The sheet order determines the priority of these statuses.
Processing Flow
...
2
votes
5
answers
149
views
removing set of rows in pandas dataframe base on rows values
I have a pandas dataframe that looks like this:
A B C D
0 1 2 3 0
1 4 5 6 1
2 7 8 9 2
3 10 10 10 0
4 10 10 10 1
5 1 2 3 0
6 4 5 6 1
7 7 ...
- 111
3
votes
1
answer
83
views
Convert dictionary rows to new dataframe
After importing some nested JSON data, I'm trying to create a new dataframe from all of the dictionary key / value pairs in an existing column.
Starting point:
>>> df['schedules']
0 {'...
- 831
0
votes
2
answers
75
views
How to rewrite python code using Pyscript
My code works as python file but I am struggling to make it work using pyscript.I am sharing the code which I tried.
main.py
import pytesseract
pytesseract.pytesseract.tesseract_cmd = r"Tesseract-...
-4
votes
0
answers
37
views
Difference between map and apply [duplicate]
I just wanted to know what the real difference is between map and apply, as I am currently working. I see that they mostly work the same. Is there any example that could be helpful?
1
vote
1
answer
46
views
How to dynamically rename headers in a bank statement CSV/Excel using Python and Pandas?
I have bank statements in both Excel and CSV formats. The headers can vary slightly depending on the bank or the file export, for example:
TRAN_DATE, CHQNO, PARTICULARS, DR, CR, BAL, SOL
I want to ...
2
votes
1
answer
70
views
How to add value from a list as new column value in dataframe, if existing column value starts with that value from list
I have a dataframe which looks like shown below:
CALL_START IMSI
0 24.07.2025 12:00:51 123456888888888
1 24.07.2025 17:58:57 123456999999999
2 24.07.2025 17:05:47 ...
- 31
4
votes
2
answers
90
views
What to do when the pandas error position overflows?
So, I'm experimenting with pandas with the IMDB files, especially title.basic.tsv. When trying to parse the runtimeMinutes column to "Int64", I get an error
ValueError: Unable to parse ...
- 685
3
votes
1
answer
60
views
Find max/min value in a column in a range of data (multiindex) and append to a different column
I have the following dataframe:
import pandas as pd
import csv
lst = [['SPXW 250715C06310000', '7/14/2025', 2.74, 2.87, 2.60, 2.65, 14, '8:30:00'],
['SPXW 250715C06310000', '7/14/2025', 2.80, ...
- 33
2
votes
0
answers
22
views
broken x axis and broken dual y-axes - draw replot across subplots
My post relates to this one here:
Formatting a broken y axis in python matplotlib
I have borrowed code from this post and adapted it to what I am doing.
I am attempting to create a graph whereby I am ...
- 23
5
votes
3
answers
118
views
Pandas - return the -2 row
If I have an input.txt file:
apples grapes alpha pears
chicago paris london
yellow blue red
+++++++++++++++++++++
apples grapes beta pears
chicago paris london
car truck ...
- 881
7
votes
6
answers
403
views
Concatenating a range of rows in pandas
I have a pandas dataframe like this:
c1 c2 c3 c4
0 1 2 3 0
1 10 20 30 1
2 100 200 300 2
3 1 2 3 0
4 10 ...
- 111
-2
votes
0
answers
32
views
Deploying Dash app to Render that reads large Excel files: fails at startup when files aren’t present . How should I load data? [closed]
I have a code that works local and gets lots of data from excels.
I try to render it with github and then with render.com.
The problem is github wont accept the excels because they are to big.
Then I ...
0
votes
1
answer
59
views
How to remove duplicate rows in pandas DataFrame based on a column?
I have a pandas DataFrame with multiple rows, and some rows have the same value in a specific column (e.g., id). I want to remove the duplicate rows while keeping only the first occurrence (or ...
