search_results.loc[:, "result_skus"] = \ search_results["search_result"].apply(lambda x: [item['my_id'] for item in ast.literal_eval(x)]) search_results.head()