Question

A csv file "Happiness.csv" contains the data of a survey. Each record of the file contains the following data: 

• Name of a country
• Population of the country
• Sample Size (Number of persons who participated in the survey in that country)
• Happy (Number of persons who accepted that they were Happy)

For example, a sample record of the file may be: 
[‘Signiland’, 5673000, 5000, 3426]

Write the following Python functions to perform the specified operations on this file:

1. Read all the data from the file in the form of a list and display all those records for which the population is more than 5000000.
2. Count the number of records in the file.

Answer 1

1. def show():
       import csv
       f=open("happiness.csv",'r')
       records=csv.reader(f)
       next(records, None) #To skip the Header row
       for i in records:
         if int(i[1])>5000000:
           print(i)
       f.close()
   

2. def Count_records():
       import csv
       f=open("happiness.csv",'r')
       records=csv.reader(f)
       next(records, None) #To skip the Header row
       count=0
       for i in records:
            count+=1
       print(count)
       f.close()