擅长:python、mysql、java
<p>将<code>names</code>转换为类别并获取类别代码;)</p>
<pre class="lang-py prettyprint-override"><code>import pandas as pd
dataf = pd.DataFrame(
[('Bob', 2),
('John', 1),
('Bek', 10),
('Bob', 6)], columns=['name','valuex'])
dataf["name"] = dataf["name"].astype("category").cat.codes.map(lambda x: f"Person {x}")
print(dataf)
</code></pre>
<h3>输出</h3>
<pre class="lang-sh prettyprint-override"><code> name valuex
0 Person 1 2
1 Person 2 1
2 Person 0 10
3 Person 1 6
</code></pre>
<h2>更新:</h2>
<pre class="lang-py prettyprint-override"><code>…
dataf["Person_info"] = [info for info in dataf.itertuples(index=False, name=None)]
</code></pre>
<h2>输出:</h2>
<pre class="lang-sh prettyprint-override"><code>
name valuex Person_info
0 Person 1 2 (Person 1, 2)
1 Person 2 1 (Person 2, 1)
2 Person 0 10 (Person 0, 10)
3 Person 1 6 (Person 1, 6)
</code></pre>