/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 vote191 views1 answer
Module "django.contrib.auth.hashers" does not define a "BcryptPasswordHasher" attribute/class
Python Django
0 vote161 views1 answer
Block url selenium python
Python
3 votes168 views2 answers
Venv upgrade python
Python
3 votes148 views1 answer
Input array of string in python
Python
7 votes150 views6 answers
Python random word
Python
0 vote189 views1 answer
All default datasets in seaborn
Python
11 votes151 views1 answer
Python windows os.listdir path usage
Python
0 vote112 views1 answer
Cv2.filter2D(image, -2, kernel_3x3)
Python
20 votes217 views3 answers
Download image python
Python
0 vote146 views1 answer
Python readlines end of file
Python