How to short dataframe data's names

Asked Jan 12 '21 at 17:21

Active Jan 12 '21 at 18:23

Viewed 120 times

I have dataFrame which first index is A, like this:

A

"ABCDEF"

"BNDLSSL:SHKSJD:SKLAAS:ASSDAS"

"SSMDLL"

"KSDKDL:AHSMSD:MSSML"

"NSMSDKKD"

"SMDDLDW"

"NSNSJDJSK:SMSKKSS"

I want to remove ":" expression , just it must write until ":"

for example i want to this output:

  A

"ABCDEF"

"BNDLSSL"

"SSMDLL"

"KSDKDL"

"NSMSDKKD"

"SMDDLDW"

"NSNSJDJSK"

I wrote this code but it works just one index, I want to all of dataFrame(df)

df.iloc[1,0].split(":")[0]

edited Jan 12 '21 at 17:23

Umar.H

asked Jan 12 '21 at 17:21

maxwell

2

`df.A.str.split(':').str[0]` – Chris Jan 12 '21 at 17:24
ditch the `iloc` and use the `expand=True` argument `df['A'].str.split(':',expand=True)[0]` – Umar.H Jan 12 '21 at 17:24

0 Answers0