Step 1: Select rows where 'tournament' is 'australian open' or 'wimbledon'.
tournament |
c_1986 |
c_1988 |
c_1989 |
c_1990 |
c_1991 |
c_1992 |
c_1993 |
c_1994 |
c_1995 |
c_1996 |
c_1997 |
c_1998 |
c_1999 |
grand slam tournaments |
grand slam tournaments |
grand slam tournaments |
grand slam tournaments |
grand slam tournaments |
grand slam tournaments |
grand slam tournaments |
grand slam tournaments |
grand slam tournaments |
grand slam tournaments |
grand slam tournaments |
grand slam tournaments |
grand slam tournaments |
grand slam tournaments |
australian open |
a |
3r |
3r |
3r |
a |
qf |
3r |
2r |
1r |
a |
2r |
1r |
1r |
french open |
a |
qf |
qf |
3r |
3r |
qf |
qf |
1r |
qf |
qf |
2r |
3r |
1r |
wimbledon |
a |
sf |
qf |
3r |
qf |
3r |
1r |
2r |
3r |
qf |
3r |
3r |
1r |
us open |
1r |
2r |
3r |
3r |
qf |
a |
3r |
qf |
3r |
2r |
3r |
2r |
1r |
Step 2: Select rows where 'c_1986' is 'a' for both tournaments.
tournament |
c_1986 |
c_1988 |
c_1989 |
c_1990 |
c_1991 |
c_1992 |
c_1993 |
c_1994 |
c_1995 |
c_1996 |
c_1997 |
c_1998 |
c_1999 |
australian open |
a |
3r |
3r |
3r |
a |
qf |
3r |
2r |
1r |
a |
2r |
1r |
1r |
wimbledon |
a |
sf |
qf |
3r |
qf |
3r |
1r |
2r |
3r |
qf |
3r |
3r |
1r |
Step 3: Select rows where 'c_1988' is '3r' for both tournaments.
tournament |
c_1986 |
c_1988 |
c_1989 |
c_1990 |
c_1991 |
c_1992 |
c_1993 |
c_1994 |
c_1995 |
c_1996 |
c_1997 |
c_1998 |
c_1999 |
australian open |
a |
3r |
3r |
3r |
a |
qf |
3r |
2r |
1r |
a |
2r |
1r |
1r |
wimbledon |
a |
sf |
qf |
3r |
qf |
3r |
1r |
2r |
3r |
qf |
3r |
3r |
1r |
Step 4: Select rows where 'c_1989' is '3r' for both tournaments.
tournament |
c_1986 |
c_1988 |
c_1989 |
c_1990 |
c_1991 |
c_1992 |
c_1993 |
c_1994 |
c_1995 |
c_1996 |
c_1997 |
c_1998 |
c_1999 |
australian open |
a |
3r |
3r |
3r |
a |
qf |
3r |
2r |
1r |
a |
2r |
1r |
1r |
Step 5: Select rows where 'c_1990' is '3r' for both tournaments.
tournament |
c_1986 |
c_1988 |
c_1989 |
c_1990 |
c_1991 |
c_1992 |
c_1993 |
c_1994 |
c_1995 |
c_1996 |
c_1997 |
c_1998 |
c_1999 |
australian open |
a |
3r |
3r |
3r |
a |
qf |
3r |
2r |
1r |
a |
2r |
1r |
1r |
Step 6: Select rows where 'c_1991' is 'a' for both tournaments.
tournament |
c_1986 |
c_1988 |
c_1989 |
c_1990 |
c_1991 |
c_1992 |
c_1993 |
c_1994 |
c_1995 |
c_1996 |
c_1997 |
c_1998 |
c_1999 |
australian open |
a |
3r |
3r |
3r |
a |
qf |
3r |
2r |
1r |
a |
2r |
1r |
1r |
Step 7: Select rows where 'c_1992' is 'qf' for both tournaments.
tournament |
c_1986 |
c_1988 |
c_1989 |
c_1990 |
c_1991 |
c_1992 |
c_1993 |
c_1994 |
c_1995 |
c_1996 |
c_1997 |
c_1998 |
c_1999 |
australian open |
a |
3r |
3r |
3r |
a |
qf |
3r |
2r |
1r |
a |
2r |
1r |
1r |
Step 8: Select rows where 'c_1993' is '3r' for both tournaments.
tournament |
c_1986 |
c_1988 |
c_1989 |
c_1990 |
c_1991 |
c_1992 |
c_1993 |
c_1994 |
c_1995 |
c_1996 |
c_1997 |
c_1998 |
c_1999 |
australian open |
a |
3r |
3r |
3r |
a |
qf |
3r |
2r |
1r |
a |
2r |
1r |
1r |
Step 9: Select rows where 'c_1994' is '2r' for both tournaments.
tournament |
c_1986 |
c_1988 |
c_1989 |
c_1990 |
c_1991 |
c_1992 |
c_1993 |
c_1994 |
c_1995 |
c_1996 |
c_1997 |
c_1998 |
c_1999 |
australian open |
a |
3r |
3r |
3r |
a |
qf |
3r |
2r |
1r |
a |
2r |
1r |
1r |
Step 10: Select rows where 'c_1995' is '1r' for both tournaments.
tournament |
c_1986 |
c_1988 |
c_1989 |
c_1990 |
c_1991 |
c_1992 |
c_1993 |
c_1994 |
c_1995 |
c_1996 |
c_1997 |
c_1998 |
c_1999 |
australian open |
a |
3r |
3r |
3r |
a |
qf |
3r |
2r |
1r |
a |
2r |
1r |
1r |
Step 11: 11.
tournament |
c_1986 |
c_1988 |
c_1989 |
c_1990 |
c_1991 |
c_1992 |
c_1993 |
c_1994 |
c_1995 |
c_1996 |
c_1997 |
c_1998 |
c_1999 |
Prediction: