/Python/Pandas using eval converter excluding nans

Pandas using eval converter excluding nans

Pandas replace nan

data["Gender"].fillna("No Gender", inplace = True)

Python pandas replace nan with null

df.fillna('', inplace=True)

Source: stackoverflow.com

Pandas using eval converter excluding nans

df.fillna('()').applymap(ast.literal_eval)

Source: stackoverflow.com

Pandas using eval converter excluding nans

from ast import literal_eval
from io import StringIO

# replicate csv file
x = StringIO("""A,B
,"('t1', 't2')"
"('t3', 't4')",""")

def literal_converter(val):
    # replace first val with '' or some other null identifier if required
    return val if val == '' else literal_eval(val)

df = pd.read_csv(x, delimiter=',', converters=dict.fromkeys('AB', literal_converter))

print(df)

          A         B
0            (t1, t2)
1  (t3, t4)

Source: stackoverflow.com

Similar codes

32 votes157 views6 answers
Add to list python
Python
0 vote245 views1 answer
Resource punkt not found. Please use the NLTK Downloader to obtain the resource:
Python
0 vote153 views1 answer
Meter to cm in python
Python
0 vote172 views1 answer
Add multiple columns to dataframe if not exist pandas
Python
8 votes140 views2 answers
Python f-string padding
Python
2 votes154 views1 answer
Python Crash Course, 2nd Edition: A Hands-On, Project-Based Introduction to Programming
Python
0 vote153 views1 answer
Python read from stdin pipe
Python
0 vote141 views1 answer
Button onclick message box in python tkinter
Python
1 vote166 views1 answer
How to merge dataframe with different keys
Python
1 vote164 views1 answer
Seaborn jointplot regression
Python