擅长:python、mysql、java
<p>您不需要插入<code>Payment Date</code>列,因为它已经在dataframe的索引中</p>
<p>如果要将其转换为列,请使用<code>paymentDate.reset_index()</code>而不是<code>insert</code>:</p>
<pre><code>#find the mean
paymentDate = data_2015['paymentDate']
mean_paymentAmount= data_2015.groupby('paymentDate')['paymentAmount'].mean()
mean_loanAmount= data_2015.groupby('paymentDate')['loanAmount'].mean()
df = mean_loanAmount.to_frame()
df_payment = mean_paymentAmount.to_frame()
#transform into dataframe
df.columns = ["Loan Amount"]
df.insert(1, "Payment Amount", df_payment, True)
df.reset_index(inplace=True)
df
</code></pre>