擅长:python、mysql、java
<p>很简单。引用字符串,删除列表中的额外级别</p>
<pre class="lang-py prettyprint-override"><code>import pandas as pd
input_data = [[12, 71.2989367, -156.7286143, 'Samuel Simmonds Memorial Hospital', 4],
[4, 64.8311569, -147.7399471, 'Fairbanks Memorial Hospital', 4],
[6, 64.4993412, -165.3776787, 'Norton Sound Regional Hospital', 4],
[5, 61.56316029999999, -149.2576383, 'Mat-Su Regional Medical Center', 4]]
df = pd.DataFrame(input_data,
columns=['ID', 'Lat', 'Long', 'Name', 'Level'])
</code></pre>
<p>结果:</p>
<pre class="lang-py prettyprint-override"><code> ID Lat Long Name Level
0 12 71.298937 -156.728614 Samuel Simmonds Memorial Hospital 4
1 4 64.831157 -147.739947 Fairbanks Memorial Hospital 4
2 6 64.499341 -165.377679 Norton Sound Regional Hospital 4
3 5 61.563160 -149.257638 Mat-Su Regional Medical Center 4
</code></pre>