16 questions from the last 7 days
-5
votes
0
answers
40
views
How should I approach my CSV cleaning project for my OCBC bank statements? [closed]
I am new to programming, and I am trying to start a project on cleaning my CSV file into different formats that I want. How should I go about doing that, and what resources can I use to do it?
- 1
0
votes
1
answer
43
views
How to Create a Pandas Dataframe from JSON Nested Objects
I'm trying to create a Pandas DataFrame from a JSON file that looks like this:
{
"GameID": "1,218,463,841",
"Date - Start": "1761097369",
"Date - End&...
Tooling
0
votes
1
replies
44
views
How to export or import TOON in pandas?
Good day,
I would like to know how to export or import TOON (Token object oriented notation) in pandas.
Thank you.
- 2,557
3
votes
2
answers
182
views
Efficiently get first indices of consecutive identical digits in big pandas DataFrames
I have a DataFrame with a column Digit of digits at base 10. For example
import numpy as np
import pandas as pd
df = pd.DataFrame({
"Digit": [
1, 3, 5, 7, 0, 0, 0,
4, 8, ...
- 2,323
2
votes
1
answer
61
views
problem on the x-axis of the graph, doesn't render the time
I am working on a dashboard using Shiny for Python and Plotly Express. I am trying to create a Gantt chart (using px.timeline) to visualize the operating periods of different boilers (ON/OFF states).
...
- 97
Best practices
0
votes
6
replies
102
views
Slow database table insert (upload) with Pandas to_sql. What is the fastest method?
End Objective
Download some data from the internet (about 5 GB in size)
Possibly convert some strings/datetimes
Upload to Postgres database
I have written some code which uploads some data to a ...
- 18.6k
10
votes
0
answers
231
views
Not displaying DataFrame's name in Data Wrangler extension of VSCode, displaying "Data grid"
It is a while that I am using Data Wrangler extension in VS Code; it is very useful for analyzing datasets and filtering some columns to see the features. When I opened a dataframe in it, it used to ...
- 31
1
vote
1
answer
81
views
Python, parse nested JSON to make it flat for CSV
I'm trying to store API output into CSV/db and can not figure out how I can make for those Key in "tierList". One row in my case should be on bin and I need key as a columns in my output.
Is ...
- 129