A B C D E F G H I J K L M N O P Q R S T U V W X Y Z

How to automate manual data validation using Python?

Best Answers

Like already suggested , pandas is way to go. If you are use to operate on “tabular” data, then pandas data frames will be quite easy to grasp. read more

I take raw data from source DB tables and do manual calculations on it using excel if needed. These manual calculations are on same lines of business logic. Finally I show the resulting numbers from my manual or excel computation and match it with what application shows for the same time frame. read more

Jupyter Notebook will nicely render your pandas data frames and when you need to actually plot your data then you can use matplotlib. Personally I favor learning by example, so I would suggest using one of many cookbooks you can find on github: jvns/pandas-cookbook . read more

For example, lets say one of the function in module is createUser(user) which accepts a python dictionary as argument. This dictionary contains user information to save in the database. I want to create an automated validation routine which checks that the dictionary structure matches the database structure. read more

Encyclopedia Research

Related Facts