coding-mentor-agent/kb/python-course-kb-practical-python/wiki/exercises/2-21-data-queries.md

id, source_exercise_id, title, section, source_path, source_repo, source_commit, student_visible_solution, has_private_solution, skip

id	source_exercise_id	title	section	source_path	source_repo	source_commit	student_visible_solution	has_private_solution	skip
practical-python-2.21	2.21	Data Queries	2.6 List Comprehensions	02_Working_with_data/06_List_comprehension.md	https://github.com/dabeaz-course/practical-python	93dca856b41c61a0a0f85ae334116e4c125629ea	false	false	false

Exercise 2.21: Data Queries

Source: Practical Python Programming, 02_Working_with_data/06_List_comprehension.md.

Exercise 2.21: Data Queries

Try the following examples of various data queries.

First, a list of all portfolio holdings with more than 100 shares.

>>> more100 = [ s for s in portfolio if s['shares'] > 100 ]
>>> more100
[{'price': 83.44, 'name': 'CAT', 'shares': 150}, {'price': 51.23, 'name': 'MSFT', 'shares': 200}]
>>>

All portfolio holdings for MSFT and IBM stocks.

>>> msftibm = [ s for s in portfolio if s['name'] in {'MSFT','IBM'} ]
>>> msftibm
[{'price': 91.1, 'name': 'IBM', 'shares': 50}, {'price': 51.23, 'name': 'MSFT', 'shares': 200},
  {'price': 65.1, 'name': 'MSFT', 'shares': 50}, {'price': 70.44, 'name': 'IBM', 'shares': 100}]
>>>

A list of all portfolio holdings that cost more than $10000.

>>> cost10k = [ s for s in portfolio if s['shares'] * s['price'] > 10000 ]
>>> cost10k
[{'price': 83.44, 'name': 'CAT', 'shares': 150}, {'price': 51.23, 'name': 'MSFT', 'shares': 200}]
>>>

关联来源

• summaries/06_List_comprehension