Pandas: Extract only number from the specified column of a given DataFrame
Write a Pandas program to extract only number from the specified column of a given DataFrame.
Sample Solution:
Python Code :
Sample Output:
Original DataFrame: company_code address 0 c0001 7277 Surrey Ave. 1 c0002 920 N. Bishop Ave. 2 c0003 9910 Golden Star St. 3 c0003 25 Dunbar St. 4 c0004 17 West Livingston Court \Extracting numbers from dataframe columns: company_code address number 0 c0001 7277 Surrey Ave. 7277 1 c0002 920 N. Bishop Ave. 920 2 c0003 9910 Golden Star St. 9910 3 c0003 25 Dunbar St. 25 4 c0004 17 West Livingston Court 17
Python Code Editor:
Have another way to solve this solution? Contribute your code (and comments) through Disqus.
Previous: Write a Pandas program to extract word mention someone in tweets using @ from the specified column of a given DataFrame.
Next: Write a Pandas program to extract only phone number from the specified column of a given DataFrame.
What is the difficulty level of this exercise?
Test your Programming skills with w3resource's quiz.
- Weekly Trends and Language Statistics
- Weekly Trends and Language Statistics