Tasks:

  1. Add to each client an entry about the city in which he lives (rondomne place among the regional centers of Ukraine),

the column with the city should be after the mail. Write the result to the client file.csv

  1. based on the resulting file count:
  • how many people from the list live in each city

  • find the longest first and longest last name

  • change in all emails ending in. ru ->. ua

  • count the number of posts ending in. com

(write each information to a separate file)

  1. in the last file that I attached:
  • find the most popular artist

  • calculate the total duration of all songs

  • for each album, count how many songs are in it

  • for each album, write down a list of songs that it consists of