Final Exam: Dynamic Data Handling with Python

WHAT YOU WILL LEARN

• 

  Insert data into views
  

  perform various import and export operations on csv, tsv, and txt files.
  

  perform various grouping operations on the data in a table
  

  perform various update and replace operations on petl data tables by defining functions to perform transformations
  

  install petl and create a basic petl data table out of toy data
  

  create a table in sqlite and read it into petl using sqlalchemy and sqlite3
  

  identify the different options available to stream large volumes of data in an http response
  

  submit data to a remote server using a post request with httpx
  

  map fields in a petl table to transformation based on functions
  

  create and invoke stored procedures
  

  use the httpx asynclient to download a set of files asynchronously
  

  create and use a sql primary key constraint with autoincrement
  

  get data from ms excel and perform basic operations on the data
  

  insert and edit columns and rows in petl data tables
  

  use the fetchmany() function to retrieve the output of a select query
  

  recognize when a redirect has taken place upon submitting an http request
  

  implement insert and delete operations
  

  recall the types of exceptions that can be encountered when sending and processing requests with httpx
  

  install sqlalchemy and connect to mysql
  

  query data using object relational mapping
  

  configure an httpx.cookies instance to send a collection of properties to a remote server
  

  implement check constraints
  

  read in data from the serialized pickle and xml file formats
  

  create tables using object relational mapping
  

  work with transaction aborts
  

  define and submit a post request containing json and binary data
  

  insert rows into a table
  

  read json data, perform various operations, and export it to a persistent format
  

  limit the amount of time your app spends waiting to get served a response to an http request using timeouts
  

  identify when a redirect has taken place upon submitting an http request
• 

  create a table and insert rows into it
  

  recognize the types of exceptions that can be encountered when sending and processing requests with httpx
  

  install the latest available version of httpx on your system
  

  explore different ways to use logical operators for querying data
  

  implement an httpx.cookies instance to send a collection of properties to a remote server
  

  use triggers to automate operations
  

  implement slicing, dicing, and merging operations on petl data tables
  

  use the aggregate function to calculate aggregate statistics for a field in a table
  

  perform sql like equi-joins on petl data tables
  

  perform insert and delete operations
  

  create sql indexes on tables
  

  add a foreign key constraint between tables
  

  retrieve information about a remote resource using a head request
  

  implement split operations on data stored within petl tables
  

  use the facet petl function to define filters on specific fields in a table
  

  recognize the messages conveyed in the different status codes sent in an http response
  

  download a set of files sequentially using httpx
  

  implement specialized types of joins such as anti joins and cross joins
  

  drop a table, recreate it, and insert rows into it
  

  execute alter operations to add constraints and indices to tables
  

  analyze the common and distinct values in two tables using various petl functions
  

  insert and edit rows and columns in petl data tables
  

  perform joins based on overlapping intervals rather than absolute values
  

  automate operations using triggers
  

  install sqlalchemy and connect to mysql
  

  use slicing, dicing, and merging operations on petl data tables
  

  use an httpx.cookies instance to send a collection of properties to a remote server
  

  submit http get requests with one or more parameters using httpx
  

  make use of the rowreduce() function to reduce rows and compute aggregate statistics
  

  calculate aggregate statistics for a field in a table using the aggregate function