← 返回题库
初级

查询电影评分和年份

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

示例

输入
print(solve())
期望输出
[('The Shawshank Redemption', 9.3, 1994), ('The Godfather', 9.2, 1972), ('The Dark Knight', 9.0, 2008), ('Pulp Fiction', 8.9, 1994), ('Forrest Gump', 8.8, 1994), ('Inception', 8.8, 2010), ('The Matrix', 8.7, 1999), ('Interstellar', 8.6, 2014), ('The Prestige', 8.5, 2006), ('Gladiator', 8.5, 2000), ('The Departed', 8.5, 2006), ('Fight Club', 8.8, 1999), ('The Silence of the Lambs', 8.6, 1991), ('Se7en', 8.6, 1995), ('The Green Mile', 8.6, 1999)]
Python 代码 🔒 登录后使用
🔒

登录后即可练习

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

登录 免费注册