我目前有一个Datafame,它看起来像这样:
Account1 | Account2 | 姓名姓氏||
---|---|---|---|
150 | 18 | 彼得·||
130 | 1200 | 汉斯 | 齐默|
150 | 18 | Franz | Joseph |
106 | 1200 | 乔 | 特朗普|
150 | 18 | 克里斯托夫 | 沃尔兹|
170 | 1200 | Anne | Will |
150 | <td+138>>Lucenci | Hart||
1056 | 1200 | 定义 | Iano
正如我所评论的:
In [80]: Account1 = df['Account1']
...: Account2 = df['Account2']
...: m = 1
...: a = -Account2 - m * Account1
...: b = -Account2 * Account1 + (Account1 ** 2) * m
...: solution = b/a
...: df["m_solution"] = solution
In [81]: df
Out[81]:
Account1 Account2 m_solution
0 150 18 -117.857143
1 130 1200 104.586466
2 150 18 -117.857143
3 106 1200 88.793262
4 150 18 -117.857143
5 170 1200 127.810219
6 150 138 -6.250000
7 1056 1200 67.404255