Question

The file Cities.txt contains information about the 25 largest cities in the United States. Each line of the file has four fields—name, state, population in 2000 (in 100,000s), and population in 2010 (in 100,000s). Write a python program that creates a new file with each line containing the name of a city and its percentage population growth from 2000 to 2010. The cities should be in decreasing order by their percent population growth.

The first four lines of the file Cities.txt are as follows:

New York,NY,80.1,82.7

Los Angeles,CA,36.9,38.84

Chicago,IL,29.0,28.7

Houston,TX,19.5,22.4

Answer 1

ANSWER :

Code :-

fname = "/home/sasi/Desktop/pro/Python/cities.txt" #absolute path of file
fout = "/home/sasi/Desktop/pro/Python/cities_out.txt"   
listt = [] #empty list
with open(fname) as f: #opening file
lines = [line.rstrip('\n').split(',') for line in f] #splitting the file by ,
for i in range (0, len(lines)): #run till the end of file line by line
increase = float(lines[i][3]) - float(lines[i][2]) #taking the difference between 4th column and 3rd column
increase = increase / float(lines[i][2]) * 100 #calculating the percentage
listt.append("%.2f,%s,%s" % (float(increase), lines[i][0], lines[i][1])) #appending into list

listt.sort(reverse=True) #list sort in descending order
for line in listt:
y = line.strip().split(",")
with open(fout,"a") as text_file:
text_file.write("%s, %s, %.2f\n" % (y[1],y[2], float(y[0])))
text_file.close()

CODE SCREENSHOT :-

OUTPUT SCREENSHOT :-

PLEASE LEAVE A THUMBS UP IF THIS ANSWER HELPS YOU.

THANK YOU:)