Breaking News: Grepper is joining You.com. Read the official announcement!

interpret list column as list when reading pd df from csv, add a dict element to a specific row into this list column using at and/or loc

Magnificent Mink answered on February 21, 2023 Popularity 1/10 Helpfulness 1/10

answer interpret list column as list when reading pd df from csv, add a dict element to a specific row into this list column using at and/or loc

interpret list column as list when reading pd df from csv, add a dict element to a specific row into this list column using at and/or loc

Comment

import pandas as pd
import date
import ast

list_df = pd.read_csv(PATH)

 if "request_details" not in url_list_df.columns:
 # create new column with empty lists
        list_df = list_df.assign(request_details=[[] for _ in range(len(list_df))])  
 else:
 #consider the column as lists, and not strings, to be able to append dict to the cells
        list_df["request_details"] = list_df["request_details"].apply(lambda row: ast.literal_eval(row)) 


details_dict = {"request_date" : date.today().strftime("%m/%d/%Y"), 
                    "alive_state" : alive_state,
                    "request_status" : str(code)}
list_df.at[i, "request_details"].append(details_dict)

Popularity 1/10 Helpfulness 1/10 Language python

Source: Grepper

Tags: add append date element format list python row string this using when

Link to this answer
Share Copy Link

Contributed on Feb 21 2023

Magnificent Mink

0 Answers Avg Quality 2/10

interpret list column as list when reading pd df from csv, add a dict element to a specific row into this list column using at and/or loc

Contents

More Related Answers

interpret list column as list when reading pd df from csv, add a dict element to a specific row into this list column using at and/or loc

Grepper

Documentation

Social

Legal

Contact

Oops, You will need to install Grepper and log-in to perform this action.