Convert first 2 letters of all records to Uppercase in python

Question

I have a dataframe DF with just 1 column and I want to uppercase first 2 letters of all the records in python. how do I do that ?

I want to capitalize first 2 letters of all records in the 'Name' Column of my Dataframe df — Yuvraj Singh, Nov 19 '19 at 06:26
Please post sample of your dataframe (something like `print(df.head())`), desired output and snippet of your source code that you tried — Chris, Nov 19 '19 at 06:30
save all of your record into list and then use like below: `[x[0:2].upper() + x[2::] for x in your_list]` — Yeganeh Salami, Nov 19 '19 at 06:39

score 1 · Accepted Answer · answered Nov 19 '19 at 06:41

1

You may use map and Convert you data as you required:

try below:

import pandas as pd 
df = pd.DataFrame({'name':['geeks', 'gor', 'geeks', 'is','portal', 'for','geeks']})
df['name']=df['name'].map(lambda x: x[:2].upper()+x[2:])
print (df)

output:

     name
0   GEeks
1     GOr
2   GEeks
3      IS
4  POrtal
5     FOr
6   GEeks

demo

answered Nov 19 '19 at 06:41

Divyesh patel

967
1
6
21

Thank you @FrustratedDeveloper for the help – Yuvraj Singh Nov 19 '19 at 06:51

score 0 · Answer 2 · answered Nov 19 '19 at 06:44

0

If you want to implement what Yeganeh suggested in the comments,

list = []
for items in df['Name']:
    list.append(items)
newlist = ([x[0:2].upper() + x[2::] for x in list])
print(df.replace(list,newlist))

Replace the previous list with the new one.

answered Nov 19 '19 at 06:44

Sin Han Jinn

574
3
18

Convert first 2 letters of all records to Uppercase in python

2 Answers2