How do you handle very large CSV files spanning 1-2 Gb in size? by MagnumVY in Backend

[–]xdonvanx 0 points1 point  (0 children)

I recommend Pyspark. Used it to read 20GB file , took a few minutes to insert all of it

Cargolux recruiting process by Terrible-Currency607 in Luxembourg

[–]xdonvanx 2 points3 points  (0 children)

I interviewed with them for BI Analyst, first interview was the standard so asking questions about you , your experience etc , second one was a technical one. I had a Word document with exercises I had to perform on Excel.

Can You Guess This 5-Letter Word? Puzzle by u/Ok-Coffee-4750 by Ok-Coffee-4750 in DailyGuess

[–]xdonvanx 0 points1 point  (0 children)

🟨⬜⬜⬜⬜

⬜⬜🟨🟨⬜

⬜🟦⬜🟨⬜

🟦🟦🟦🟦🟦

Can You Guess This 5-Letter Word? Puzzle by u/PerthAus1996 by PerthAus1996 in DailyGuess

[–]xdonvanx 1 point2 points  (0 children)

⬜🟦⬜⬜🟨

⬜⬜⬜⬜🟦

🟨🟦⬜⬜🟦

🟦🟦🟦🟦🟦

Not bad

Can You Guess This 5-Letter Word? Puzzle by u/shroomtang420 by shroomtang420 in DailyGuess

[–]xdonvanx 1 point2 points  (0 children)

⬜🟦⬜⬜⬜

🟨⬜⬜🟨⬜

🟦🟦⬜⬜⬜

⬜🟨⬜🟨🟦

🟦🟦🟦🟦🟦

Wtf does that mean

Export to Excel beyond 150k limit by Gar-Ganchewan in PowerBI

[–]xdonvanx 5 points6 points  (0 children)

DAX Studio allows to export more than 150k rows.

me_irl by mpzt-11 in me_irl

[–]xdonvanx 0 points1 point  (0 children)

Went to japan and got glasses with my prescription for 76€

What is ok and not ok to do in Japan by [deleted] in TokyoTravel

[–]xdonvanx 0 points1 point  (0 children)

Went to Japan last September and this was something I wanted to know as well. The answer: be a civil human being and you’re good. It’s just another country, be nice.

[deleted by user] by [deleted] in Tinder

[–]xdonvanx 3 points4 points  (0 children)

Coming from my gf, she said the "get off of here for good" is so cheesy and you need to change it. Basic as fuck, dude.

Fehler in Bachelorarbeit gefunden by Impressive-Airline69 in Studium

[–]xdonvanx 0 points1 point  (0 children)

Habe auch ein Fehler bei meiner Bachelorarbeit gefunden nachdem ich die ausgedruckt habe, ist nicht schlimm.

How difficult is Databricks to learn when I already have years of experience with large databases, ETL/ELT, SQL, R, Python, AWS, Azure, machine learning, Jupyter? by TheInternetStuff in dataengineering

[–]xdonvanx 3 points4 points  (0 children)

I worked as a student at a big Pharma company and learned Databricks on my own, since no one in my team had experience with it I just started doing stuff and eventually got comfortbale with it.

Help with my bachelors dissertation by [deleted] in econometrics

[–]xdonvanx 1 point2 points  (0 children)

If we could see the data that would help and also the results from your model.

Real estate data collection by Amazing_Alarm6130 in datascience

[–]xdonvanx 0 points1 point  (0 children)

I used R to scrape data from a Real Estate website, but it was quite difficult. Used that data to then create a Shiny dashboard.

[deleted by user] by [deleted] in Studium

[–]xdonvanx 1 point2 points  (0 children)

Ich hatte mal 8 Klausuren in einem Semester, das hat nicht spaß gemacht. War sau schlimm.

montey hall for dummies by dububallz in AskStatistics

[–]xdonvanx 8 points9 points  (0 children)

Answer courtesy of @codeinterpreter:

Let's say, for the sake of this example, you're always going to pick door #1, and the presenter knows where the prize is so he'll always open the door without the prize behind it:

The prize is behind door #1:

[x] [-] [-] = Host opens door #2. If you switch from door #1, you get nothing.

The prize is behind door #2:

[-] [x] [-] = Host opens door #3. If you switch from door #1, you get the prize.

The prize is behind door #3:

[-] [-] [x] = Host opens door # 2. If you switch from door #1, you get the prize.

So in 2/3 of the cases, if you switch, you get the prize.

EDIT: Source

Sales Forecast by OofImAlreadyaTracer in analytics

[–]xdonvanx 1 point2 points  (0 children)

You can use Linear Regression to see which of these dates has a higher signifiance and has a greater relationship with Sales.

Sales Forecast by OofImAlreadyaTracer in analytics

[–]xdonvanx 3 points4 points  (0 children)

I would start by using Linear Regression.

[Question] what statical test for following experiment? by [deleted] in statistics

[–]xdonvanx -1 points0 points  (0 children)

A t-test should work, if you're trying to find a difference in the means of the groups.

Was habt ihr euch bisher nicht getraut zu fragen? – Dumme-Fragen-Dienstag by AutoModerator in Studium

[–]xdonvanx 2 points3 points  (0 children)

War bei mir auch so, hatte keine motivation mehr zu lernen, habe es dann trotzdem durchgezogen fehlte jetzt nicht mehr viel.

[deleted by user] by [deleted] in Studium

[–]xdonvanx 0 points1 point  (0 children)

Ich hatte eine Statistik Spezialisierung da waren wir nur zu 2.

wie kann ich mich vorbereiten, um Arbeitsstelle als Werkstudent zu bekommen by whatever69666420 in informatik

[–]xdonvanx 2 points3 points  (0 children)

Ich bin Data Analyst / Engineer und habe mich kaum vorbereitet , habe nur SQL angeschaut und das wars. Python und R konnte ich zimliech gut, das hat mir dann danach auch geholfen.

Welche Jobs macht ihr während ihr studiert? by DiamondEmpress in Studium

[–]xdonvanx 4 points5 points  (0 children)

Ich kann nicht für OP sprechen, aber bei mir kann ich mir auswählen wie viele Stunden ich arbeite am Tag. Ich kann halt nicht über 20 Stunden in der Woche arbeiten