How to remove common letters from elements of same column
Cust_id = customer['Cust_id']
l = [x[5:] for x in Cust_id]
customer['Cust_id'] = l
customer
The given data frame 'customer' has a column 'Cust_id' which has values Cust_1, Cust_2 and so on.
Remove the repeated 'Cust_' from the column Cust_id so that the output column Cust_id have just numbers like 1, 2, 3 and so on.
e.g. Column Heading is "Customer Info"
CUSTOMET INFO
Cust_1
Cust_2
Cust_3
*
*
*
*
Cust_100
Desired Output is:
CUSTOMET INFO
1
2
3
4
*
*
*
*
100