How do I get the latitude and longitude information contained csv file?
If what you have are places names and you want to get its coordinates, you can use some library, for example, geopandas. It has the geocoding feature, which converts place names to locations on Earth.

You can also use the Google maps Geocoding API.

There are many more API services which solve this problem, but those two should get you started. 

Hope this helps!