I’d like to share some valuable tips on how you can greatly enhance your data curation skills for the purpose of visualization. Let’s begin with the example of processing RBI data for weekly Foreign Exchange Reserves. When you download the file, it typically appears like this:
The primary challenge in handling this data sheet is its header structure, which spans two rows and includes merged cells. Consequently, if you were to simply copy and paste the data onto a different sheet, it might end up looking like this:
