擅长:python、mysql、java
<p>大多数情况下,使用panda时,最好使用其build-it方法修改阵列:</p>
<pre><code>import pandas as pd
my_dict = {'city': ['Cherbourg', 'Calais', 'Nevers'], 'name_mayor': ['Robert', 'Michel', 'Guy'],
'age_mayor': [10, 20, 30], 'name_baker': ['Jack', 'Russel', None], 'age_baker': [40, 50, None]}
my_data_frame = pd.DataFrame(my_dict)
new_data_frame = pd.DataFrame({'city': my_data_frame['city'].append(my_data_frame['city']), 'name': my_data_frame['name_mayor'].append(
my_data_frame['name_baker']), 'age': my_data_frame['age_mayor'].append(my_data_frame['age_baker'])})
new_data_frame.dropna(inplace=True)
print(new_data_frame)
</code></pre>
<p>输出:</p>
<pre><code> city name age
0 Cherbourg Robert 10.0
1 Calais Michel 20.0
2 Nevers Guy 30.0
0 Cherbourg Jack 40.0
1 Calais Russel 50.0
</code></pre>