Python is reading my dollar amounts as in parentheses. How do I change that? For example: $-35 is coming in as ($35). What’s the best way if I am trying to see what my inflow/ outflow dollar amounts are?

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

Are you seriously posting this here rather than in stackoverflow ? Wow

funnylike

Yes....this!

I’ll give this a try, thanks!

Are you reading from excel? It’s probably bringing in as a string an maybe be formatted that way in the source

Yea it’s saved in that format, even if it appears differently in the spreadsheet. Probably easiest to convert to a number first

like

Related Posts

How do you write a good script? Where do you start?

like

Heads or Tails?

Post Photo
likefunny

Am I able to access MyLearning before starting with Accenture? I received a Countdown to Accenture email and it included a piece about starting trainings before your first day, but both the link to MyLearning and the link to support for the link not working were unaccessible.

like

What is the salary range for Enterprise Agility Manager- Technology Strategy & Advisory?

like

How is the hike and bonus guys

like

Layoff going on in Synechron ?

like

Is anyone here familiar with Goldman Sachs interview process ?

like

Anybody have strategies for combating narcissistic bully principals when the teacher is already mentally broken and completely vulnerable to their tactics?

like

My Dad and brother didn’t even text me happy birthday 😔

likesmart

Recent new hire here.. is there a way to see your specific level within your rank (e.g. senior 1 vs. senior 2)? Or is this something to ask HR? There wasn’t any indication during the hiring process unless it could be inferred by salary. Thanks!

like

Salaries for Creative Operations Manager?

$80k / F / NY

Would love to get a sense of the average base rate. I feel like I’m getting paid below market rate and yet still expected to work above and beyond.

like

I give the clients gold, but they decide instead, they want me to paint it with sh*t.

likefunny

Hi, I am looking to add a lateral practice group, got burned by a recruiter recently. What should I be looking for

like

It always seemed like real estate was one of the safest things to invest in. Then the crash of ‘09 happened, and the market bounced back for a while. And now we’re in… whatever this is. It just seems surreal.

like

My latest prospecting idea is to get address of families with new borns, but I'm struggling to find a way to turn those address into phone numbers. Any suggestions are welcome

like

Who is watching or has watched Dear White People on Netflix?

like

I decalred FBP, and the amount got deducted from my salary.
Now I can see I am eligible for some amount under FabP. What is it and when will I get it?
What exactly is the funda of it?
Let say I am eligible for x amount in FBP LTA. And some y of x got deducted in a specific month, now that y portion is showing in FBP tab to upload the bill.

What if in case I have LTA bill which is exceeding x amount itself, do I need to raise reimbursement request every month th with same bill?

like

AMERICAN EXPRESS India is hiring for UI Engineer role.
Title: UI Engineer – React, JSON, Cloud Engineering -21018062
Experience: 5+ years

JD screenshot is attached.
If interested, kindly DM me

Post Photo
like

I applied for a role at Amazon bit the status has not changed from Under Consideration since May, should I wait longer or consider it closed?
They have not contacted me for any rounds yet.

like

Additional Posts in Data & Analytics Consultants

Does anyone have a site/resource they use for coding interview prep? Currently doing practice challenges to refresh my SQL on Hackerrank, but wondering if there's anything better.

like

I'm non US citizen and thinking of moving back to EU. My plan is getting remote opportunities across the world and work as a freelancer. My speciality is Data analytics and BI (Qlikview, Tableau). 1) How likely I can get a gig from the US? 2) if a job looking for a remote 2-3 months contract do they care what country I'm in? 3) how can I compete Indian rates as I'm in Europe 60-70$ per hour as a BI consultant is a good rate but I see online rates as low 10$😫?

like

Hi fishes, can you guys share your favorite websites to look for remote job? To look for start up companies? TIA :)

like

Is there anyone around here with a combination of Data analytics - Finance & accounts OR Data analytics - Audit OR Data analytics - Risk consulting ? I am currently parr of industry - my role was created right before i joined and everyone is clue less how to utilize the role(I took this up right after graduating my MS) ! I am looking for some leads on how these combinations actually work incase any of you have time to spare for a quick chat here or comments on this thread ! TIA

like

Data Scientists: What were the skills you were interviewed on and what are the skills that you use in your day to day job? Let’s create a thread.

like

Any recommended courses or books on customer care/cust success analytics or marketing analytics in general?

like

Is there a good online course on storytelling with data? Something that can help structure your thought process and design choices when creating visualizations and Dashboards in Tableau, Power BI etc.

like

Has anyone else begun to resent data science?

like

Single book recommendation for user research?

Goal is interview prep. Ideally focused on applications in tech.

like

Meeting with a recruiter at one of the FAANG companies. I won’t be able to move jobs because of H1b /GC at least for the next year. Any idea if I should start off with that or should I just try to understand the work that they have been doing?

like

Anyone have recommendations on the best app/site to learn Python? 🐍
I’m a complete beginner.

like

Looking for technical data analyst in Austin, tx (also have remote available) to join a series E startup. Need strong python & sql experience. A lot of data munging and cross-functional work. Love to chat if this makes sense. Cheers!

helpful

does anyone else feel pressured to go to grad school if they want to become a data scientist after analytics consulting?

likesmart

At what level in BCG Gamma can you get to 300k+ TC?

like

Best way to explain to new firms that you are leaving your current firm because of the toxic culture and frankly, a President who talk down to people every chance he gets?

like

Learning cloud architecture right now so apologies if these are obvious questions: Best ways to store video metadata to perform analysis on it? I'm looking at AWS and GCP. Saw that Cassandra would be good for it, but not sure what the GCP equivalent is? But also I'm a bit confused on if Cassandra is just a DB and storage would need to be elsewhere? All help is welcome! I've been spinning my wheels on Google trying to understand

like

Best analytics tools to learn? Know Alteryx but I've heard people say they don't consider it an advanced analytics tool

Anyone have any suggestions for front end guis for users to run python code? I’ve created a few tools for webscraping data, automation, and modeling but non technical users freak out when they try to run the code themselves. Any suggestions? (Have tried Juypter Notebooks and a few other IDEs)

like

Can anyone at Ford Motor Company tell me more about the “Learning Analytics and Engagement Specialist” remote position? Very curious and would love a referral!

like

Do any of the top consulting firms have analytics roles (preferably not super technical) that don’t require weekly travel?

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