{ "media_type": "text", "post_content": "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_id": "5f3f62c7eae653002b159a83", "reply_count": 8, "vote_count": 1, "bowl_id": "5ace5097be6e660013abcc42", "bowl_name": "Data & Analytics Consultants", "feed_type": "bowl" }
null

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?

Additional Posts in Data & Analytics Consultants

Have a 30 min first round with a small pe firm for an analyst role. Any idea what I should prep? It’s with one of their associates.

like

Went through a professional diagnosis at a reputable local hospital and the results came back that I don’t have it as I scored too well on their testing measurements.

Normally one would be relieved, but I have a tough time buying it. It doesn’t explain my lack of focus, persistent daydreaming, zoning out of conversations, subpar short term memory, inability to sit perfectly still for stretches of time.

Do I go seek a second opinion?

like

HCL Technologies or CGI ? Which one is better for developers on a long time perspective ?
Tech stack Java with ReactJS.
Both offering same salary 20LPA
YoE : 5

like

Hi, could anyone give me an idea of SE salaries in Europe? E.g. Google, Amazon, Salesforce? Others...

TIA

like

Ok. Raise your hand if you used Barbie for the Young Lions brief.

likefunny

Is anyone who has worked at Acumen Fund open to sharing their experience?

like

What's your stand point on affirmative action?

like

Hi,
I have some ques
1. My current Package is around 24LPA (including all the components). Is it a wise option to join ISB-PGP program? Provide post 1year I will land in a job with approx. similar package.
2. How you prepared for GMAT along with job? Will you suggest taking any coaching?
2. Study materials you used?
3. What GMAT score to target? (10th ICSE 69% 12th ISC 84.8%, B.Tech. in ME 8.54 CGPA, 3 years work ex in April)
4. How to prepare for interview?
5. Anything else to consider while prep?

like

Guys,
What will be the take home per month for 16lpa. And I can avail HRA benefit as Im paying housing loan.

like

How do you present of a/b testing on resume if you don’t have field experience?

like

I'm glad to see that our community has become 3.5K times stronger in such a short span of time! I'd like to encourage all of you to come forward and impart wisdom with your knowledge and experience among the ones who seek it! Keep it up everyone!

like

Does anyone have an example of a motion to hold proceeds from the sale of the marital estate in one of the attorney’s trust accounts pending resolution of the divorce? Baby lawyer trying to figure out what type of motion it would be - motion for protective order (to protect assets), etc. Any help appreciated!

like

What range should I expect when exiting from Deloitte. Consultant, 2 YOE.

Started off as SWE and then did tech strategy and architecture type work. Trying for product exits.

likehelpful

Can I change my work line in KGS MC?
Any suggestions

like

Anyone got experience developing brand strategies for neobanks, concretely Fintech operations who are establishing themselves as mobile only banks & targeting late Millennial/GenZ audiences?

like

Need hearts guys for DM and real life!

like

Looks like deep fried cicadas are all the rage. Would you eat this?

Post Photo
likesmartfunny

Basic Question : one we buy USDT in Voyager..how do we deposit to earn interest?

like

Hi Product bowl! I am actively looking to switch from Tech Consulting to an Associate Product Manager role, in industry. Would anyone be willing to look over my current resume/suggest how to frame my experience in a PM lens? I’ve already done some re-work, but I figured asking a PM fish to review could be super helpful!

like

Additional Posts (overall)

What processes/tactics would you implement to improve the design culture at work?

I'm trying to improve the design of products at my work, beyond just my own work. I've identified three solutions:

* Templates for common product types
* Best practices manual
* Design reviews

What would you add? Tried searching online and couldn't find much that was relevant, or too amorphous/generic. I don't control hiring and can't command people to 'be collaborative!'

like

Hi Everyone. Asking for my wife. She is a recent graduate having done her masters at the University of Chicago. She is looking for roles in data analytics. Can anyone help and refer her to DA roles.

How is Nielsen Netherlands for a Data Scientist?Pros and Cons? Salary slab for intermediate Data scientist

like

For those with business school (not math/CS backgrounds), at what point did you feel okay calling yourself a data scientist or saying you did data science as opposed to being a business/data analyst?

likeuplifting

Which Industry needs Business Intelligence the most ?

like

Didn’t get an offer after extensive interviews and effort, am feeling extra pain this long weekend. Hope everyone else gets their promos and dreams :(

like

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

Post Photo
like

Anyone use powerapps for anything? Just curious.

10 years analytics experience. TS/SCI with CI polygraph cleared in DC area. Anyone need a referral bonus?

like

Is anyone working on a cool real time data analytics project in the health field? I am trying to figure out where to go next.

like

S&A folks at Deloitte, for Consultants (level II) in your teams, how much data science/coding do they need to know (ex: Python, R), versus just basic data analytics (Tableau, PowerQuery, etc)?

Can anyone give a synopsis on DAX and Power Pivots for dummies?

like
like

What can I expect from a panel interview for EY consulting FSO? I applied for Data and Analytics role.

like

I know KPMG is highly regarded around here, but how does it compare to client-side technology roles in DS?

Interviewing at the SM level

I have DA interview with Nielsen. Any key things I should know about the company or prepare to discuss that could impress interviewer?

like

About to join the arm of large consulting group that does AI. However my work will be functional. It seems like a lot of opps in the field are more technical. Am I shit out luck in terms of exits??

If my current project involves building a predictive model in Python and implementing it in production for batch recommendations on where to spend marketing $, am I doing data science?

like

Got a job after consulting as a “data scientist” but have never taken advanced calculus and linear algebra. Was thinking of taking these at night at local college, reasonable idea?

like

New to Fishbowl?

Download the Fishbowl app to
unlock all discussions on Fishbowl.
Download Fishbowl to see what others are saying
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

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

New to Fishbowl?

image with Fishbowl logo and arms reaching out for a handshake

Already have an account? Log in

By continuing you agree to Terms of Use and Privacy Policy.
Messaging rates may apply

For account settings, visit Fishbowl on Desktop Browser or

General

Legal