Final Assignment Project最终作业项目

This lab is your final project for the course. You will be asked to take screenshots at each step and save these locally for uploading as your submission.

mongosh -u root -p "[已隐藏]" --authenticationDatabase admin local --host mongo

db.movies.aggregate([
    { 
        "$match": { "year": 2007 }  // Filter movies released in 2007
    },
    {
        "$group": {
            "_id": "$year",  // Group by the year (2007 in this case)
            "averageVotes": { "$avg": "$Votes" }  // Calculate the average votes
        }
    }
])

mongoexport -u root -p "[已隐藏]" --authenticationDatabase admin -d entertainment -c movies -f "_id, title, year, rating, director" --type=csv -o partial_data.csv --host mongo

USE entertainment;

CREATE TABLE movies (
    id text PRIMARY KEY,
    title text,
    year text,
    rating text,
    director text
);

COPY entertainment.movies (id, title, year, rating, director) 
FROM '/home/project/partial_data.csv' 
WITH DELIMITER=',' AND HEADER=TRUE;

📄 Final Assignment- Data Engineering for a Consulting Firm.pdf

📎 获取Cloudant URL_2025-10-17 14_18_59-f9f81058-bac4-4b1a-babe-0d55523ec7f6.md