想要给以下表格的每个数字都加上1
from datetime import datetime
import pandas as pd
import numpy as np
import math
df = pd.read_csv(r'C:\Users\Administrator\Desktop\1.csv')
print(df, type(df))
x = df.iloc[:3]['A']
print(x, type(x))
print(np.array(list(x))+1)
出现以下错误提示,尝试用各种方法将字符转为数字,但均未成功,该如何解决?
下有代码,可直接复制使用。如有帮助,敬请采纳,你的采纳是我前进的动力,O(∩_∩)O谢谢!!!!!!!!
路过的朋友也可以点个赞~(≧▽≦)/~
import pandas as pd
import numpy as np
df = pd.read_csv(r'C:\Users\Administrator\Desktop\1.csv')
print(df, type(df))
x = df.iloc[:3]['A']
print(x, type(x))
x = ''.join(x.tolist()).replace('][', ',').replace(']', '').replace('[', '')
x_np = np.fromstring(x, dtype=float, sep=',').reshape(-1, 2)
print(x_np + 1)
可以尝试先把立面的数据提取出来,在python里面变成数字再加一,然后储存回csv
def a(row):
for i in range(len(row)):
row[i] = int(row[i])
return row
df['A'] = df['A'].apply(a)