Python - SQLite - List Comprehensions: Database Integrations - tuple
Head First Python: A Learner’s Guide to the Fundamentals of Python Programming, A Brain-Friendly Guide、 Paul Barry(著)、 O’Reilly Mediaの Chapter 13.(List Comprehensions: Database Integrations)、EXERCISE(603/682)の解答を求めてみる。
Jupyter(コード、入出力結果)
TryQueries.ipynb
import data_utils
data = data_utils.get_swim_sessions()
data
[('2025-08-25 05:33:42',),
('2025-08-29 04:58:20',),
('2025-08-29 05:01:10',),
('2025-08-29 05:01:33',)]
[d[0].split()[0] for d in data]
['2025-08-25', '2025-08-29', '2025-08-29', '2025-08-29']
data = data_utils.get_session_swimmers('2023-01-20')
data = [('Abi', 10), ('Blake', 15)]
[f'{name}-{age}' for name, age in data]
['Abi-10', 'Blake-15']
data = [('50m', 'Back'), ('50m', 'Free')]
[f'{distance}-{stroke}' for distance, stroke in data]
['50m-Back', '50m-Free']
data = [('39.42',),('36.13',)]
[t[0] for t in data]
['39.42', '36.13']