datacode/retype.py at master · scanfyu/datacode · GitHub

39 lines (28 loc) · 1.33 KB

import unicodecsv

def read_csv(filename):

with open(filename, 'rb') as f:

reader = unicodecsv.DictReader(f)

return list(reader)

enrollments = read_csv('F:\\data\\DAND\\csv\\enrollments.csv')

daily_engagement = read_csv('F:\\data\\DAND\\csv\\daily_engagement.csv')

project_submissions = read_csv('F:\\data\\DAND\\csv\\project_submissions.csv')

print (enrollments[0])

print (daily_engagement[0])

print (project_submissions[0])

### For each of these three tables, find the number of rows in the table and

### the number of unique students in the table. To find the number of unique

### students, you might want to create a set of the account keys in each table.

def account_num(files):

num = set()

for file in files:

num.add(file['account_key'])

return len(num)

enrollment_num_rows = len(enrollments) # Replace this with your code

enrollment_num_unique_students = set() # Replace this with your code

for enrollment in enrollments:

enrollment_num_unique_students.add(enrollment['account_key'])

len(enrollment_num_unique_students)

engagement_num_rows = 0 # Replace this with your code

engagement_num_unique_students = 0 # Replace this with your code

submission_num_rows = 0 # Replace this with your code

submission_num_unique_students = 0 # Replace this with your code

Expand file tree