All Questions
4,249
questions
0
votes
1
answer
36
views
Update data in json kept in excel sheet with python
I have an Excel sheet that has json stored in on of it's cells. Sheet has multiple rows, but every json is in one column.
I need a way to replace some of the elements of that json, and save it back as ...
0
votes
1
answer
34
views
Extract a JSON from an API and I need to extract into different dataframes all information
In the JSON, I have information within each main object, which includes sub-objects and lists of objects with more details.
"ns0:sfobject": {
"@xmlns:ns0": "urn:...
- 13
1
vote
1
answer
53
views
Can I turn a Pandas Dataframe column containing a jJSON string into additional columns and rows?
I've run into a strange issue with an API I am calling. I'm getting my data as a JSON with a string containing a JSON inside of it. Instead of being nested, for some reason it comes across as a string ...
- 29
1
vote
1
answer
70
views
Read Met Office Data Point JSON into Panda
I am using the MetOffice Datapoint API to download UK Weather data as a JSON. I would then like to read that JSON file into a pandas DataFrame. The format of the JSON file is as shown
{"SiteRep&...
- 19
0
votes
2
answers
50
views
Converting JSON list with multiple nested dictionaries to csv or excel
I have a JSON that I download from a website that has multiple nested dictionaries inside the main list. This is a very simplified version of it.
[
{
"id": 1,
"...
- 9
0
votes
2
answers
61
views
Python Pandas extract csv column containing json
I want to learn Pandas framework, so I find free csv with Euro data from kaggle.com
https://www.kaggle.com/datasets/piterfm/football-soccer-uefa-euro-1960-2024/data
But there're plenty of columns ...
- 1
2
votes
1
answer
50
views
Removing nulls from spark Dataframe without using pandas
new_DF=old_DF\
.select(col("id"),
col("COL1"),
col("COL2"),
).distinct()
new_JSON_DF = new_DF\
.withColumn("PROP",struct(col("...
-1
votes
3
answers
60
views
How to convert JSON file into a Pandas dataframe correctly?
I have a JSON file called "values.json" with this content:
{
"values": [{
"id": 2,
"value": "passed"
}, {
"id": 41,
&...
- 3
0
votes
0
answers
39
views
I'm trying to visualize the all launch records in a dataframe on folium map
# Add marker_cluster to current site_map
site_map.add_child(marker_cluster)
# for each row in spacex_df data frame
# create a Marker object with its coordinate
# and customize the Marker's icon ...
0
votes
1
answer
53
views
Python DataFrame groupby convert NaN to None to generate a valid JSON
I get several JSONs which I have to transform and join, what I do with pandas and afterwards I have to generate a JSON as well.
The structure of the final JSON is fixed.
sometimes some fields in the ...
- 3
0
votes
1
answer
66
views
Skip lines with JSON document that cause "ValueError: Unexpected character found when decoding object value" in pd.read_json(..., lines=True)
Consider a document btc_transactions.json that contains the following data:
{"txid":"00a5b60bf38d0605a7ed65c557722e42c1637e1dade80e37b7fc73cea3b67d9b","consensus_time":&...
- 300
-1
votes
2
answers
110
views
Convert json containing nested list using json_normalize function and create dataframe
{
"Serialnumber": 1,
"JSON": {
"body": {
"ver": "1",
"dt": 169,
"od": "OBJECT_ID",
"bin": "Vbin",
&...
- 27
0
votes
3
answers
65
views
CSV data format to nested dictionary
I have below csv format. I want it to convert some nested dict.
name,columns,tests
ABC_ESTIMATE_REFINED,cntquota,dbt_expectations.expect_column_to_exist
ABC_ESTIMATE_REFINED,cntquota,not_null
...
- 118
0
votes
1
answer
57
views
How to convert categorical entries in a pd dataframe row into a column? [duplicate]
I have a json file which when converted into a dataframe looks something like this:
sl no. id name value date
1 101 Math 90 -
2 101 Phy 87 -
3 ...
- 29
0
votes
1
answer
47
views
Error Creating CSV Data File From A JSON data
I am using Pandas and other libraries to create a timetable csv data file for a game. I am encountering error while running it. Please provide any suggestions on correcting my code.
class ...
- 7