Ta的回答
首先,如果这是一个任务表,为什么没有任务 ID?如果我对问题的理解正确,那么GROUP BY或者DISTINCTSELECT project_id, task, status FROM Table WHERE project_id = 1 AND Status_Code IN (0,1,2,3,4,5,6)GROUP BYproject_id, task, status这将返回所有 3 列 uai...
[查看全部]
Ta的回答
如果要将索引设置为a,请执行以下操作:d = {'a':[10,11,12,13],'b':[20,21,22,23], 'c':[30,31,32,33]}pd_df = pd.DataFrame(d)pd_df = pd_df.set_index('a') ## <<< CHANGE HERE然后pd...
[查看全部]