pandas - List Questions - Page 3

EN VI

Posts (0)

Questions (50)

Best Solution Bot

Python - In a dataframe, how can i find if each row number appears in a column of lists?

With (~)isin/explode: pos["flag"] = ~pos.index.isin(pos["id"].explode()) # .astype(int) ? Output : id pred flag 1 [4, 4] NaN True 2 [2] NaN False 3 [2, 4] NaN True 4 [2] N...

Tags: python, pandas

Best Solution Bot

Python-3.x - Max value in range for each row in Pandas?

Try: df['max_range'] = df['A'].rolling(4).max() Output: A max_range 0 10 NaN 1 12 NaN 2 14 NaN 3 8 14.0 4 9 14.0 5 10 14.0 6...

Tags: python-3.x, pandas, dataframe

Best Solution Bot

Python - MultiIndex DataFrame to a Standard index DF?

You can drop the second level index and then reset the index: print(df2.droplevel(1).reset_index()) Prints: old_code new_code 0 00000001 99999991 1 00000002 99999992 2 00000002 99999922 3...

Tags: python, python-3.x, pandas

Best Solution Bot

Python - Append lists of elements as rows in df based on groupby?

IIUC, explode, merge, and concat: out = (pd.concat([ df, legend .explode('word_lists') .rename(columns={'word_lists': 'word'}) .merge(df[['object', 'personID']].d...

Tags: python, pandas, dataframe

Best Solution Bot

Python - Find a combination of column values exists in Lookup table?

IIUC you can do left merge on d2: d2 = d2.merge(d1, on=["c1", "c2"], how="left") d2["c1_c2_found"] = d2.pop("val").notna().astype(int) print(d2) Prints: c1 c2 c1_found c2_found c1_c2_found 0 A...

Tags: python, python-3.x, pandas

Best Solution Bot

Python - Group dataframe and sample n rows with equal probability between groups?

If you want to sample N rows with about the same probability to sample each group, you could oversample per group then sample again: import math N = 4 out = (df.groupby('ID').sample(n=math.ceil(N/df...

Tags: python, pandas, group-by

Best Solution Bot

Python - Adding numpy arrays to cells of a pandas DataFrame depends on initialisation?

You have to create a Series with the correct index: m = df['B']==4 df.loc[m, 'A'] = pd.Series([np.array([5, 6, 7, 8]), np.array([2, 3])], index=df.index[m]) Note that in a...

Tags: python, arrays, pandas

Best Solution Bot

Python - Replacing a value in a row of a column with a function of a list formed by corresponding elements of the dataframe?

IIUC, you can create a dictionary of indices that are referenced by other indices. Then loop over the -1 indices in reverse and index the relevant rows to pass to f: s = df['pred'].explode() dic = s.i...

Tags: python, pandas, dataframe

Best Solution Bot

Python - BeatuifulSoup fetch data and parse - from European Volunteering-Services: a tiny scraper that collects opportunities from EU-Site?

First check whether the elements you want to select are contained in response / soup; the ones you are addressing do not appear to be present. So as mentioned by @John Gordon your selection is not fin...

Tags: python, pandas, dataframe

Best Solution Bot

Python - Pandas: move values from one column to an appropriate column?

If the groups are sorted and the pattern is always the same (no missing values), then reshape with numpy: cols = ['Person', 'Place', 'Thing'] out = df.loc[::len(cols), ['Sample']].reset_index(drop=Tr...

Tags: python, pandas

Pinned Posts

Top 5 Best High CPM Ads Networks For Publishers In 2023

Tags: ads, Publishers, Ads Networks

HawkHost Coupon 2023 – Hawk Hosting Discount Code Up to 40% Lifetime Update Every Day

Tags: Server, host, cloud