Skip to content

Reference last object that was called?

Im sure this was asked before, but when searching for it i only found questions like “reference last object in a list” However, i am looking for something to make this example code not redundant – in this example i have to use two very long variables: I know that powershell has $_., and im w…

Equidistant timeseries filling the blanks

I have the following code that generates a timeseries with 1 min steps but would like to have the time gaps filled. i.e 13:58 is missing in between. Every ip should be represented in the gap with zero values. How can this be achieved? Answer First change unstack by first level for DatetimeIndex, and add DataF…

How to merge two dataframes and eliminate dupes

I am trying to merge two dataframes together. One has 1.5M rows and one has 15M rows. I was expecting the merged dataframe to haev 15M rows, but it actually has 178M rows!! I think my merge is doing some kind of Cartesian product, and this isn not what I want. This is what I tried, and got 178M rows.

Convert result of sum of timedeltas in Python

I have the output below from a sum of a timedelta list in a column on my dataframe. How do I get values converted to hours minutes and total seconds? Answer afaik, there’s no built-in functionality for this. But you can create your own. For example for formatting to a string in H:M:S format or splitting…

Can’t convert curl to python request

I copied request as CURL with help of dev-tools and received: Copied request to console (curl works fine). Received result Converted curl to python requests with help of https://curl.trillworks.com/ Received: Tried this code and received error Body is not valid Latin-1. Use body.encode(‘utf-8’) if…