Python Database Specialist Needed

Status: Closed
Prize: $100
Entries Received: 8
Winner: freelancer18643

Winner

Contest Brief

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.

Recommended Skills

Winner

Post a Contest Like This

Top entries from this contest

freelancer18643 France

0
shaileshmbusines India

0
Yaan1 Israel

0
mzahidhussain607 Pakistan

0
abdallamr Egypt

0
ikhan9985 Pakistan

0
mailtoafaqCEO Pakistan

0
ikhan9985 Pakistan

0

View More Entries

Public Clarification Board

likith1337
- 2 weeks ago
#extended #increaseprize
- 2 weeks ago
1. Contest Holder
  - 2 weeks ago
  I will extended it by a day more
  - 2 weeks ago
EmadOwaida
- 2 weeks ago
Hello #ContestHolder , are you insisting Python solution only ?! do you have any issue if you received Excel Power Query Alternative solution/ Analysis ?
- 2 weeks ago
1. Contest Holder
  - 2 weeks ago
  Python is the requirement. Thanks
  - 2 weeks ago
mailtoafaqCEO
- 2 weeks ago
Please inbox me. I have almost completed your job.
- 2 weeks ago