Programming File Handling (Edexcel GCSE Computer Science): Revision Note

Open

file = open("fruit.txt","r")

Close

file.close()

Read line

file.readline()

Write line

file.write("Oranges")

End of file

endOfFile = False

Create a new file

file = open("shopping.txt","w")

Append a file

file = open("shopping.txt","a")

Open

• Opens the file in memory to be used in the program

Close

• Closes the file

• This must be done to store any content that has been written or appended to it

Read

• Opens the file in read-only mode

• The contents can be read but not changed

Write

• Opens the file in write mode

• The contents of the file will be over-written

• No prior content in the file will be saved

Append a file

• Opens the file in append mode

• New data will be added to the end of the file

• Previous data in the file will remain

file = open("employees.txt", "r") # open file in read mode
endOfFile = False # set end of file to false
while not endOfFile: # while not end of file
  name = file.readline() # read line 1
  department = file.readline() # read line 2
  salary = file.readline() # read line 3
  age = file.readline() # read line 4

  print("Name: ", name) # print name
  print("Department: ", department) # print department
  print("Salaray: ", salary) # print salary
  print("age: ", age) # print age
  
  if name == "": # if name is empty
    endOfFile = True # set end of file to true

file.close() # close file

Greg
Sales
39000
43
Lucy
Human resources
26750
28
Jordan
Payroll
45000
31

import csv

# Open the CSV file

with open('employees.csv', 'r') as csv_file:

csv_reader = csv.reader(csv_file)

# Iterate over each row in the CSV file

for row in csv_reader:

print(row)

Greg, Sales, 39000, 43
Lucy, Human resources, 26750, 28
Jordan, Payroll, 45000, 31

file = open("employees.txt", "a") # open file in append mode
file.write("Polly\n") # write line (\n for new line)
file.write("Sales\n")
file.write("26000\n")
file.write("32\n")

file.close() # close file

Greg
Sales
39000
43
Lucy
Human resources
26750
28
Jordan
Payroll
45000
31
Polly
Sales
26000
32

import csv

# Sample data to write to CSV

employees_data = [

['John', 'Sales', 50000, 30], ['Jane', 'Marketing', 60000, 35], ['Alice', 'Engineering', 70000, 40]

]

# Write data to CSV file

with open('employees.csv', 'w', newline='') as csv_file:

csv_writer = csv.writer(csv_file)

csv_writer.writerows(employees_data)

print("Data has been written to employees.csv")

John, Sales, 50000, 30,

Jane, Marketing, 60000, 35

Alice, Engineering, 70000, 40