Skip to content

Instantly share code, notes, and snippets.

@YiLi225

YiLi225/parse_series.py

Last active Sep 21, 2020
Embed
What would you like to do?
## Parse tuples of values into their own columns
### Step1: Convert each element to their own series
df_ = df["Nums"].apply(pd.Series)
Out[39]:
0 1
index0 976 660
index1 984 360
index2 246 127
index3 252 345
index4 1419 1373
index5 103 515
### Step2: Join back to the original df
pd.merge(df, df_, left_index = True, right_index = True)
Out[40]:
Food Nums 0 1
index0 Cows' milk, whole (976, 660) 976 660
index1 skim (984, 360) 984 360
index2 Buttermilk, cultured (246, 127) 246 127
index3 Evaporated, undiluted (252, 345) 252 345
index4 Fortified milk (1419, 1373) 1419 1373
index5 Powdered milk, whole (103, 515) 103 515
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment