I'm looking for some advice on how best to approach a project I want to start. I have past results of football matches - multiple world leagues - which I want to use to look for trends. In particular, I have a set of rules which I follow such as percentage of both teams to score, clean sheets, over 2.5 goals, wins in last 5 matches.... and so on.

I'm looking at using Pandas to do this, however I could do with some guidance on how best to approach this as I'm newish to Python and Pandas. While I've made attempts to start this, I haven't really got further than creating a dataframe from the csv file I have.

I should point out that the data used has everything I need, however it's just rows of data and some of it I will need to be manipulated to give me percentages.... e.g. I have scores but I need to understand how to look at x amount of matches and create a percentage from that - clean sheets, over 1.5, both teams to score etc.

There's so much information out there when searching and while I'm not afraid to research, I feel that atm, I'm not finding the results I need. it may be how I'm searching because So, any tips on where I should go from that initial creation or even if Pandas is the suggested way would be appreciated :)

In short, I looking for your experience to guide me to the right research material to manipulate the csv file I have with the end result being a new set of data that meets my criteria.

Honestly, if someone comes back and says DYOR but yeah Pandas is the way to go, I'll be happy because at least I know I'm along the right path :)