/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

0 vote321 views1 answer
Removes all the elements from a linked list python
Python
14 votes325 views6 answers
Value_counts pandas
Python
-1 vote332 views2 answers
How to measure how much your of cpu your program is using in python
Python
13 votes331 views4 answers
Pandas dataframe select rows not in list
Python
107 votes351 views6 answers
Python install opencv
Python
0 vote332 views1 answer
How to create a palindrome prime in python 3
Python
1 vote327 views1 answer
Add age categories pandas dataframe
Python
1 vote343 views2 answers
Can you look for specific characters in python
Python
0 vote338 views1 answer
Add label to colorbar
Python
1 vote322 views2 answers
Python 3d software
Python