# Returns the cartesian product with another DataFrame
df.select("age", "name").collect()
# [Row(age=2, name='Alice'), Row(age=5, name='Bob')]
df2.select("name", "height").collect()
# [Row(name='Tom', height=80), Row(name='Bob', height=85)]
df.crossJoin(df2.select("height")).select(
"age", "name", "height").collect()
# [Row(age=2, name='Alice', height=80), Row(age=2, name='Alice', height=85), Row(age=55, name='Bob', height=80), Row(age=5, name='Bob', height=85)]
Snippet 2
a = [1, 2, 3]
b = ["a", "b", "c"]
index = pd.MultiIndex.from_product([a, b], names = ["a", "b"])
pd.DataFrame(index = index).reset_index()
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
Getting Dummies And Input Them To 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
Rename Row Pandas 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