How to extract only the numerical part of the columns in this table? (Python)

Question

I am editing a CSV file in Python, I have deleted some columns, created an index and filtered. But I have not been able to extract the numerical part of the columas. How can I extract only the numerical information from the columns?

Extract only the numeric part of the column data. example:

MarketTime = 11: 18: 26.549

The whole column should be like this:

11: 18: 26,549

import pandas as pd

df = pd.read_csv('C:/Users/TECNOLOGIA/datos.csv',names=['LocalTime', 'Message', 'MarketTime', 'Symbol', 'Type', 'Price', 'Size', 'Source','Condition','Tick','Mmid','SubMarketId','Date'], usecols=['Type','MarketTime','Price'],index_col='Type') df=(df.loc['Type=0']) print (df)

Possible duplicate of How do I find numeric columns in Pandas? — aiven
– aiven, Commented Jan 9, 2018 at 22:19
Please include the data in the question, not as some image that might disappear in the future. — Ralf Stubner
– Ralf Stubner, Commented Jan 9, 2018 at 22:21
we're not code writing service. Please also include what you tried and where you got stuck. Also, include the data array so that we can help you better — kmario23
– kmario23, Commented Jan 9, 2018 at 22:22
Please add your data as text in your question. Pictures (or links of pictures) do not make it easy for us to answer the question. — cs95
– cs95, Commented Jan 9, 2018 at 22:32

Alex Bausk · Accepted Answer · 2018-01-09 22:59:10Z

0

Adapting the Regex/Pandas StringMethods answer given at pandas applying regex to replace values, you will have something like this:

import pandas as pd

df = pd.DataFrame(['MarketTime=11:18:28.792','MarketTime=11:18:28.792'], columns=['MarketTime'])

df['MarketTime'] = df['MarketTime'].str.extract(r'([\d:,.]+)')
print(df)

answered Jan 9, 2018 at 22:59

Alex Bausk

7185 silver badges30 bronze badges

Sign up to request clarification or add additional context in comments.

3 Comments

Alex Bausk Over a year ago

And please clean up and format your original question, removing the image links.

Manuel Rincon Over a year ago

Thanks Alex, I'm trying to work on all the values in the column. Is it possible to apply it to the whole column?

Alex Bausk Over a year ago

Umm it IS applying the extraction to the whole column, what are you seeing?

Collectives™ on Stack Overflow

How to extract only the numerical part of the columns in this table? (Python)

1 Answer 1

3 Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

3 Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related