Data Analytics and Video Tutorials
Use python to help format and present data within excel.
So you have an Excel file that has hundreds or maybe thousands of records, but you want to convert it to an XML file, and have each row as a separate file? This can be achieved very easily using Python, in three easy steps. First of all, what is XML? XML stands for “extensible markup…
Read More “How to Create Multiple XML Files From Excel With Python” »
Are you working on a data analytics project where you need to feed your data to a location that is able to process an XML file? The ability to get your data into a structured format like XML has many benefits: (A) You can transfer the data to a web service for processing. (B) Multiple…
Read More “How to Create an XML file from Excel using Python” »
You may be working on automating some exports to Excel using Python to compare files or just pure and simple adding formulas to an Excel file before you open it up. Here we explain adding formulas to your Excel output using Numpy or adding the calculations to specific cells in the output. Adding formulas to…
So you are working on a number of different data analytics projects, and as part of some of them, you are bringing data in from a CSV file. One area you may want to look at is How to Compare Column Headers in CSV to a List in Python, but that could be coupled with…
Read More “How to count the no of rows and columns in a CSV file” »
Are you using Microsoft Excel in conjunction with Python for your data analytics projects, but have a need to automate certain tasks? In this blog post we will take you through how to remove formulas in a cell , and replace them with their returned values. This is achieved through using xlwings, a very powerful…
Read More “how to copy/paste special a range of cells with xlwings” »
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…