File Handling Operation in Python

The file is a collection of records, if we want to store program output permanently under a computer harddisk then we can use file handling operation.
File handling provide multiple operations on a file
Python Provide a predefined method to manage file handling operation.
1 open():-  using this method we can open the file for operation, if the file not exist then it will create the file.
  f = open("filename",mode)    # w for write ,r for read ,w+ for write|read,r+ for read|write,a for append, a+ append and read
2 write():-  this method is used to write content into a file.
f.write(data)
code for write
f = open("student.txt","w")
f.write("student information")
f.close()
3 read()

code for read

f = open("student.txt","r")
s=f.read()
print(s)
f.close()

  s = f.read()

  print(s)
..................................................................................................................
4 append file:-
code for append

f = open("student.txt","a")
s = input("write content")
f.write(s)
f.close()

,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,

Create Expenses System using File Handling Program:-

import time

f = open("expenses.txt","w")

expenseby = input("Enter expense by")

grocerry = input("Enter grocerry details")

milk = input("Enter milk expenses")

rent = input("Enter rent expenses")

date = time.asctime(time.localtime(time.time()))

f.write("Today Expenses Details")

f.write("\n")

f.write("Grocerry:"+grocerry)

f.write("\n")

f.write("Milk:" +milk)

f.write("\n")

f.write("Rent:" +rent)

f.write("\n")

f.write("Date:" + date)

f.close()

Expenses System program to append mode:-

import time

f = open("expenses.txt","a")

expenseby = input("Enter expense by")

grocerry = input("Enter grocerry details")

milk = input("Enter milk expenses")

rent = input("Enter rent expenses")

date = time.asctime(time.localtime(time.time()))

f.write("-------------*------------")

f.write("Today Expenses Details by "+expenseby)

f.write("\n")

f.write("Grocerry:"+grocerry)

f.write("\n")

f.write("Milk:" +milk)

f.write("\n")

f.write("Rent:" +rent)

f.write("\n")

f.write("Date:" + date)

f.write("-------------*------------")

f.close()

Expenses System Write and Read using Single File?

import time

f = open("expenses.txt","w+")

expenseby = input("Enter expense by")

grocerry = input("Enter grocerry details")

milk = input("Enter milk expenses")

rent = input("Enter rent expenses")

date = time.asctime(time.localtime(time.time()))

f.write("-------------*------------")

f.write("Today Expenses Details by "+expenseby)

f.write("\n")

f.write("Grocerry:"+grocerry)

f.write("\n")

f.write("Milk:" +milk)

f.write("\n")

f.write("Rent:" +rent)

f.write("\n")

f.write("Date:" + date)

f.write("-------------*------------")

f.seek(0)

s = f.read()

print(s)

f.close()

Expenses System Example With Append Mode:-

import time

f = open("expenses.txt","a+")

expenseby = input("Enter expense by")

grocerry = input("Enter grocerry details")

milk = input("Enter milk expenses")

rent = input("Enter rent expenses")

date = time.asctime(time.localtime(time.time()))

f.write("-------------*------------")

f.write("Today Expenses Details by "+expenseby)

f.write("\n")

f.write("Grocerry:"+grocerry)

f.write("\n")

f.write("Milk:" +milk)

f.write("\n")

f.write("Rent:" +rent)

f.write("\n")

f.write("Date:" + date)

f.write("-------------*------------")

f.seek(0)

s = f.read()

print(s)

f.close()

Program of file handling using class and object:-

class FileOperation:
    def createFile(self):
       self.f = open("info.txt","a+")
    def writeFile(self):
      title = input("Enter title")
      self.f.write("\n"+title)
      desc = input("Write content")
      self.f.write("\n"+desc)
    def readFile(self):
      self.f.seek(0)  #it will reset cursor position to any index
      res = self.f.read()
      print(res)
      self.f.close()
obj = FileOperation()
obj.createFile()
obj.writeFile()
obj.readFile()

Program to create a resume using file handling?

f = open("resume1.doc","w+")

f.write("Objective")

f.write("\n I am seeking job and i will work with full honesty and learn new skills")

f.write("\n Qualification")

f.write("\n I have completed BTECH from IPS college Indore")

f.write("\n Academic Qualification")

f.write("\n 10th 80% \n 12th 90% ")

f.close()

Program to calculate SI using P, R, and T?

p = float(input("enter amount"))

r = float(input("enter rate"))

t = float(input("enter time"))

si = (p*r*t)/100

f = open("sicalc.txt","w")

f.write("Amount is "+str(p)+ "\n Rate is "+str(r)+ "\n Time is "+str(t))

