import matplotlib.pyplot as plt
movies = [
    {"title": "Inception", "rating": 8.8},
    {"title": "Interstellar", "rating": 8.6},
    {"title": "The Dark Knight", "rating": 9.0},
    {"title": "Tenet", "rating": 7.5},
    {"title": "Dunkirk", "rating": 7.9}
]

# Create DataFrame
import pandas as pd
df = pd.DataFrame(movies)
df

# Average rating
df["rating"].mean()

np.float64(8.36)

# Bar plot
df.plot.bar(x="title", y="rating", legend=False, color="purple")
plt.title("Movie Ratings")
plt.ylim(0, 10)
plt.show()

# High rated
df[df["rating"] >= 8.5]

# Sort by rating
df.sort_values(by="rating", ascending=False)

# Add genre
df["genre"] = ["Sci-Fi", "Sci-Fi", "Action", "Thriller", "War"]
df