#3, Python will do it's thing, you might need to convert it to a numeric type because it'll assume it's a string given that it's being pulled out of a string. At least at a guess.

This post will show you how to open CSV files in Python using the CSV module. You'll also learn another method + how to write CSV files!