Python Database Specialist Needed

  • Statusi: Closed
  • Çmimi: $100
  • Kandidaturat e marra: 8
  • Fituesi: freelancer18643

Përmbledhja e konkursit

There will be additional $50 for any who completes this project fully.
The aim of this project is to compare three types of databases(Any relational database, mongoBD and Neo4J) in terms design approach, implementation, query composition, and performance.
The data is about texas hold em poker game

The stages of the project are
1. Look at the details of the data
2. Come up with an ER diagram and a relational schema for the data
3. Create a database in any relational db and tables
4. Create a python script to read the txt files and populate the db
5. Test the queries
6. Populate the other(mongodb and neo4j) databases and test the queries
Then test the queries below on the databases

QUERIES
1. Separate players by their style of play/Group players with a similar style of play together. Do your best to answer this question using your Neo4j data model.
2. How often do players win in a particular position (relative to the dealer)? In other words, for each hand, consider the order of players starting from the player who is the small blind and ending with the dealer[P1 (SB), P2(BB), P3, ... Pn(Dealer)] (where N can be 8, 7, 6, 5 -- let's not consider games with less than 5 players). Then count how often players in the P1 position end up winning, then P2, and so on until Dealer. Construct a bar chart or something similar to present this information. Again do your best to answer some version of this question.
3. What are the ten top largest pots (amount of money put in a single hand -- or in other words, the amount that the winners of the hand get)? List also which cards won each of these pots.
4. Top 9 winning card combinations by percent used. E.g., the most common winning hand is two-pairs – used in 33% of all winning hands, … (I just made this up, but you get the point).
5. Who won the most money in 2023?
6. What player(s) won the longest game(s) (the most hands)?
7. Who had the “biggest comeback” – i.e. the winner of the tournament who had the least money at some point?
8. Which player(s) has the most aggressive style of betting (largest average bet)?
9. Identify the combinations/cards that win the most. Per player?
10. Which Tournament had the most money exchange hands (total of bets lost)?


The deliverables will include a an er-diagram for the relational db and a schema for the databases, a python program to populate the 3 databases and the 10 queries given.

Aftësi të rekomanduara

Winner
Konkurs i Cilёsuar
Posto një konkurs si ky

Punimet mё tё mira nga ky konkurs

Shiko mё shumё vepra

Këndi publik i sqarimeve

  • likith1337
    likith1337
    • 2 javё më parë

    #extended #increaseprize

    • 2 javё më parë
    1. Kwaku92
      Krijuesi i Konkursit
      • 2 javё më parë

      I will extended it by a day more

      • 2 javё më parë
  • EmadOwaida
    EmadOwaida
    • 2 javё më parë

    Hello #ContestHolder , are you insisting Python solution only ?! do you have any issue if you received Excel Power Query Alternative solution/ Analysis ?

    • 2 javё më parë
    1. Kwaku92
      Krijuesi i Konkursit
      • 2 javё më parë

      Python is the requirement. Thanks

      • 2 javё më parë
  • mailtoafaqCEO
    mailtoafaqCEO
    • 2 javё më parë

    Please inbox me. I have almost completed your job.

    • 2 javё më parë

Shfaq më shumë komente

Si të fillosh me konkurset

  • Posto konkursin

    Posto konkursin Shpejt dhe thjeshtë

  • Merr shumë propozime

    Merr shumë propozime Nga e gjithë bota

  • Zgjidh kandidaturën më të mirë

    Zgjidh kandidaturën më të mirë Shkarko dokumentet - E thjeshtë!

Postoni një konkurs tani! ose bashkohu me ne sot!