Help needed: I have an excel file with thousands of lines with the coordinations of the starting and destination points, and I would need a proxy of the distance in km. Is there any tool available to do it? Thanks!

like
Posting as :
works at
You are currently posting as works at

R or python would be your best bet

like

import pandas as pd

df = pd.read_csv(file.csv)
df[‘distance_in_km’] = convert_to_km(df.start, df.end)

like

Do you know how to use R? There are many packages that can accomplish what you are asking.

Message the gamma help team, they’ll do it for you in 10 mins. If they’re busy and not urgent, have evaluserve manually enter each address overnight and find the distance.

Noooo, not tech skills!!

This should be the straight line distance in KM, you can then add a factor to approximate driving miles if that’s what you need

=ACOS(COS(RADIANS(90-Lat1)) * COS(RADIANS(90-Lat2)) + SIN(RADIANS(90-Lat1)) * SIN(RADIANS(90-Lat2)) * COS(RADIANS(Long1-Long2))) * 6371

Related Posts

Hilton 🐠 - what are your favorite properties to redeem points? What’s the best deal you’ve seen? Can be anywhere in the world. Interested in Waldorfs or Conrads that I can’t afford to pay in cash.

Flight attendant woke me up while I was sleeping to give me ice cream, then I couldn’t go back to sleep.
How many points?

likefunnyuplifting

Is it just me or do 90% of the jobs being laid off by big tech sound made up? Many job descriptions with multiple bullet points that all kinda revolve around the same idea. One of my buddies works for a big IT company and literally just sits on meetings all day. No one really contributing to anything other than agreeing to whatever the speaker is saying. Are these kind of jobs finally being exposed? Six figure employees getting paid to sit and bounce ideas off each other?

like

Hey some help FB: had to move rooms at a Westin bc the tv was so broken they couldn't figure out how to fix it -- they were nice but is there a way I can at least get points for that and how?

like

Took content knowledge praxis for the 4th time today and missed by 2 points for NJ standard. Does anyone have any study tips? I want to give up but I don’t. It’s just very frustrating! Help please!

likehelpful

I'm just so angry when I wake up after travel and the points aren't updated yet

like

It grinds my gears that my manager always uses smiley faces and explanation points in his emails.
ae. Hey! The report looks great :) let’s add x and y to the slide! If any edits need to be made I’ll do them tonight :) Let me know if any questions!

Smfh

likefunny
like

About to start in the GPS human capital practice as a SC. What are some things you wish you knew or should get involved in early? Bonus points if they help you progress to manager

like

Transactional associate. Lateraled 6 months ago and one of the biggest pain points has been my new firm’s inclination to “hop on a call”, which of course requires every single stakeholder to join. The end result being every call has 25 people on it and nothing actually gets done because no one wants to ask a question that could come off as silly. It’s destroying my ability to get anything done during the day. It’s a complete performance and it drives me nuts.

like

With the new point system with Marriott/SPG are they going to re evaluate hotels categories? Currently a cat 7 hotels are 35,000 points it looks like the new cat 7 standard is 60,000

like

What credit card to you recommend pairing well with chase sapphire preferred for maximizing redemption? Pretty new to points and def don’t know a lot! I’m considering one of the Marriott cards bc we love Marriott or an Amex one! Any ideas appreciated 🤗 TIA!!

like

How long does it take Amex to post points? My latest statement is from 12/28, and I still can’t see the points

like

Can we consider cars from the 90s to be classics?

Sub question: what's your favorite 90s-era car? Extra points for pics.

like

Question about inclusion…. I’ve been teaching inclusion for 5 years so I’m still a newb, but a first year coworker of mine said she got points off on her observation because her kids were scattered in the classroom and she was having to move from kid to kid to assist. While I see the point of putting them together for convenience, I don’t agree with this at all! To me this is like singling them out by putting them all together instead of INCLUDED amongst peers. What do y’all think?

likesmart

Hello Fishes, Can please someone tell me what are some of the nodal drop points for cabs for Morgan Stanley employees? Need to know for reallocation planning. Thanks Morgan Stanley

like

Hi,

Today I will be having an interview with Hexaware for data science role. I appreciate for sharing key points to crack it, and how well is the work culture & is it WFH ?

Hi Fishes,

Do these 2 points in the JD allude to modelling requirements?

• Prepare transaction specific and marketing materials (teasers, information memorandum, pitch books, corporate profiles, and industry data and analyses)

• Perform in-depth company and industry research supporting specific client engagements and marketing opportunities

like

If you bought a United Flight with miles can you change your flight and book with cash? I don’t have enough points for flight I want to change to and app is only give me miles option

like

More Posts

If you interview for a job but are not offered the position, is it weird to try to connect with some of your interviewers on LinkedIn? I genuinely liked some of my interviewers, but apparently the company identified a candidate whom it believes is a better fit.

like

Anyone have insight on how to move in-house at EY?

like

How is productivity measured for in-house attorneys? Is there any analog of billable hours for in-house lawyers?

like

Hi fishes, Can anyone tell me what is the salary offered for Monitoring Analyst II ( L23) in Paypal. I have 6 yrs of experience in same domain . How much to expect and ask

