2 Dashboards + SQL Server + Shiny + R + Python

2 Dashboards + SQL Server + Shiny + R + Python

Requirements

1 dashboard in R + Shiny

1 dashboard in Python

You will send a zip with [login to view URL] that includes instructions. Setup only. No other docs requires.

zip will include code

2 tabs in chrome browser

Tab 1: Shiny + R dashboard

Tab 2: Python dashboard

Exact same Roulette simulation in both R and Python

2 Chrome tabs

Roulette simulation - Red/Black

Radio Button:

- 0

- 0 and 00

These are the green spaces on a roulette wheel.

Simulation must save results in SQL Server tables.

Tables:

Simulation

SimulationID

Number Char(2) so it can save 1-36 0 and 00

Red Bit

WinAmount Int (+ when red, - when black)

Bankroll

Use standard red black numbers where 0 and 00 are green.

Red: 1,3,5…12,14…23,25… see the image below

Black: 2,4,6…17,20…29…

[login to view URL]

Simulation dashboard must work with radio button:

-0

-0 and 00

Inputs for R+Shiny and Python dashboards:

Starting bankroll:

Default to 2,000

Starting bet:

Default to 5

When lose, double your bet.

Round 1 start at $5

5 L

10 L

20 L

40 L

80 W

When won 80, profited 5 total

Now bankroll is 2005

Now start again at 5.

This will be called Round 2

Save the results at each step.

Also save the results of the total simulation including outputs

Simulation SQL Server Table

SimulationID INT

(Inputs)

StartingBet INT

BankrollStart INT

BankrollEnd INT

Simulations INT

SimulationsBust INT = start at 1… when your bankroll = 0 because you busted out, save it here.

CreatedDate DateTime

Simulations need to include charts or graphs that shows the bankroll going up, then down, then up…

When bankroll is 0, stop the simulation and run the next.

After 25 simulations stop. Simulations text box defaulted to 25.

After 10 rounds, stop. Input: Rounds text box defaulted to 10

You should have 25 records in the simulations table. Bankroll restarts at 2,000 and minute bet resets to 5 for each simulation.

Inputs are exactly the same on both Chrome tabs.

Must use a good random number generator.

Generate numbers -1 through 36

-1 == 00

0 == 0

1-36 = #

Simulations should prove that a wheel with 0 and 00 will go bust = faster. Wheel with only 0 (European roulette) should last longer before busting out = bankroll of 0.

Bet size cannot exceed bankroll. The last spin should be all in.

Only start simulations when inputs are correct (no letters in input fields) … and user clicks on [Start Simulation] in chrome tabs.

Budget $100 per tab = $200

Milestones will not be released until code is tested and working correctly.

Python Lenguaje de Programación R Machine Learning (ML) Ciencia de datos

Nº del proyecto: #31844354

Sobre el proyecto