/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 vote282 views2 answers
Keras.callbacks.history
Python
0 vote279 views1 answer
TypeError: 'LazyCorpusLoader' object is not callable
Python
1 vote307 views1 answer
Initialize array of natural numbers python
Python
0 vote281 views1 answer
Xmlrpc get all posts
Python
0 vote292 views1 answer
Combine int and object columns into one
Python
15 votes313 views4 answers
Make a condition statement on column pandas
Python
0 vote247 views1 answer
Get parameter value dynamo python
Python
18 votes261 views2 answers
Python write to json with indent
Python
0 vote276 views1 answer
Plt.imshow typeerror invalid dimensions for image data
Python
0 vote258 views1 answer
Jupyter notebook print all rows dataframe
Python