How to read and save Excel files in Pandas

You might wonder what might be the reason for an Excel user to take recourse to Pandas at all.¬†It is not difficult to find one. For example, Excel is at a loss when dealing with large datasets, those exceeding one million rows. With Pandas, you can easily perform an introductory analysis of a large file, get statistics for the entire piece, and divide it into smaller chunks of data you consider to be of particular importance in case you’d like to perform some additional operations in Excel.

Continue reading “How to read and save Excel files in Pandas”

Seaborn violin plot for data exploration

Violin plot stands among the less popular visualisation techniques, largely because of its quite ambiguous character. Just like pie chart, it does not give definite numbers, but provides visual representation of possible trends in data, which aids subsequent in-depth analysis of the corpus. Because of that, violin plots are perfect tools for exploratory data analysis, preceding formation of hypotheses and analysis proper.

Continue reading “Seaborn violin plot for data exploration”