import pandas as pd
import numpy as np
import matplotlib.pyplot as plt



df = pd.read_excel('links.xls')
data = df.to_numpy()

data_array = data

start_lon = data_array[:,0]
start_lat = data_array[:,1]
end_lon = data_array[:,2]
end_lat = data_array[:,3]

fig, ax = plt.subplots(figsize=(10,8))

# ax.scatter(start_lon, start_lat, color='blue', marker='o', label='起点')
ax.scatter(end_lon, end_lat, color='red', marker='o', label='终点')

plt.legend(loc='upper right')
plt.xlabel('经度')
plt.ylabel('维度')
plt.show()