Noob question - I want to consolidate the dates into a single dates column. Would numpy or pandas help me reorganize this dataset effectively or should I do it within excel?

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

OP- it’s usually the problem other way around. Can excel do what numpy or pandas is able to do.

like

If the data set is small an index match is a speedy way to accomplish that in excel

like

pd.melt()

likehelpful

Yes, google melting columns to rows pandas

like

pd.melt() worked perfectly - thank you ALL!!!

like

Try melt. The entire purpose of melt is doing this

Couldn't you just pivot table this and repeat values?

Related Posts

5/13 check in. My PM ride is done. What did you do today?

Post Photo
likeuplifting

Day 6 - 40 push ups challenge ✅ Enjoy your weekend 💪

likeuplifting

Started at my first agency 3 mo. ago. I’m doing great work on exciting clients, but I often feel uninspired and drained. Is it growing pains or is this the wrong industry for me? How will I know?

Do you think a teacher dating/marrying another teacher is an ideal situation?

likehelpful

Is IB worth the sacrifice of WLB? Obvious pay is really good but are the prestige and pay worth it if you’re planning on only doing it for a couple years?

Currently working at an IRA with great WLB. Honestly I love my job, the firm, and people I work with.

Also doing MBA part time at a T15 school. Thinking about switching to IB but I’ve done my research and I think I would burn out of IB in two years but I might be ok with that for the opportunities after.

like

If i am a fresher in cognizant and worked for 2 months and have got better opportunity can I abscond from same as the other company is asking to join immediately

like

Curious what people's age ranges for dating are. There's the classic "half your age plus seven" rule, but wondering if that's actually followed.

Please comment below with your age, gender, and range.

like

To those who have delivered. Are they still doing photography at the hospital after you deliver?

like

Having gone through a very underfunded public school system I felt inadequate and I was able to coast by through college. Though I feel like Im capable now I still feel inadequate sometimes. Thoughts?

Looking to buy an 💍. Might make a trip to India in 6 months. Any advice on helping me make the decision to buy in US vs India?

like

Im a senior and got a new associate replacing another one that quit, she’s been amazing and anticipates needs and finishes quickly so that i can offload my work for her. So do i chill with freed up time or go steal the managers job now?

like

Does anyone know how competitive the Data Science Analyst AARC@606 program is at Discover Financial Services? Job description is asking for 0-2 years of experience. Have an interview with them soon and wanted to get some insight.

like

Hey fishes, last week into my notice period. Help me choose between Nagarro (Staff Consultant), Aristocrat Technologies and Coforge (Lead BA). Nagarro Aristocrat Technologies Coforge Tata Consultancy EY Criteria: Quality of work, Growth prospects Thanks a lot !

like

Any podcast recommendations for a new government consultant? I’m specifically looking for a podcast that can help me stay abreast of what’s going on in the consulting world and one that can ultimately help me do better at my job.

like

I’m in Deloitte human capital and want to eventually (but sooner rather than later) move to industry doing internal talent/people stuff. My coach recommended getting SPHR or equivalent. Thoughts?

Have an interview for Manager position in Bain’s Sydney office. Anyone there available to chat about their experiences?

like

What is the performance review cycle at Salesforce? Will someone hired in November/December be eligible to receive the annual bonus?

like

Hi Fishes, If I join Bank of America (BA Continuum) on October 1st, will I be eligible for hike in coming appraisal. Bank of America BA Continuum India Pvt. Ltd.

like

Does ever find that FDD is repetitive?

like

Additional Posts in Data & Analytics Consultants

Is anyone here a google developer expert (Machine Leaning)? Quite curious to know what is it all about

like

What do you folks think about a monthly show and tell of anything data-related?
Open forum where anything relating to data & its applications would be fair game. E.g.:

-a visualization you made and/or like
-data pipelines for a personal website
-market analysis
-relevant memes
-scientific article
-data news
-what you'd like to see data driven but isn't

In a nutshell, a conversational experience. Introduce and discuss ideas. BYOB and at least 1 talking point, or if you really want a full deck

likehelpfulupliftingsmart

Any BCG Gamma fish? Can you please share what kind of analytics projects do you guys do?

likehelpful

EY is hiring for various senior level positions in Data & Analytics practice. (Staff-2, Senior, Manager etc). Please DM me in case you have any questions and I’ll be happy to refer in case you have a relevant experience.

like

What’s so good about the Georgia Tech OMSC and OMSA? Is it just the cost? Seems to be recommended by most of reddit

likehelpful

Anyone works/heard of DMV Group? Mind if i shoot some questions about them?

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

like

Has anyone created live dashboards via Data Studio instead of Tableau? Thoughts?

What is your best advice for moving into data science without going back to school for a masters?
I have an engineering bachelors and my mba, and want to move into the data science and analytics side of things in the long term.
I’m currently in Strategy Consulting and I find it too functional and hypothetical/theoretical/ high level. Looking for advice on resources, timelines, skillets, building connections/network, things to consider, moving forward /path of last resistance, etc etc

like

Looking for experienced Data Scientists and ML Engineers to grow my team. I’m head of Machine Learning and Data Science at one of the largest Fintechs. Shoot me a message if you’re interested. (ex consulting manager) Thanks!

like

Hey! For one of my project, I had to build macro to do data cleansing in excel. However template might change one day to another. Anybody knows good resources I can use to make this a sustainable ...

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

Does accenture have proper data science projects? Seems like most of projects are pretty basic analytics, reporting, and/ or ETL

likehelpfulsmart

Thanks, team :) Wonder who the class clown is tho

Post Photo
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

Can anyone from Blackstone share some insight about the Data Science Management Program? Looks like a fantastic opportunity!

like

Anyones firm still hiring entry level, under 1 YOE. In Chicago?

like

I am seeking a technical co-founder for our b2b saas-based startup. We are a team alignment, communication, and performance reporting platform that makes it easier and more effective for teams to capture, organize, and disseminate updates.

About Me: I am a serial entrepreneur who has launched several successful companies. Please DM me if you or anyone in your network may be interested in this opportunity.

Post Photo
likefunny

I am currently working mostly in Data Analytics, but I want to transition into Data Engineering. I've applied to a couple Data engineer positions but it seems I don't have the qualifications for them. Should I maybe look for Jr. Data Engineer positions to get experience and try to move up from there? If so anybody know of any Jr. Data Engineer positions available?

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