Is LTI asking people to resign after being on bench for 3 months?

like

Got ahead in my work by working ~70 hrs the last week so my manager isn’t screwed over when I give me notice tomorrow to quit. Going to a competitor so I wanted to screw his hours over as least

like

If something is filed with the court, and service is provided automatically thru the portal, why does OC’s office send a separate e-service email? I understand with a PFS and Roggs — but for regular filings such as notices and motions I don’t need the document twice. I got it thru the portal. Am I wrong? Am I getting annoyed for no reason?

like
like

Fis mohali is now permanent wfh, they've closed it down

like

Someone made disposable Hijabs as part of PPE. Super cool idea!

like
like

Anyone selling dodger tickets tonight

like

Any recos for directors who kill it when it comes emotional storytelling in short form content? As in :15. Mostly visual, little dialogue.

How can a jr designer make a solid jr art director? My book has big idea concepts w/ executions & video but nothing traditional advertising. Interests are: overall mood, meaning, relevance. Any tips?

like

I feel like 80% of my job is producing. Is this normal, or am I just working with shitty producers?

like

Alright y’all.. I started a new job about 3 months ago and I have basically hit the ground running. I’m kind of new to my industry (SEO) and my team is INCREDIBLY smart! continued...

like

Have you ever failed to deliver? What was it and why?

like

Wondering if anyone has a good example of a brand that originally sold a commodity/mass food and successfully introduced a premium/luxury line, under the same brand name. Kicker is the brand has to have started as mass then gone upmarket, nor vice versa.

like

Folks- does anyone work at 360learning? I’m considering a product role there, and was curious to hear from fishes 🙂

Hey folks!

Does Deloitte India (not Deloitte USI) ever cancel on the job offer they have given (like cancelling on the candidate at the last moment, well after releasing the offer letter)?

likehelpful

Additional Posts in Consulting

What’s the solution to email overload? At this point if it’s not coming directly from my team or clients or emails about compensation it goes right to archive and I don’t read it. I feel like I’d miss something important, but I probably get 15 emails a day that get deleted immediately otherwise.

like

Any A&M fishes who moved from US to Europe willing to connect ? How hard is it to make the move ? What approvals did you take ?

like

How would you explain the cultural difference between bankers vs consultants?

like

Which consulting firms are hiring for experienced Associate position? Have a friend who got laid off and looking for another job.

like

Another consultant is actively trying to backstab me. Advice for getting ahead of this?

like

Any recommendations for a work desk?
Not looking for something too big or pricey. Easy assembly / disassembly is a plus.
I see foldable desks going for $100. Any foldable standing desks out there?

like

I think I saw this once before, but does anyone have the link to a spreadsheet with the career level equivalents across firms? I.e Manager at Accenture is equivalent to Y at XYZ firm?

like

Do you ever feel like you’re just not good enough at work.

like

Best consulting firms to work for that will allow 100% remote work indefinitely regardless of what clients do?

like

Advice or Book recommendations on how not to get bothered by others/ friends/ peers? What they think or what they do!
Been struggling lately

like

I’m sick of the word ‘digital’. This is such fluffy BS.

likehelpful

Let’s be honest, since we’re all wfh (or most of us are), whose contemplated on picking up another 9-5? Lol. I’m be real, I have. Even for some chump change, it’s easily doable and sustainable for at least 2021.

likefunny

Slalom folks, are you guys mandating vaccines? Been v quiet.

like

Would you ever consider spinning off as your own LLC? Why or why not?

like

What happened to group boarding at AA? Took a flight after a long year and half of not traveling, and all these new people board whenever they want.. group 1 is 3/4s of the plane! 🤷🏻‍♂️

like

Looking to improve general communication skills (especially around structuring narrative/ key messages), any books/courses that you would recommend?

like

Your conversation points for today

Post Photo
likefunnyuplifting

dreading the workweek, so instead of going to bed and getting a good night’s rest, I’ll stay up to give myself a false sense of delaying Monday

like

I had a final round of interview yesterday. At the end of the interview, the interviewer said ' let's stay in touch'. A bad sign, right? Should I give up the hope?

like

Best advice for new analysts or graduates?

like

New to Fishbowl?

Download the Fishbowl app to
unlock all discussions on Fishbowl.
That was just a preview…
Sign Up to see all discussions
  • Discover what it’s like to work at companies from real professionals
  • Get candid advice from people in your field in a safe space
  • Chat and network with other professionals in your field
Sign up in seconds to unlock all discussions on Fishbowl.

Already a user?
Login here

Share

Embed this post

Copy and paste embed code on your site

Preview

Download the
Fishbowl app

See what’s happening in your industry
from the palm of your hand.

A phone with Fishbowl app

Scan your QR code to download
Fishbowl app on your mobile

Download app

Sign up for free to view this conversation on Fishbowl

By continuing you agree to Terms of Use and Privacy Policy

Already have an account? Log in

Sign up for free to continue using Fishbowl

By continuing you agree to Terms of Use(New) and Privacy Policy(New)
Messaging rates may apply

Already have an account? Log in

For account settings, visit Fishbowl on Desktop Browser or

General

Legal