/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

3 votes316 views2 answers
Python list multiplication
Python
1 vote298 views2 answers
Get IP address
Python
0 vote311 views1 answer
Python is not set from command line or npm configuration node-gyp
Python
0 vote277 views1 answer
Search for a word in pdf using python
Python
0 vote301 views1 answer
Python function cache
Python
0 vote298 views1 answer
Python how to make boxplots with swarmplot
Python
105 votes311 views6 answers
Install opencv
Python
11 votes290 views3 answers
How to convert small letters to capital letters in python
Python
1 vote314 views1 answer
Length of a matrix in python
Python
10 votes288 views2 answers
Pygame get mouse position
Python