擅长:python、mysql、java
<p>您可以这样做:</p>
<pre><code> import pandas as pd
#Reading your data
#data -> Pandas dataframe
data = pd.read_excel('yourFile.xlsx')
# Gets the column info
lat = data['lat']
lon = data['lon']
#Process it
result = []
for i in range(len(lat)):
#Adding to result based on indexes
result.append((lat[i], lon[i]))
print result
</code></pre>
<p>我试着用一种容易理解的方式写它(:</p>