Roll Number CN CS358 Duplicate Remaining

# -*- coding: utf-8 -*-
"""
Created on Tue Aug 22 17:24:08 2023

@author: Sanjit
"""

import pandas as pd

f = open('rolls.txt','r')
lines = [line.strip() for line in f.readlines()]

df = pd.read_csv('CS359 2023 Batch 2 (Responses).csv')

studDF = df['Proj Partner 1'].append(df['Proj Partner 2'], ignore_index=False)

numApper = studDF.value_counts()
extraApper = numApper[numApper>1]
extraApper.to_csv('multiple_appear_student.csv')

misList = [line for line in lines if line not in studDF.values]

misDF = pd.DataFrame(misList)
misDF.to_csv('list_of_stud_not_fill_yet.csv', index=False)
with open("list_of_stud_not_fill_yet.txt","w") as f:
    f.writelines([row+'\n' for row in misList])