← 返回题库
初级

查询泰坦尼克乘客信息

未完成
初级参考 完整示例代码供参考，建议自己理解后重新输入 
def solve():
    import sqlite3
    import pandas as pd
    conn = sqlite3.connect(':memory:')
    df = pd.read_csv('https://liangdaima.com/static/data/titanic.csv')
    df.to_sql('titanic', conn, index=False)
    result = conn.execute('SELECT * FROM titanic LIMIT 10').fetchall()
    conn.close()
    return result

示例

输入
print(solve())
期望输出
[(0, 3, 'male', 22.0, 1, 0, 7.25, 'S', 'Third', 'man', 1, None, 'Southampton', 'no', 0), (1, 1, 'female', 38.0, 1, 0, 71.2833, 'C', 'First', 'woman', 0, 'C', 'Cherbourg', 'yes', 0), (1, 3, 'female', 26.0, 0, 0, 7.925, 'S', 'Third', 'woman', 0, None, 'Southampton', 'yes', 1), (1, 1, 'female', 35.0, 1, 0, 53.1, 'S', 'First', 'woman', 0, 'C', 'Southampton', 'yes', 0), (0, 3, 'male', 35.0, 0, 0, 8.05, 'S', 'Third', 'man', 1, None, 'Southampton', 'no', 1), (0, 3, 'male', None, 0, 0, 8.4583, 'Q', 'Third', 'man', 1, None, 'Queenstown', 'no', 1), (0, 1, 'male', 54.0, 0, 0, 51.8625, 'S', 'First', 'man', 1, 'E', 'Southampton', 'no', 1), (0, 3, 'male', 2.0, 3, 1, 21.075, 'S', 'Third', 'child', 0, None, 'Southampton', 'no', 0), (1, 3, 'female', 27.0, 0, 2, 11.1333, 'S', 'Third', 'woman', 0, None, 'Southampton', 'yes', 0), (1, 2, 'female', 14.0, 1, 0, 30.0708, 'C', 'Second', 'child', 0, None, 'Cherbourg', 'yes', 0)]
Python 代码 🔒 登录后使用
🔒

登录后即可练习

注册免费账号，在浏览器中直接运行 Python 代码

登录 免费注册