troubleshooting Question

Extract substring from dataframe and add it to new column.

Avatar of Newton
Newton asked on
Python
3 Comments1 Solution113 ViewsLast Modified:
How to extract a substring from column and add it back as new column.

For example, I have file1 with 2 column. I want extract first 3 character from fullname column and then I need to add it as new column.

File1
FullName|count
APPLE|100
ORANG|200
GRAPES|300

I need below output
Output1
FullName|ShortName|count
APPLE |APP|100
ORANGE |ORA|200
GRAPES|GRA|300

Is below is correct way of doing this.
Script
df = pd.read_csv('File1', sep='|')
df['ShortName'] = df['FullName'].str.slice[0:3]
df.out_csv('output1')
ASKER CERTIFIED SOLUTION
Join our community to see this answer!
Unlock 1 Answer and 3 Comments.
Start Free Trial
Learn from the best

Network and collaborate with thousands of CTOs, CISOs, and IT Pros rooting for you and your success.

Andrew Hancock - VMware vExpert
See if this solution works for you by signing up for a 7 day free trial.
Unlock 1 Answer and 3 Comments.
Try for 7 days

”The time we save is the biggest benefit of E-E to our team. What could take multiple guys 2 hours or more each to find is accessed in around 15 minutes on Experts Exchange.

-Mike Kapnisakis, Warner Bros