Category : data-analysis

I want to search some stores in a country, for example: Find all Nike stores in US. I implement it by using Google Map Place API. However I found that Google API seems not allowed to search a target that located in specific country, and it also restrict the searching radius (50000 meters). So, I’m ..

Read more

I need to modify my code: db_profit_platform=db[[‘Source’,’Device’,’Country’,’Profit’]] db_profit_final=db_profit_platform.groupby([‘Source’,’Device’,’Country’])[‘Profit’].apply(sum).reset_index() Now I need to add Bid and get average bid after group by (different aggregations for different columns): to get: Source Device Country SumProfit Average Bid How can I do it? (and maybe I will need more aggregations) Thanks Source: Python..

Read more

In python: I have a dictionary of 1000 products like this: products={p1:"apples",p2:"oranges",…,p1000:"bananas"} I now have 20.000 old shopping orders (dictionary) that look like this: orders={ "order_1":{"p1":100,"p7":30,…,"p560":126}, "order_2":{"p6":1300,"p7":51,…,"p423":3000}, …, "order_20000":{"p1":700,"p4":5,…,"p942":178} } Each order has different number of unique products (100-200 products) For each order I have the time it took to gather all products: time={"order1":15days,"order2":34days",…,"order20000":7days} When ..

Read more