在第四个索引中为每个字符串添加一个点

Question

我想给dataframe中的每个字符串添加一个点，例如49454170变成4945.4170

下框：

       Missed Trades
0        49454170
1        49532878
2        49511387
3        49451350
4        49402211
5        49403961
6        49331707
7        49320696

Answer 1

像这样的东西可能有用-

df['Missed Trades'] = df['Missed Trades'].astype(int) / 10000

Answer 2

下面是一种使用^{}并将结果列表与^{}连接起来的方法：

df['Missed Trades'].str.findall(r'(\d{4})').str.join('.')

0    4945.4170
1    4953.2878
2    4951.1387
3    4945.1350
4    4940.2211
5    4940.3961
6    4933.1707
7    4932.0696
Name: MissedTrades, dtype: object

Answer 3

df['Missed Trades'] = df['Missed Trades'].map(lambda x : x[0:4]+'.'+x[4:8])

       Missed Trades
0        4945.4170
1        4953.2878
2        4951.1387
3        4945.1350
4        4940.2211
5        4940.3961
6        4933.1707
7        4932.0696