Is it a thing to convert a messy spreadsheet into a small relational database for ease of use? Or would you use other cleaning/tidying techniques? Newbie here, advice very welcome!

Hi guys,

Newbie here, sorry if my questions are basic or don't make sense. I'll try to be as clear as I can.

I'm working on a very large, very messy datasheet for a college project in basic DA, and had the thought to convert it into a much more ordered SQL database for ease of use. The dataset I am using is from Kaggle, in case anyone wants to look: https://www.kaggle.com/pralabhpoudel/world-energy-consumption (It's not mine, I just picked it out …

advice database datascience small spreadsheet