joaoftrodrigues / atpdb-cleanup-and-conversion-to-relational

0 stars 0 forks source link

Decompose Hand #10

Open joaoftrodrigues opened 1 year ago

joaoftrodrigues commented 1 year ago

Description

Hands used by the player are described as main hand and backhand, on same string.

Possible Values

This is a list of values on the database, and not that are the only possible values to exist on tennis.

Right-Handed, Two-Handed Backhand
Right-Handed, Unknown Backhand
null
Right-Handed, One-Handed Backhand
Left-Handed, Two-Handed Backhand
Left-Handed, Unknown Backhand

Objectives

Create a new field for first value (main hand)
Create a new field for second value (backhand)

Obviously, for null, both fields would be null, but while using a non relational database, it can just not be defined.