Column type TimeField.

[Elias Coutinho]

Guys good morning,

I have this dataframe below:

 # Column Non-Null Count Dtype
--- ------ -------------- -----
 0 CODE 242639 non-null object
 1 DESCRIPTION 242639 non-null object
 2 COST 242639 non-null float64
 3 SALE 242639 non-null float64
4 DTREFERENCE 242639 non-null datetime64[ns]
 5 QUANTITY 242639 non-null float64
 6 OPERATION 242639 non-null object
 7 RETURN 242514 non-null object
 8 VLUNITARY 242514 non-null float64
 9 DISCOUNT_ITEM 242639 non-null float64
 10 CANCELED 242513 non-null object
 11 NUMBER 242513 non-null object
 12 GLOBAL_COUNT 242639 non-null float64
 13 TIME 242639 non-null object
 14 FAMILY 242639 non-null object
 15 GROUP 242639 non-null object
 16 UNIT 242639 non-null object
 17 VLBASECOMMISSAO 242514 non-null float64
 18 ALCOMISSAO 219432 non-null float64
 19 QT_PRATELEIRA 242639 non-null float64
 20 QT_DEPOSITE 242639 non-null float64
 21 CUSTOMER_FORNECEDOR 242639 non-null object
 22 LOCATION 242639 non-null object
 23 CITY 242639 non-null object
 24 CITY 242639 non-null object
 25 UF 242639 non-null object
 26 SELLER 242639 non-null object
 27 YEAR 242639 non-null int64
 28 MONTH 242639 non-null int64
 29 TOTAL_OPERATION 242514 non-null float64
 30 STOCK 242639 non-null float64

Note the series (Types) 4 and 13

The data source is Postgres, a database that I did not create myself, i.e., I have no authority to modify.

Series 13 is an hour, minute, second and milliseconds only field
In this series there are records that present the value of milliseconds and records without this value.

Series 4 presents the date.

My goal is to make a filter in pandas through the initial and final time, that is, show me all the records between 07:00:00 and 19:00:00.

I am not getting this because it is really new this type of conversion because the way it is it does not accept a range because it is a text.

 Can someone help me with this task?

It is merely for study.