Question

In Any Language write a function to loop through a csv file (10 rows no headers) and pull out the data from the 3rd column (string). Create one string with those values separated by commas in arranged in alphabetical order by the first letter (example: “Amazon, Aaron, Base, …..”, Amazon and Aaron do not need to be reversed). It can be assumed the csv file is already read into a variable. Please provide comments.

Answer 1

"""
  Python program to read CSV File and to print third column in sorted order
"""

fileName = "myfile.txt"

firstCol = []
secondCol = []
thirdCol = []
finalList = []

with open(fileName, 'r') as CSVFile:

  for row in CSVFile:
    row = row.strip('\n')
    temp = row.split(',')

    firstCol.append(temp[0])
    secondCol.append(temp[1])
    thirdCol.append(temp[2])

  thirdCol.sort()

  for i in range(len(thirdCol)):
    finalList.append(thirdCol[i])
  
  print(finalList)

# Program ends here