RPS Competition Games Info

Games played by different agents

@kaggle.alexrebull_rps_competition_games_info

Table List

1 table(9.51 MB)

Rps

@kaggle.alexrebull_rps_competition_games_info.rps

9.51 MB
3816065 rows
29 columns

player1 Player1	player2 Player2	result Result	game Game	p1finalscore P1FinalScore	p2finalscore P2FinalScore	rounds Rounds	movement1 Movement1	movement2 Movement2	reward1 Reward1	reward2 Reward2	player1currrank Player1CurrRank	player2currrank Player2CurrRank	player1currscore Player1CurrScore	player2currscore Player2CurrScore	player1totsubmit Player1TotSubmit	player2totsubmit Player2TotSubmit	player1lastact Player1lastAct	player2lastact Player2lastAct	p1updatescore P1UpdateScore	p1updateconfidence P1UpdateConfidence	p1gamereward P1GameReward	p2updatescore P2UpdateScore	p2updateconfidence P2UpdateConfidence	p2gamereward P2GameReward
John TerMaat	John TerMaat	Loser	Game 1	-54	54	round: 0					1	1	1247.6	1247.6	28	28	1d	1d	600	200	-54	600	200	54
John TerMaat	John TerMaat	Loser	Game 1	-54	54	round: 1	1	1			1	1	1247.6	1247.6	28	28	1d	1d	600	200	-54	600	200	54
John TerMaat	John TerMaat	Loser	Game 1	-54	54	round: 2	2	1	1	-1	1	1	1247.6	1247.6	28	28	1d	1d	600	200	-54	600	200	54
John TerMaat	John TerMaat	Loser	Game 1	-54	54	round: 3		1			1	1	1247.6	1247.6	28	28	1d	1d	600	200	-54	600	200	54
John TerMaat	John TerMaat	Loser	Game 1	-54	54	round: 4	1		1	-1	1	1	1247.6	1247.6	28	28	1d	1d	600	200	-54	600	200	54
John TerMaat	John TerMaat	Loser	Game 1	-54	54	round: 5	1		2	-2	1	1	1247.6	1247.6	28	28	1d	1d	600	200	-54	600	200	54
John TerMaat	John TerMaat	Loser	Game 1	-54	54	round: 6			2	-2	1	1	1247.6	1247.6	28	28	1d	1d	600	200	-54	600	200	54
John TerMaat	John TerMaat	Loser	Game 1	-54	54	round: 7	2	1	3	-3	1	1	1247.6	1247.6	28	28	1d	1d	600	200	-54	600	200	54
John TerMaat	John TerMaat	Loser	Game 1	-54	54	round: 8	1	1	3	-3	1	1	1247.6	1247.6	28	28	1d	1d	600	200	-54	600	200	54
John TerMaat	John TerMaat	Loser	Game 1	-54	54	round: 9		1	2	-2	1	1	1247.6	1247.6	28	28	1d	1d	600	200	-54	600	200	54


CREATE TABLE rps (
  "player1" VARCHAR,
  "player2" VARCHAR,
  "result" VARCHAR,
  "game" VARCHAR,
  "p1finalscore" DOUBLE,
  "p2finalscore" DOUBLE,
  "rounds" VARCHAR,
  "movement1" DOUBLE,
  "movement2" DOUBLE,
  "reward1" DOUBLE,
  "reward2" DOUBLE,
  "player1currrank" BIGINT,
  "player2currrank" BIGINT,
  "player1currscore" DOUBLE,
  "player2currscore" DOUBLE,
  "player1totsubmit" BIGINT,
  "player2totsubmit" BIGINT,
  "player1lastact" VARCHAR,
  "player2lastact" VARCHAR,
  "p1iniscore" DOUBLE,
  "p1iniconfidence" DOUBLE,
  "p1updatescore" DOUBLE,
  "p1updateconfidence" DOUBLE,
  "p1gamereward" DOUBLE,
  "p2iniscore" DOUBLE,
  "p2iniconfidence" DOUBLE,
  "p2updatescore" DOUBLE,
  "p2updateconfidence" DOUBLE,
  "p2gamereward" DOUBLE
);