本文介绍了如何使用Pandas在Python中，通过DataFrame操作获取students表与subjects表的笛卡尔积，展示了如何利用`pd.DataFrame.crosstab`或`pd.merge`函数实现数据的合并。
data = [[1, 'Alice'], [2, 'Bob'], [13, 'John'], [6, 'Alex']]
students = pd.DataFrame(data, columns=['student_id', 'student_name']).astype({'student_id':'Int64', 'student_name':'object'})
data = [['Math'], ['Physics'], ['Programming']]
subjects = pd.DataFrame(data, columns=['subject_name']).astype({'subject_name':'object'})
data = [[1, 'Math'], [1, 'Physics'], [1, 'Programming'], [2, 'Programming'], [1, 'Physics'], [1, 'Math'], [13, 'Math'], [13, 'Programming'], [13, 'Physics'], [2, 'Math'], [1, 'Math']]
examinations = pd.DataFrame(data, columns=['student_id', 'subject_name']).astype({'student_id':'Int64', 'subject_name':'object'})得到students与subjects的笛卡尔积
直接在参数how指定cross
2013
被折叠的 条评论
为什么被折叠?
到【灌水乐园】发言
