2023年2月10日 03:06:15go评论105阅读模式

英文:

How to create a dictionary with key and multiple values based on the data queried from database

问题

以下是您要翻译的内容：

New to python and was wondering how to create a dictionary with key and multiple values so that I can pass it to HTML to display it on the UI. Below is the data format.

Questions from questions table -

[{'question_id': 1, 'question_text': 'How many servers run at max capacity?', 'category_id':  1, 'is_long_survey': 0},
    {'question_id': 2, 'question_text': 'Is the database getting replicated?', 'category_id': 1, 'is_long_survey': 0},
    {'question_id': 3, 'question_text': 'Where is the infrastructure located?', 'category_id': 1, 'is_long_survey': 0}]"

Choices for these questions come from choice table with question_id as the foreign key.

[{'choice_id' : 1, 'choice_text': '2', 'question_id': 1},
 {'choice_id' : 2, 'choice_text': '4', 'question_id': 1},
 {'choice_id' : 3, 'choice_text': '6', 'question_id': 1},
 {'choice_id' : 4, 'choice_text': 'Yes', 'question_id': 2},
 {'choice_id' : 5, 'choice_text': 'No', 'question_id': 2},
 {'choice_id' : 6, 'choice_text': 'global', 'question_id': 3},
 {'choice_id' : 7, 'choice_text': 'local', 'question_id': 3}]

So each question has lets say 3 choices as shown below.

To display question text and their choices on the UI, how do I create a dictionary of question text as key and may be choices as multiple array values? Any other data structure I can use to format the data?

英文:

New to python and was wondering how to create a dictionary with key and multiple values so that I can pass it to HTML to display it on the UI. Below is the data format.

