/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 vote230 views2 answers
ImportError: /usr/local/lib/python3.7/dist-packages/cv2/cv2.cpython-37m-arm-linux-gnueabihf.so: undefined symbol: __atomic_fetch_add_8
Python
0 vote222 views1 answer
Duplicate a list with lowercase in python
Python
7 votes192 views3 answers
If in df.columns
Python
-1 vote185 views1 answer
Write Python Program to find the square root of an input number. (create a user-define function of square root).
Python
0 vote194 views1 answer
Python simple input popup
Python
0 vote215 views1 answer
How to create decorator function in django
Python
1 vote206 views1 answer
Xarray add coordinate
Python
0 vote191 views1 answer
Get rid of axes numbers matplotlib
Python
3 votes196 views2 answers
COLLECTIONS.DEFAULTDICT(set)
Python
0 vote243 views1 answer
Python Print Variable Using comma , character to separate the variables in a print statement
Python