问题

我尝试将名为Customer Details的列表与名为Address、Credit card info和Vehicle的其他列表组合在一起，使用Customer Details列表中的"First Name"和"Last Name"。

我希望获得以下结果：

[
{
"First Name": "Kieran",
"Last Name": "Wilson",
"Age (Years)": "89",
"Marital Status": "married or civil partner",
"Distance Commuted to Work (miles)": "0",
"Employer Company": "N/A",
"Dependants": "3",
"Yearly Pension (GBP)": "7257",
"Sex": "Male",
"Retired": "TRUE",
"Yearly Salary (GBP)": "72838"
},
{
"Address Street": "70 Lydia isle",
"Address City": "Lake Conor",
"Address Postcode": "S71 7XZ"
},
{
"Credit Card Start Date": "18-Aug",
"Credit Card Expiry Date": "27-Nov",
"Credit Card CVV": "875",
"Credit Card Number": "6.76374E+11",
"Bank IBAN": "GB62PQKB71416034141571"
},
{
"Vehicle Make": "Hyundai",
"Vehicle Model": "Bonneville",
"Vehicle Type": "Pickup",
"Vehicle Year": "2009"
}
]
对于第一个客户

英文:

I am trying to combine a list called Customer Details

[{'First Name': 'Kieran', 'Last Name': 'Wilson', 'Age (Years)': '89', 'Marital Status': 'married or civil partner', 'Distance Commuted to Work (miles)': '0', 'Employer Company': 'N/A', 'Dependants': '3', 'Yearly Pension (GBP)': '7257', 'Sex': 'Male', 'Retired': 'TRUE', 'Yearly Salary (GBP)': '72838'}
with a list called Address
[{'Address Street': '70 Lydia isle', 'Address City': 'Lake Conor', 'Address Postcode': 'S71 7XZ'}, {'Address Street': '00 Wheeler wells', 'Address City': 'Chapmanton', 'Address Postcode': 'L2 7BT'}
and Credit card info
[{'Credit Card Start Date': '18-Aug', 'Credit Card Expiry Date': '27-Nov', 'Credit Card CVV': '875', 'Credit Card Number': '6.76374E+11', 'Bank IBAN': 'GB62PQKB71416034141571'}
and Vehicle
[{'Vehicle Make': 'Hyundai', 'Vehicle Model': 'Bonneville', 'Vehicle Type': 'Pickup', 'Vehicle Year': '2009'}

How do I combine this using First Name and Last Name in the Customer Details list

This is the result I am hoping to get

[
{
"First Name": "Kieran",
"Last Name": "Wilson",
"Age (Years)": "89",
"Marital Status": "married or civil partner",
"Distance Commuted to Work (miles)": "0",
"Employer Company": "N/A",
"Dependants": "3",
"Yearly Pension (GBP)": "7257",
"Sex": "Male",
"Retired": "TRUE",
"Yearly Salary (GBP)": "72838"},
{
"Address Street": "70 Lydia isle",
"Address City": "Lake Conor",
"Address Postcode": "S71 7XZ"
},
{
"Credit Card Start Date": "18-Aug",
"Credit Card Expiry Date": "27-Nov",
"Credit Card CVV": "875",
"Credit Card Number": "6.76374E+11",
"Bank IBAN": "GB62PQKB71416034141571"
},
{
"Vehicle Make": "Hyundai",
"Vehicle Model": "Bonneville",
"Vehicle Type": "Pickup",
"Vehicle Year": "2009"
}
]
for the first customer

答案1

得分: 0

[[{'First Name': 'Kieran', 'Last Name': 'Wilson', 'Age (Years)': '89', 'Marital Status': 'married or civil partner', 'Distance Commuted to Work (miles)': '0', 'Employer Company': 'N/A', 'Dependants': '3', 'Yearly Pension (GBP)': '7257', 'Sex': 'Male', 'Retired': 'TRUE', 'Yearly Salary (GBP)': '72838'}, {'Address Street': '70 Lydia isle', 'Address City': 'Lake Conor', 'Address Postcode': 'S71 7XZ'}, {'Credit Card Start Date': '18-Aug', 'Credit Card Expiry Date': '27-Nov', 'Credit Card CVV': '875', 'Credit Card Number': '6.76374E+11', 'Bank IBAN': 'GB62PQKB71416034141571'}, {'Vehicle Make': 'Hyundai', 'Vehicle Model': 'Bonneville', 'Vehicle Type': 'Pickup', 'Vehicle Year': '2009'}]]

英文:

customer_details = [{&#39;First Name&#39;: &#39;Kieran&#39;, &#39;Last Name&#39;: &#39;Wilson&#39;, &#39;Age (Years)&#39;: &#39;89&#39;, &#39;Marital Status&#39;: &#39;married or civil partner&#39;, &#39;Distance Commuted to Work (miles)&#39;: &#39;0&#39;, &#39;Employer Company&#39;: &#39;N/A&#39;, &#39;Dependants&#39;: &#39;3&#39;, &#39;Yearly Pension (GBP)&#39;: &#39;7257&#39;, &#39;Sex&#39;: &#39;Male&#39;, &#39;Retired&#39;: &#39;TRUE&#39;, &#39;Yearly Salary (GBP)&#39;: &#39;72838&#39;}]
address = [{&#39;Address Street&#39;: &#39;70 Lydia isle&#39;, &#39;Address City&#39;: &#39;Lake Conor&#39;, &#39;Address Postcode&#39;: &#39;S71 7XZ&#39;}, {&#39;Address Street&#39;: &#39;00 Wheeler wells&#39;, &#39;Address City&#39;: &#39;Chapmanton&#39;, &#39;Address Postcode&#39;: &#39;L2 7BT&#39;}]
cc_info = [{&#39;Credit Card Start Date&#39;: &#39;18-Aug&#39;, &#39;Credit Card Expiry Date&#39;: &#39;27-Nov&#39;, &#39;Credit Card CVV&#39;: &#39;875&#39;, &#39;Credit Card Number&#39;: &#39;6.76374E+11&#39;, &#39;Bank IBAN&#39;: &#39;GB62PQKB71416034141571&#39;}]
vehicle = [{&#39;Vehicle Make&#39;: &#39;Hyundai&#39;, &#39;Vehicle Model&#39;: &#39;Bonneville&#39;, &#39;Vehicle Type&#39;: &#39;Pickup&#39;, &#39;Vehicle Year&#39;: &#39;2009&#39;}]

result = [[customer_details[i], address[i], cc_info[i], vehicle[i]] for i in range(len(customer_details))]

print(result)

results in:

[[{&#39;First Name&#39;: &#39;Kieran&#39;, &#39;Last Name&#39;: &#39;Wilson&#39;, &#39;Age (Years)&#39;: &#39;89&#39;, &#39;Marital Status&#39;: &#39;married or civil partner&#39;, &#39;Distance Commuted to Work (miles)&#39;: &#39;0&#39;, &#39;Employer Company&#39;: &#39;N/A&#39;, &#39;Dependants&#39;: &#39;3&#39;, &#39;Yearly Pension (GBP)&#39;: &#39;7257&#39;, &#39;Sex&#39;: &#39;Male&#39;, &#39;Retired&#39;: &#39;TRUE&#39;, &#39;Yearly Salary (GBP)&#39;: &#39;72838&#39;}, {&#39;Address Street&#39;: &#39;70 Lydia isle&#39;, &#39;Address City&#39;: &#39;Lake Conor&#39;, &#39;Address Postcode&#39;: &#39;S71 7XZ&#39;}, {&#39;Credit Card Start Date&#39;: &#39;18-Aug&#39;, &#39;Credit Card Expiry Date&#39;: &#39;27-Nov&#39;, &#39;Credit Card CVV&#39;: &#39;875&#39;, &#39;Credit Card Number&#39;: &#39;6.76374E+11&#39;, &#39;Bank IBAN&#39;: &#39;GB62PQKB71416034141571&#39;}, {&#39;Vehicle Make&#39;: &#39;Hyundai&#39;, &#39;Vehicle Model&#39;: &#39;Bonneville&#39;, &#39;Vehicle Type&#39;: &#39;Pickup&#39;, &#39;Vehicle Year&#39;: &#39;2009&#39;}]]

答案2

得分: 0

你可以使用字典合并来实现这一点。
字典合并运算符 ** 是自 Python 3.9 版本引入的。请注意有两个不同的合并运算符，| 和 **。| 运算符用于创建联合，可以消除重复的键。

customer_details = [{'First Name': 'Kieran', 'Last Name': 'Wilson', 'Age (Years)': '89', 'Marital Status': 'married or civil partner', 'Distance Commuted to Work (miles)': '0', 'Employer Company': 'N/A', 'Dependants': '3', 'Yearly Pension (GBP)': '7257', 'Sex': 'Male', 'Retired': 'TRUE', 'Yearly Salary (GBP)': '72838'}]
address = [{'Address Street': '70 Lydia isle', 'Address City': 'Lake Conor', 'Address Postcode': 'S71 7XZ'}, {'Address Street': '00 Wheeler wells', 'Address City': 'Chapmanton', 'Address Postcode': 'L2 7BT'}]
credit_card_info = [{'Credit Card Start Date': '18-Aug', 'Credit Card Expiry Date': '27-Nov', 'Credit Card CVV': '875', 'Credit Card Number': '6.76374E+11', 'Bank IBAN': 'GB62PQKB71416034141571'}]
vehicle = [{'Vehicle Make': 'Hyundai', 'Vehicle Model': 'Bonneville', 'Vehicle Type': 'Pickup', 'Vehicle Year': '2009'}]

# 基于客户的名和姓合并所有列表
result = [{**customer, **{'Address': address, 'Credit Card Info': credit_card_info, 'Vehicle': vehicle}} for customer in customer_details]

print(result)

英文:

You can use dictionary merging to achieve this.
Dictionary merge operator ** is new since Python 3.9. Be aware there are two different merge-operators, | and **. The |operator creates unions, which eliminates duplicate keys.

customer_details = [{&#39;First Name&#39;: &#39;Kieran&#39;, &#39;Last Name&#39;: &#39;Wilson&#39;, &#39;Age (Years)&#39;: &#39;89&#39;, &#39;Marital Status&#39;: &#39;married or civil partner&#39;, &#39;Distance Commuted to Work (miles)&#39;: &#39;0&#39;, &#39;Employer Company&#39;: &#39;N/A&#39;, &#39;Dependants&#39;: &#39;3&#39;, &#39;Yearly Pension (GBP)&#39;: &#39;7257&#39;, &#39;Sex&#39;: &#39;Male&#39;, &#39;Retired&#39;: &#39;TRUE&#39;, &#39;Yearly Salary (GBP)&#39;: &#39;72838&#39;}]
address = [{&#39;Address Street&#39;: &#39;70 Lydia isle&#39;, &#39;Address City&#39;: &#39;Lake Conor&#39;, &#39;Address Postcode&#39;: &#39;S71 7XZ&#39;}, {&#39;Address Street&#39;: &#39;00 Wheeler wells&#39;, &#39;Address City&#39;: &#39;Chapmanton&#39;, &#39;Address Postcode&#39;: &#39;L2 7BT&#39;}]
credit_card_info = [{&#39;Credit Card Start Date&#39;: &#39;18-Aug&#39;, &#39;Credit Card Expiry Date&#39;: &#39;27-Nov&#39;, &#39;Credit Card CVV&#39;: &#39;875&#39;, &#39;Credit Card Number&#39;: &#39;6.76374E+11&#39;, &#39;Bank IBAN&#39;: &#39;GB62PQKB71416034141571&#39;}]
vehicle = [{&#39;Vehicle Make&#39;: &#39;Hyundai&#39;, &#39;Vehicle Model&#39;: &#39;Bonneville&#39;, &#39;Vehicle Type&#39;: &#39;Pickup&#39;, &#39;Vehicle Year&#39;: &#39;2009&#39;}]

# Merge all the lists based on the customer&#39;s first name and last name
result = [{**customer, **{&#39;Address&#39;: address, &#39;Credit Card Info&#39;: credit_card_info, &#39;Vehicle&#39;: vehicle}}           for customer in customer_details]

print(result)

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

将嵌套的列表与字典组合在一起。

问题

答案1

答案2

Counting the frequency of ‘BB’ or ‘EE’ in a string using Python

在标点符号后如果它位于行尾，如何添加空格。

使用正则表达式从字符串列表中移除所有位于’a’和’b’之间的字符串。

在一个pandas数据框中更改多列条目。

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。

如何在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 在上下文菜单中以大文本形式打开

发表评论