Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- import csv
- names = []
- emails = []
- phoneNumbers = []
- year = []
- department = []
- teamInterested = []
- with open("data.csv", "r") as file:
- row = csv.DictReader(file)
- for line in row:
- names.append(line["name"])
- emails.append(line["email"])
- phoneNumbers.append(line["phoneNumber"])
- year.append(line["year"])
- department.append(line["department"])
- teamInterested.append(line["teamInterested"])
- roles = ["technical", "designing", "media", "management"]
- technical = []
- designing = []
- media = []
- management = []
- for i in range(len(names)):
- if "Technical" in teamInterested[i]:
- technical.append(i)
- if "Designing" in teamInterested[i]:
- designing.append(i)
- if "Media" in teamInterested[i]:
- media.append(i)
- if "Management" in teamInterested[i]:
- management.append(i)
- for i in technical:
- row = []
- row.append(names[i])
- row.append(emails[i])
- row.append(phoneNumbers[i])
- row.append(year[i])
- row.append(department[i])
- with open("technical.csv", "a") as data:
- writer = csv.writer(data)
- writer.writerow(row)
- for i in designing:
- row = []
- row.append(names[i])
- row.append(emails[i])
- row.append(phoneNumbers[i])
- row.append(year[i])
- row.append(department[i])
- with open("designing.csv", "a") as data:
- writer = csv.writer(data)
- writer.writerow(row)
- for i in media:
- row = []
- row.append(names[i])
- row.append(emails[i])
- row.append(phoneNumbers[i])
- row.append(year[i])
- row.append(department[i])
- with open("media.csv", "a") as data:
- writer = csv.writer(data)
- writer.writerow(row)
- for i in management:
- row = []
- row.append(names[i])
- row.append(emails[i])
- row.append(phoneNumbers[i])
- row.append(year[i])
- row.append(department[i])
- with open("management.csv", "a") as data:
- writer = csv.writer(data)
- writer.writerow(row)
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement