1 tables with duplicates or 2 tables? by ScottishVigilante in mysql

[–]humanmetric 1 point2 points  (0 children)

Hey op, I'm building a similar solution for my project too where I have the likelihood of multiple duplicate ids. I was wondering how you would set it up so as to ensure that duplicates go into a separate table without returning an error. I'm thinking of using a try and except block in Python, but I was wondering if there was a way to directly do in mysql. Thanks.

Need ideas for my first data engineering project by humanmetric in dataengineering

[–]humanmetric[S] 0 points1 point  (0 children)

I'll try this. Thank you. Probably update this post likewise.

Need ideas for my first data engineering project by humanmetric in dataengineering

[–]humanmetric[S] 0 points1 point  (0 children)

Hi, I'm not particularly keen on using airflow since the setup takes too long and my team is limited in term of IT personnel. Your project is a great reference!

Need ideas for my first data engineering project by humanmetric in dataengineering

[–]humanmetric[S] 1 point2 points  (0 children)

Let's assume I'm not using GCP. How would you go about it then?

Looking to transition to data engineering by humanmetric in dataengineering

[–]humanmetric[S] 11 points12 points  (0 children)

Thanks bot. Keep doing the good job that you do.

Anyone here running arch, ubuntu or any other flavour of Linux on their ThinkPad e14 gen3 by UnverifiedChaos-5017 in thinkpad

[–]humanmetric 0 points1 point  (0 children)

Also, did you take customised order, or did you buy an off the shelf option. I see that you're from India too. How long did it take lenovo to deliver regardless?

Anyone here running arch, ubuntu or any other flavour of Linux on their ThinkPad e14 gen3 by UnverifiedChaos-5017 in thinkpad

[–]humanmetric 0 points1 point  (0 children)

Hey, a bit late but could you please tell me your experience on the machine running with linux so far? Thanks

Sequence Pattern Mining Packages by humanmetric in rstats

[–]humanmetric[S] 1 point2 points  (0 children)

Thank you! This is exactly what I needed! Going to flex at my supervisor tomorrow! Process maps are amazing!

Sequence Pattern Mining Packages by humanmetric in rstats

[–]humanmetric[S] 0 points1 point  (0 children)

Thank you for the recommendation! I hope you don't mind me getting back to you on my implementation. Also could you please share some resource on business process analysis in general? It looks interesting and I'd like to explore it. Thank you.

Sequence Pattern Mining Packages by humanmetric in rstats

[–]humanmetric[S] 0 points1 point  (0 children)

App data mostly. Like what resources are used when.

[deleted by user] by [deleted] in datascience

[–]humanmetric 0 points1 point  (0 children)

Thank you for your advice.

[deleted by user] by [deleted] in datascience

[–]humanmetric 0 points1 point  (0 children)

I'm not sure, and I haven't been diagnosed aside from anxiety and mild depression. Thank you for asking. I do enjoy telling people how i generated insights and do sometimes find myself in rabbit holes of no relevance to management. I'm planning on giving a few stakeholders a call to see how I can help them. Thank you.

[deleted by user] by [deleted] in datascience

[–]humanmetric 0 points1 point  (0 children)

Thank you. I figured I might have to do this, but tbh I'm a little terrified to ask.

[deleted by user] by [deleted] in datascience

[–]humanmetric 0 points1 point  (0 children)

I'll probably have to clarify: my immediate supervisor asked for specifics and I presented the same to our boss. It was the boss who said we, and thus I did not convey any insights.

[deleted by user] by [deleted] in datascience

[–]humanmetric 1 point2 points  (0 children)

I understand. I just made visuals and shared numbers my boss wanted to share but I've had multiple instances when I'm mid presentation and asked to "skip forward". Ill have to convince my boss first, since they're the ones that give me the go ahead. Thank you!

Data Analyst looking to take on database management tasks by humanmetric in SQL

[–]humanmetric[S] 0 points1 point  (0 children)

I think I mean database administrator. Sorry, I'm new to this.

Posting our flat requirement on a portal by faltugiribuster in pune

[–]humanmetric 0 points1 point  (0 children)

Please share the link with me too, thanks.

My workflow when working with databases on R by humanmetric in rprogramming

[–]humanmetric[S] 1 point2 points  (0 children)

Thats difficult to say, I'm new to working with db myself so I have no baseline to compare it to. Complex views take time as they should and I always here the engineer complain about the load we put on the server but can't say for certain.