Interview Questions

Sean L. - " import pandas as pd def findaveragedistance(gps_data: pd.DataFrame) -> pd.DataFrame: #0. IMPORTANT: get the unordered pairs gpsdata['city1']=gpsdata[['origin','destination']].min(axis=1) gpsdata['city2']=gpsdata[['origin','destination']].max(axis=1) #1. get the mean distance by cities avgdistance=gpsdata.groupby(['city1','city2'], as_index=False)['distance'].mean().round(2) avgdistance.rename(columns={'distance':"averagedistance"}, inplace=True) "See full answer

Sri M. - "brand keeps promises continuously and consistently. so people belives brands.so it becomes loyal and repeating customers.so i want to become a brand driver who is improving corevalue and marketing value.brand means trust,design,value,strategy,logo,maketing,advertising,identity"See full answer

Uttam R. - "Clarifications ( Assuming this a technical question ) What is the purpose of this News feed ? Do we have a specific platform in mind ( Assumed Android phones ) Focus user group - People who use News feed a lot Business goal - Provide fresh and engaging content. Basic functionalities of news feed: News feed - A space where articles is collated and presented to the user Organise content. Customise news feed based on reading patterns. Push down older content. Keep the reader"See full answer

Hems S. - "I will start with clarifications: Q: How do you define "healthy" marketplace? A: When there is a balance in demand and supply Q: If we have balance, is it fair to assume, lot of transactions will happen? A: Sure Q: Also, is it fair to assume well known tokens on the platform already have a healthy marketplace with enough buyers and sellers. The problem is mainly with new tokens that will be introduced? A: Thats a fair assumption Q: Its okay to limit scope for this exercise to the CB retail a"See full answer

Prateek S. - "Before jumping in to answer, I want us to be on the same page regarding a few things: I am the PM for Coinbase app; not for coinbase pro or wallet etc. The very fact that a token will list on Coinbase increases the price / market activity around the token. We want to create a process which takes this into consideration. Users trust coinbase. Therefore, the assets listed on coinbase need significant vetting before they can be put on the system. Technology integrations - How much work"See full answer

Meet P. - "Improve Swiggy’s Revenue What time period? Improve to what extent? Increasing Swiggy’s revenue in next one year (assume) Any specific segment of Business? Swiggy’s Mission Statement : To make food eating experience as comfortable, convenient & authentic. Type of Business Swiggy is in Food Delivery Grocery Delivery - Instamart Dining Let’s Aim for one Business line say Food Delivery lets breakdown the revenue maths for the business and see what we can do to improve revenue F"See full answer

Jeff H. - "Google Pay currently makes money from a small percentage of interchange from each transaction. They also make money with Mobile recharge sim card fees. Questions Do we have a timeframe for this? How could we 10x this? Let's think about Alphabet's goal and vision to make the world more accessible and useful. To 10x it, we will need a combination of improvements, new revenue sources, and some paradigm shifting thinking. The goal in this case is monetization, and a steep on at t"See full answer

Soraya B. - "A load balancer, web application servers and a large database. Database is the core of the application containing the songs and tags related to each song. Application server will provide the search interface to find songs, play them and search them in specific categories or channels."See full answer