f.write("Result is "+str(si))

f.close()

Program to calculate Simple Interest using Write and Read Mode?

p = float(input("enter amount"))

r = float(input("enter rate"))

t = float(input("enter time"))

si = (p*r*t)/100

f = open("sicalc.txt","w+")

f.write("Amount is "+str(p)+ "\n Rate is "+str(r)+ "\n Time is "+str(t))

f.write("Result is "+str(si))

f.seek(0)

data = f.read()

print(data)

f.close()

Program to calculate Simple Interest using Append and Read Mode?

p = float(input("enter amount"))

r = float(input("enter rate"))

t = float(input("enter time"))

si = (p*r*t)/100

f = open("sicalc.txt","a+")

f.write("Amount is "+str(p)+ "\n Rate is "+str(r)+ "\n Time is "+str(t))

f.write("Result is "+str(si))

f.seek(0)

data = f.read()

print(data)

f.close()

Assignment:-

1)  WAP to perform the addition of two numbers and write the output of addition under file?

2)  WAP to create complete biodata for a marriage proposal?

3)  WAP to create horoscope software?

Create Expenses System.

import time

f = open("expenses.txt","a+")

expenseby = input("Enter expense by")

grocerry = input("Enter grocerry details")

milk = input("Enter milk expenses")

rent = input("Enter rent expenses")

date = time.asctime(time.localtime(time.time()))

f.write("\n Today Expenses Details")

f.write("\n")

f.write("Name:"+expenseby)

f.write("\n")

f.write("Grocerry:"+grocerry)

f.write("\n")

f.write("Milk:" +milk)

f.write("\n")

f.write("Rent:" +rent)

f.write("\n")

f.write("Date:" + date)

f.seek(0)

data = f.readlines()

s=0

for d in data:

    if d[0]=='G' or d[0]=='R' or d[0] == 'M':

       s = s + int(d[d.find(':')+1:])

print("Total Expenses is ",s)

f.close()

What is Data Processing?

It is used to process the data of an external drive under an application using multiple file formats.

Python provides multiple modules to read data from excel, CSV, word, pdf, image, and video files.

1)  Read and write data from excel file using XLRD MODULE

Python provide xlrd modue.

pip install xlrd 

.xsl,  .xslx

Code to read data from excel file

import xlrd

f = xlrd.open_workbook("d://book1.xls")

sheet = f.sheet_by_index(0)

#s = sheet.cell_value(0,0)

#print(s)

r = sheet.nrows

c = sheet.ncols

print("row",r,"col",c)

for i in range(0,r):

    for j in range(0,c):

        print(sheet.cell_value(i,j),end=' ')

    print()    

How to write data on excel file:-

import xlwt

from xlwt import Workbook

  # Workbook is created

wb = Workbook()

# add_sheet is used to create sheet.

sheet1 = wb.add_sheet('sheet1')

nrow=3

ncol=2

for i in range(0,nrow):

    for j in range(0,ncol):

        sheet1.write(i, j, input("Enter data for cell {0}{1}".format(i,j)))

wb.save('d://book3.xls')

2)  READ DATA In FILE using openpyxl module

import openpyxl

dataframe = openpyxl.load_workbook("d://book1.xlsx")

dataframe1 = dataframe.active

print(dataframe1.max_row)

print(dataframe1.max_column)

for row in range(0, dataframe1.max_row):

    for col in dataframe1.iter_cols(1, dataframe1.max_column):

        print(col[row].value,end=' ')

    

    print()

.............................................................................................................................................................

.............................................................................................................................................................

Write Data on Excel File?

# import openpyxl module 

import openpyxl 

wb = openpyxl.Workbook() 

sheet = wb.active 

c1 = sheet.cell(row = 1, column = 1) 

c1.value = "ANKIT"

c2 = sheet.cell(row= 1 , column = 2) 

c2.value = "RAI" 

c3 = sheet['A2'] 

c3.value = "RAHUL"

c4 = sheet['B2'] 

c4.value = "RAI"

wb.save("d://demo123.xlsx") 

...............................................................................................................................

Write Multiple Data on Exel file:-

# import openpyxl module 

import openpyxl 

wb = openpyxl.Workbook() 

sheet = wb.active

nrow=int(input("Enter row"))

ncol=int(input("Enter col"))

for i in range(1,nrow+1):

    for j in range(1,ncol+1):

        c1 = sheet.cell(row = i, column = j) 

        c1.value = input("Enter data for row "+str(i) + "col " + str(j))

wb.save("d://demo123.xlsx")