I have a list of about 70 million rows. I want to delete the the following and clean the dataset-
- Any values which are 0 or in the range of 0.001 or less.
- Any values that lie outside the range of 9:00am and 4:15pm
- If multiple quotes are present with the same time stamp, then replace that with a single entry of the median price.
I am able ot achive the third point, but not the second and the first one. Can someone guide me with this? Thanks