Questions from questions table -

 [{&#39;question_id&#39;: 1, &#39;question_text&#39;: &#39;How many servers run at max capacity?&#39;, &#39;category_id&#39;:  1, &#39;is_long_survey&#39;: 0}, 
    {&#39;question_id&#39;: 2, &#39;question_text&#39;: &#39;Is the database getting replicated?&#39;, &#39;category_id&#39;: 1, &#39;is_long_survey&#39;: 0}, 
    {&#39;question_id&#39;: 3, &#39;question_text&#39;: &#39;Where is the infrastructure located?&#39;, &#39;category_id&#39;: 1, &#39;is_long_survey&#39;: 0}]&quot;

Choices for these questions come from choice table with question_id as the foreign key.

[{&#39;choice_id&#39; : 1, &#39;choice_text&#39;: &#39;2&#39;, &#39;question_id&#39;: 1},
 {&#39;choice_id&#39; : 2, &#39;choice_text&#39;: &#39;4&#39;, &#39;question_id&#39;: 1}, 
 {&#39;choice_id&#39; : 3, &#39;choice_text&#39;: &#39;6&#39;, &#39;question_id&#39;: 1},
 {&#39;choice_id&#39; : 4, &#39;choice_text&#39;: &#39;Yes&#39;, &#39;question_id&#39;: 2},
 {&#39;choice_id&#39; : 5, &#39;choice_text&#39;: &#39;No&#39;, &#39;question_id&#39;: 2},
 {&#39;choice_id&#39; : 6, &#39;choice_text&#39;: &#39;global&#39;, &#39;question_id&#39;: 3},
 {&#39;choice_id&#39; : 7, &#39;choice_text&#39;: &#39;local&#39;, &#39;question_id&#39;: 3}]

So each question has lets say 3 choices as shown below.

答案1

得分: 0

你可以像这样做：

qDicts = [ 
    {'question_id': 1, 'question_text': 'How many servers run at max capacity?', 'category_id':  1, 'is_long_survey': 0}, 
    {'question_id': 2, 'question_text': 'Is the database getting replicated?', 'category_id': 1, 'is_long_survey': 0}, 
    {'question_id': 3, 'question_text': 'Where is the infrastructure located?', 'category_id': 1, 'is_long_survey': 0}  
]
chDicts = [
    {'choice_id' : 1, 'choice_text': '2', 'question_id': 1},
    {'choice_id' : 2, 'choice_text': '4', 'question_id': 1}, 
    {'choice_id' : 3, 'choice_text': '6', 'question_id': 1},
    {'choice_id' : 4, 'choice_text': 'Yes', 'question_id': 2},
    {'choice_id' : 5, 'choice_text': 'No', 'question_id': 2},
    {'choice_id' : 6, 'choice_text': 'global', 'question_id': 3},
    {'choice_id' : 7, 'choice_text': 'local', 'question_id': 3}
]
qustionChoices = {q['question_text']: [
    c['choice_text'] for c in chDicts
    if c['question_id']==q['question_id']
] for q in qDicts}

这使用了字典推导（用于构建qustionChoices字典本身）以及列表推导（用于为每个问题构建选择列表）。生成的输出（qustionChoices）应该如下所示：

{'How many servers run at max capacity?': ['2', '4', '6'],
 'Is the database getting replicated?': ['Yes', 'No'],
 'Where is the infrastructure located?': ['global', 'local']}

另外，你也可以将相关的选项嵌套到qDicts中，使其看起来像这样：

[{'question_id': 1,
  'question_text': 'How many servers run at max capacity?',
  'category_id': 1,
  'is_long_survey': 0,
  'choices': [
    {'choice_id': 1, 'choice_text': '2', 'question_id': 1},
    {'choice_id': 2, 'choice_text': '4', 'question_id': 1},
    {'choice_id': 3, 'choice_text': '6', 'question_id': 1}]},
 {'question_id': 2,
  'question_text': 'Is the database getting replicated?',
  'category_id': 1,
  'is_long_survey': 0,
  'choices': [
    {'choice_id': 4, 'choice_text': 'Yes', 'question_id': 2},
    {'choice_id': 5, 'choice_text': 'No', 'question_id': 2}]},
 {'question_id': 3,
  'question_text': 'Where is the infrastructure located?',
  'category_id': 1,
  'is_long_survey': 0,
  'choices': [
    {'choice_id': 6, 'choice_text': 'global', 'question_id': 3},
    {'choice_id': 7, 'choice_text': 'local', 'question_id': 3}]}
]

通过循环遍历qDicts（使用enumerate生成的索引）可以实现上述嵌套：

for qi, qd in enumerate(qDicts):
    qDicts[qi]['choices'] = [
        c for c in chDicts if c['question_id']==qd['question_id']]

或者，如果你更喜欢嵌套的字典在一个新的变量中（如下面的q_wCh），可以使用以下方式：

q_wCh = [{**q, 'choices':[
    c for c in chDicts if c['question_id']==q['question_id']
]} for q in qDicts]

在上述代码中，**q 用于解包每个qDicts中的字典。

英文:

You could do something like

qDicts = [ 
    {&#39;question_id&#39;: 1, &#39;question_text&#39;: &#39;How many servers run at max capacity?&#39;, &#39;category_id&#39;:  1, &#39;is_long_survey&#39;: 0}, 
    {&#39;question_id&#39;: 2, &#39;question_text&#39;: &#39;Is the database getting replicated?&#39;, &#39;category_id&#39;: 1, &#39;is_long_survey&#39;: 0}, 
    {&#39;question_id&#39;: 3, &#39;question_text&#39;: &#39;Where is the infrastructure located?&#39;, &#39;category_id&#39;: 1, &#39;is_long_survey&#39;: 0}  
] ## [ FROM YOUR EXAMPLE ] 
chDicts = [
    {&#39;choice_id&#39; : 1, &#39;choice_text&#39;: &#39;2&#39;, &#39;question_id&#39;: 1},
    {&#39;choice_id&#39; : 2, &#39;choice_text&#39;: &#39;4&#39;, &#39;question_id&#39;: 1}, 
    {&#39;choice_id&#39; : 3, &#39;choice_text&#39;: &#39;6&#39;, &#39;question_id&#39;: 1},
    {&#39;choice_id&#39; : 4, &#39;choice_text&#39;: &#39;Yes&#39;, &#39;question_id&#39;: 2},
    {&#39;choice_id&#39; : 5, &#39;choice_text&#39;: &#39;No&#39;, &#39;question_id&#39;: 2},
    {&#39;choice_id&#39; : 6, &#39;choice_text&#39;: &#39;global&#39;, &#39;question_id&#39;: 3},
    {&#39;choice_id&#39; : 7, &#39;choice_text&#39;: &#39;local&#39;, &#39;question_id&#39;: 3}
] ## [ FROM YOUR EXAMPLE ] 
qustionChoices = {q[&#39;question_text&#39;]: [
    c[&#39;choice_text&#39;] for c in chDicts
    if c[&#39;question_id&#39;]==q[&#39;question_id&#39;]
] for q in qDicts} ## [ OUTPUT ]

This uses dictionary comprehension (to form the qustionChoices dictionary itself) as well as list comprehension (to build a list of choices for each question). The resulting output (qustionChoices) should look like:

> python > {'How many servers run at max capacity?': ['2', '4', '6'], > 'Is the database getting replicated?': ['Yes', 'No'], > 'Where is the infrastructure located?': ['global', 'local']} >

You can also nest the relevant choices into qDicts so that it looks something like

> python > [{'question_id': 1, > 'question_text': 'How many servers run at max capacity?', > 'category_id': 1, > 'is_long_survey': 0, > 'choices': [ > {'choice_id': 1, 'choice_text': '2', 'question_id': 1}, > {'choice_id': 2, 'choice_text': '4', 'question_id': 1}, > {'choice_id': 3, 'choice_text': '6', 'question_id': 1}] }, > {'question_id': 2, > 'question_text': 'Is the database getting replicated?', > 'category_id': 1, > 'is_long_survey': 0, > 'choices': [ > {'choice_id': 4, 'choice_text': 'Yes', 'question_id': 2}, > {'choice_id': 5, 'choice_text': 'No', 'question_id': 2}] }, > {'question_id': 3, > 'question_text': 'Where is the infrastructure located?', > 'category_id': 1, > 'is_long_survey': 0, > 'choices': [ > {'choice_id': 6, 'choice_text': 'global', 'question_id': 3}, > {'choice_id': 7, 'choice_text': 'local', 'question_id': 3}] } ] >

by looping through it (with indices generated by enumerate) as below.

for qi, qd in enumerate(qDicts):
    qDicts[qi][&#39;choices&#39;] = [
        c for c in chDicts if c[&#39;question_id&#39;]==qd[&#39;question_id&#39;]]

or, if you'd prefer the nested dictionaries to be in a new variable (like q_wCh below),

q_wCh = [{**q, &#39;choices&#39;:[
    c for c in chDicts if c[&#39;question_id&#39;]==q[&#39;question_id&#39;]
]} for q in qDicts]

[ **q is used to unpack each dictionary q in qDicts ]

通过集体智慧和协作来改善编程学习和解决问题的方式。致力于成为全球开发者共同参与的知识库，让每个人都能够通过互相帮助和分享经验来进步。

如何根据从数据库查询的数据创建一个带有键和多个值的字典。

问题

答案1

Find all the texts which is 'Normal' style and font size is NOT 11 in a docx file using python-docx

添加（和）逻辑以处理列的列表并生成特征。

如何在固定数量的纸币之间分配价值

如何在Python中比较两个Excel文件中的列？

如何在Playwright视觉比较中屏蔽多个定位器？

在C++中，可以使用可变模板参数来检索类型的内部类型。

selenium.common.exceptions.StaleElementReferenceException: Message: stale element reference: stale element not found

Creating and opening a URL to log in to Website via Basic Auth with Robot Framework/Selenium (Python)

AG Grid 在上下文菜单中以大文本形式打开

What's the correct way to type hint an empty list as a literal in python?

如何在Highcharts Gantt中更改本地化的星期名称

如何在同一个流中使用多个过滤器和映射函数？

如何使用Map/Set来将代码优化到O(n)？

.NET MAUI Android在GitHub Actions上构建失败，错误代码为1。