# Version for one list column to put in signle row
lst_col = 'my_list_var'
r = pd.DataFrame({
col:np.repeat(df[col].values, df[lst_col].str.len())
for col in df.columns.drop(lst_col)}
).assign(**{lst_col:np.concatenate(df[lst_col].values)})[df.columns]
# Version for multiple list column and put them in signle row --> long format
lst_col = 'my_list_var'
lst_col_1 = 'my_list_var_1'
lst_col_2 = 'my_list_var_2'
r = pd.DataFrame({
col:np.repeat(df1[col].values, df1[lst_col].str.len()) # Repeat column values N times where N is the lenght of list
for col in df1.columns} # np.concatenate() --> flatten all values in the list column and get a 1D vector
).assign(**{lst_col:np.concatenate(df1[lst_col].values), # ** --> out data into a dictionary
lst_col_1:np.concatenate(df1[lst_col_1].values),
lst_col_2:np.concatenate(df1[lst_col_2].values)
})
Rename Row Pandas Code Example - pandas
Getting Dummies And Input Them To Pandas Dataframe Code Example - pandas
Pandas Count Rows With Value Code Example - pandas
Add An Index Column Pandas Code Example - pandas
Pandas Ttable With Sum Totals Code Example - pandas
Remove 1st Column Pandas Code Example - pandas
Pandas Iterrows Code Example - pandas
Slicing In Pandas Code Example - pandas
Convert Pandas Data Frame To Latex File Code Example - pandas
Append New Data On Pandas Dataframe Code Example - pandas
Pandas Dataframe Froms String Code Example - pandas
Combine Two Dataframe In Pandas Code Example - pandas
Str_Count On Pandas Series Code Example - pandas
Dictionary To A Dataframe Pandas Arrays Must All Be Same Length Code Example - pandas
How To Drop Columns In Pandas Code Example - pandas
Pandas Select All Columns Except One Code Example - pandas
How To Change Column Name In Pandas Code Example - pandas
Creating A Pandas Df Code Example - pandas
Pandas Read From Website Code Example - pandas
Pandas Show Top 10 Rows Code Example - pandas
Index Max Pandas Code Example - pandas
Pandas Cumulative Sum Column Code Example - pandas
Onehot Encode List Of Columns Pandas Code Example - pandas
How To Set Pandas Dataframe As Global Code Example - pandas
Pandas Merge Two Columns From Different Dataframes Code Example - pandas
Pandas Frame Convert String Code Example - pandas
How To Merge Two Column Pandas Code Example - pandas