pandas 列表转 DataFrame， DataFrame 转 列表

connect = self.connect_sqlserver()
cursor = connect.cursor()
sql = 'select id,keyword from xxxx'
cursor.execute(sql)
key_lists = [[key[0], key[1]] for key in cursor.fetchall()]
connect.close()
key_list_pd = pd.DataFrame(key_lists,columns=['col1', 'col2']) ## 转成Dataframe
key_list_pd1 = key_list_pd.drop_duplicates(['col2'], keep='first')  ## 去重
key_list_pd2 = np.array(key_list_pd1).tolist()  ## 转成列表