擅长:python、mysql、java
<p>使用pyexcel,这项工作也可以轻松完成:</p>
<pre><code>>>> import pyexcel as pe
>>> sheet = pe.load("xxxxx.csv")
>>> sheet.format(float)
>>> sheet.name_columns_by_row(0)
>>> lat = sheet.column["Lat"]
>>> lon = sheet.column["Lon"]
....# more processing here
</code></pre>