如何从Pandas中的列中增加元素值

Question

你好，我有这个Pandas代码(见下文(，但它给了我这个错误：TypeError: can only concatenate str (not "int") to str

import pandas as pd
import numpy as np
import os
_data0 = pd.read_excel("C:\Users\HP\Documents\DataScience task\Gender_Age.xlsx")
_data0['Age' + 1]

我想更改"年龄"列中的元素值，想象一下，如果我想将"年龄"中的列元素增加1，我该怎么做？(还有儿童数量(

我想要的输出：

First Name  Last Name      Age      Number of Children
0   Kimberly    Watson          36                 2
1   Victor      Wilson          35                 6
2   Adrian      Elliott         35                 2
3   Richard     Bailey          36                 5
4   Blake       Roberts         35                 6

原始输出：

First Name  Last Name      Age      Number of Children
0   Kimberly    Watson          24                 1
1   Victor      Wilson          23                 5
2   Adrian      Elliott         23                 1
3   Richard     Bailey          24                 4
4   Blake       Roberts         23                 5

Answer 1

尝试：

df['Age'] = df['Age'] - 12
df['Number of Children'] = df['Number of Children'] - 1