Operations with petl: Basic Data Transformations

Software development often requires manipulation of data that has been extracted from different data sources to make it compatible with the users specifications and requirements. petls data transformation features can help achieve this. In this course youll investigate fundamental data transformations that can be performed using the petl library. Youll demonstrate how to load data into a petl table filter columns and combine multiple tables using different forms of concatenation operations. Next youll outline how to convert data in a petl table into a form that is compatible with your requirements. This includes transforming strings to numbers applying calculations to numeric fields and replacing specific values in the table. Lastly youll explore ways to filter content in petl tables using the facet() function and different select operations.