Data Analytics and Video Tutorials
Presenting data in rows and columns on a computer screen.
Taking it further with a python excel chart. We have created some video content here using Python with Excel that illustrates the different ways you can leverage Python to Data cleanse Find unwanted characters And see if the file is empty before import! What this video is giving as output Here we are looking to introduce…
Read More “Python Tutorial: How to create charts in Excel” »
Validating cells in Excel quickly – how to do it easily!Are you working with large spreadsheets and looking to quickly at data validation exercise to save you time? The aim would be to run your code and test it against some predefined rules you or your data analyst would have written to make sure it…
This import will not cost you anything except running some code!The need to productively have an all in one solution to manage your data as your code has become more critical as volumes of data become larger. Do you, as a data analyst, therefore, need to send your data into an excel file? Previously we…