- Data Structure
- Networking
- RDBMS
- Operating System
- Java
- MS Excel
- iOS
- HTML
- CSS
- Android
- Python
- C Programming
- C++
- C#
- MongoDB
- MySQL
- Javascript
- PHP
- Physics
- Chemistry
- Biology
- Mathematics
- English
- Economics
- Psychology
- Social Studies
- Fashion Studies
- Legal Studies
- Selected Reading
- UPSC IAS Exams Notes
- Developer's Best Practices
- Questions and Answers
- Effective Resume Writing
- HR Interview Questions
- Computer Glossary
- Who is Who
Write a Python program to separate a series of alphabets and digits and convert them to a dataframe
Assume you have a series and the result for separating alphabets and digits and store it in dataframe as,
series is: 0 abx123 1 bcd25 2 cxy30 dtype: object Dataframe is 0 1 0 abx 123 1 bcd 25 2 cxy 30
To solve this, we will follow the below approach,
Solution
Define a series.
Apple series extract method inside use regular expression pattern to separate alphabets and digits then store it in a dataframe −
series.str.extract(r'(\w+[a-z])(\d+)')
Example
Let’s see the below implementation to get a better understanding −
import pandas as pd series = pd.Series(['abx123', 'bcd25', 'cxy30']) print("series is:\n",series) df = series.str.extract(r'(\w+[a-z])(\d+)') print("Dataframe is\n:" ,df)
Output
series is: 0 abx123 1 bcd25 2 cxy30 dtype: object Dataframe is : 0 1 0 abx 123 1 bcd 25 2 cxy 30
Advertisements