/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

1 vote126 views1 answer
How to remove python3 on mac
Python
8 votes138 views3 answers
Calculate Euclidean Distance in Python
Python
2 votes116 views2 answers
Open terminal in python
Python
28 votes134 views6 answers
Pandas dataframe from dict
Python
0 vote136 views2 answers
Where should favicon.ico be placed in flask app
Python
68 votes128 views6 answers
Python open file
Python
1 vote145 views1 answer
ModuleNotFoundError: No module named 'en_core_web_sm'
Python
23 votes337 views2 answers
Map function in python
Python
2 votes117 views1 answer
Django.core.exceptions.ImproperlyConfigured: WSGI application 'souroSANOU.wsgi.application' could not be loaded; Error importing module.
Python
9 votes127 views6 answers
Functions in python
Python