Final result dataframe shows less rows than it should
I did solve an original problem in this post, but another one appeared…
How I can I calculate a cost per lead/enquire using two different dataframes?
Every quarter I need to calculate the cost per lead/enquire (CPE) from real estate portals. From a complete table that has all the enquiries in the quarter, I need to filter first all enquiries that came from a sub-origin “portals” (specific column), then I need to count the ocurrencies for each portal (including the portals that had 0 enquiries), and then I need to divide each portal´s number of enquiries by the money spent in it to find its CPE (in a new created column).
pandas cannot find local csv file in google colab [duplicate]
This question already has answers here: How to use Google Colab to work with local files? (3 answers) Closed 1 min ago. I tried to open a csv file in google colab that I downloaded from the internet and it’s in my download file. The full path is: C:UsersAsusDownloads so I looked on the internet […]