Python Forum
Thread Rating:
  • 1 Vote(s) - 2 Average
  • 1
  • 2
  • 3
  • 4
  • 5
How to split string
#4
(Jun-11-2018, 11:50 AM)SriRajesh Wrote: I encounetr errr:
NameError Traceback (most recent call last)
<ipython-input-4-e50857fb9961> in <module>()
3 df2 = pd.DataFramedf = pd.DataFrame({'ids': ['AA-120amp', 'BA+250A-52amp', 'AA-5623amp','CD']})
4 df2 = df2.merge(df2['ids'].str.extractall(r'(?P<df2>[^-]+)-(?P<allele>(?P<rank>\d+).+)')
----> 5 .set_index(res.index.droplevel(1)),'inner', left_index=True, right_index=True)
6

NameError: name 'res' is not defined

OK, sorry - wrong merge of code. 3 strings
df2 = pd.DataFramedf = pd.DataFrame({'ids': ['AA-120amp', 'BA+250A-52amp', 'AA-5623amp','CD']})
extracted = df2['ids'].str.extractall(r'(?P<df2>[^-]+)-(?P<allele>(?P<rank>\d+).+)')
df2 = df2.merge(extracted.set_index(extracted.index.droplevel(1)), 
                'inner', left_index=True, right_index=True)
The result is
Output:
ids df2 allele rank 0 AA-120amp AA 120amp 120 1 BA+250A-52amp BA+250A 52amp 52 2 AA-5623amp AA 5623amp 5623
Test everything in a Python shell (iPython, Azure Notebook, etc.)
  • Someone gave you an advice you liked? Test it - maybe the advice was actually bad.
  • Someone gave you an advice you think is bad? Test it before arguing - maybe it was good.
  • You posted a claim that something you did not test works? Be prepared to eat your hat.
Reply


Messages In This Thread
How to split string - by SriRajesh - Jun-04-2018, 04:33 PM
RE: How to split string - by volcano63 - Jun-04-2018, 08:02 PM
RE: How to split string - by SriRajesh - Jun-11-2018, 11:50 AM
RE: How to split string - by volcano63 - Jun-11-2018, 12:33 PM
RE: How to split string - by SriRajesh - Jun-11-2018, 01:00 PM
RE: How to split string - by volcano63 - Jun-11-2018, 02:29 PM

Possibly Related Threads…
Thread Author Replies Views Last Post
  Split string hext01 3 3,021 Aug-16-2018, 09:51 AM
Last Post: hext01

Forum Jump:

User Panel Messages

Announcements
Announcement #1 8/1/2020
Announcement #2 8/2/2020
Announcement #3 8/6/2020