我有一个可扩展的维度列表,
sex = ['male', 'female']
yearold = ['<20', '21-30', '31-40', '41-50', '51-60', '>60']
time = ['9am', '10am', '11am']
如何创建笛卡尔积并将列表名称作为标题输出为 csv 文件(来自列表列表)?到目前为止,我已经尝试将其转换为字典:
from collections import defaultdict
d = defaultdict(list)
d['sex'].extend(sex)
d['yearold'].extend(yearold)
d['time'].extend(time)
def cartesian(*arg):
product=[]
for element in itertools.product(*arg):
product.append(element)
titlerow=[]
for key, value in d.iteritems() :
titlerow.append(key)
mylist.insert(0,titlerow)
cartesian(sex,yearold,time)
只为标题同时拥有列表和字典似乎有点困惑。我知道 **kwargs 有一定用途,但不确定如何将其合并!
请您参考如下方法:
如果您关心行的顺序,您可以将这些值用于 OrderedDict:
from collections import OrderedDict
import itertools,csv
sex = ['male', 'female']
yearold = ['<20', '21-30', '31-40', '41-50', '51-60', '>60']
time = ['9am', '10am', '11am']
d = OrderedDict([('sex',sex),('yearold',yearold),('time', time)])
with open('output.csv','wb') as f:
w = csv.writer(f)
w.writerow([k for k in d.keys()])
for e in itertools.product(*[v for v in d.values()]):
w.writerow([str(i) for i in e])
输出:
sex,yearold,time
male,<20,9am
male,<20,10am
male,<20,11am
male,21-30,9am
male,21-30,10am
male,21-30,11am
male,31-40,9am
male,31-40,10am
male,31-40,11am
male,41-50,9am
male,41-50,10am
male,41-50,11am
male,51-60,9am
male,51-60,10am
male,51-60,11am
male,>60,9am
male,>60,10am
male,>60,11am
female,<20,9am
female,<20,10am
female,<20,11am
female,21-30,9am
female,21-30,10am
female,21-30,11am
female,31-40,9am
female,31-40,10am
female,31-40,11am
female,41-50,9am
female,41-50,10am
female,41-50,11am
female,51-60,9am
female,51-60,10am
female,51-60,11am
female,>60,9am
female,>60,10am
female,>60,11am
