Logic for position "sides" in game_lineups

[deantmcg]

Currently for game_lineups, we can tell the formation by joining to games. I'm wondering is there currently any way of telling which "side" a player played on if there are multiple players in this position on the team? I'm hoping to plot the results on an actual lineup graphic

Example:
In 4-4-2 we will have two Centre-Backs, I want to be able to tell which game_lineups record was LCB and which was RCB

[dcaribou]

Does joining to the appearances, then the club help?

[deantmcg]

No unfortunately not, by side I mean which player played which side of the position. Like in a midfield 3, we have a left centre mid, central centre mid and right centre mid. Not sure it's possible at the moment

[dcaribou]

Ah I see what you mean. No, I don’t think it’s possible to tell from the dataset at the moment. Looking at how tfmkt provides this data, I would say it's not impossible to extract though.

I'll move this to an issue. I can be a nice addition for the future.