Pandas is a great library, I probably don't need to spend much or any time telling people that, but it's a great library for a number of reasons and not just for data science work.
I've been needing to extract data from some pretty odd structures lately, so to get up and running and try out some ideas I've fallen back onto Python. It doesn't deliver the greatest performance of all the languages but it's easy to get up and running and trying things out quickly. In this particular case the file I was reading needed lines to be merged back together but not in an obvious order, so the first item on line 2 would actually need to be the first item on line 1 and so on. Not a problem in most languages and Python let me deal with this pretty quickly. So once I had all of the data back I wanted to try some further things out, output the data so I could read it and use a couple of formats for different target choices.
This is where Pandas came in, once the data was back into a tabular structure loading it into a Pandas DataFrame was pretty easy. Needing to strip out some comma's from some numbers and change to types from string to floats? Again, a couple of lines of code and it was done. Finally, outputting the data to a few formats? Well, Pandas supports writing out to CSV, Excel (including configuring freeze panes) and Parquet amongst others.
And when I needed to pick up the data elsewhere, being able to use the describe and info methods on the DataFrame allowed me to quickly check things like data types, nullability of columns etc...
None of this is cutting edge, but sometimes just having a few libraries in your tool-belt to call on can free up enough time to let you focus on the things which matter.
Incidentally, as I was working on this in Visual Studio Code (for which I am an unashamed advocate) and opening up the CSV files to inspect I came across the Excel Viewer extension which is a neat little extension that allows you to view CSV and Excel data directly in Visual Studio Code in a tabular view. Again, it's just having those small utilities to hand which can make a lot of different to your day.