I’m a beginner in Python, so please bear with me here. I appreciate all the help as well.
I would like to generate all possible combinations between two lists. I have an excel file that I’m bringing into the code, where the first two columns are populated with text in the cells("List 1" is the first column. "List 2" is the second column, with "List 2" having the longer list). I’m treating each column as its own list. Any help here would be greatly appreciated as well.
I’m running into an error with my simple code, which is this:
TypeError Traceback (most recent call last) <ipython-input-6-e72255edcda8> in <module> 1 #have the two column lists in the excel file be recognized as lists in python ----> 2 list_1 = list(df1('List 1')) 3 list_2 = list(df1('List 2')) 4 all_combinations =  5 TypeError: 'DataFrame' object is not callable
Here’s my code currently:
lists_combos = "combos_list.csv
import itertools import pandas as pd from itertools import permutations from itertools import combinations
df1 = pd.read_csv(lists_combos)
list_1 = list(df1('List 1')) list_2 = list(df1('List 2')) all_combinations =  list_2_permutations = itertools.permutations(list_2, len(list_1)) for each_permutation in list_2_permutations: zipped = zip(each_permutation, list_1) all_combinations.append(list(zipped)) print(all_combinations)
I would also like to make an output .csv file of the possible combinations between the two lists. Any help here would be greatly appreciated as well. Thanks.
Source: Python Questions