Final Exam: Dynamic Data Handling with Python
Python | Intermediate
- 1 video | 32s
- Includes Assessment
- Earns a Badge
Final Exam: Dynamic Data Handling with Python will test your knowledge and application of the topics presented throughout the Dynamic Data Handling with Python track of the Skillsoft Aspire Pythonista to Python Master Journey.
WHAT YOU WILL LEARN
Insert data into viewsperform various import and export operations on csv, tsv, and txt files.perform various grouping operations on the data in a tableperform various update and replace operations on petl data tables by defining functions to perform transformationsinstall petl and create a basic petl data table out of toy datacreate a table in sqlite and read it into petl using sqlalchemy and sqlite3identify the different options available to stream large volumes of data in an http responsesubmit data to a remote server using a post request with httpxmap fields in a petl table to transformation based on functionscreate and invoke stored proceduresuse the httpx asynclient to download a set of files asynchronouslycreate and use a sql primary key constraint with autoincrementget data from ms excel and perform basic operations on the datainsert and edit columns and rows in petl data tablesuse the fetchmany() function to retrieve the output of a select queryrecognize when a redirect has taken place upon submitting an http requestimplement insert and delete operationsrecall the types of exceptions that can be encountered when sending and processing requests with httpxinstall sqlalchemy and connect to mysqlquery data using object relational mappingconfigure an httpx.cookies instance to send a collection of properties to a remote serverimplement check constraintsread in data from the serialized pickle and xml file formatscreate tables using object relational mappingwork with transaction abortsdefine and submit a post request containing json and binary datainsert rows into a tableread json data, perform various operations, and export it to a persistent formatlimit the amount of time your app spends waiting to get served a response to an http request using timeoutsidentify when a redirect has taken place upon submitting an http request
create a table and insert rows into itrecognize the types of exceptions that can be encountered when sending and processing requests with httpxinstall the latest available version of httpx on your systemexplore different ways to use logical operators for querying dataimplement an httpx.cookies instance to send a collection of properties to a remote serveruse triggers to automate operationsimplement slicing, dicing, and merging operations on petl data tablesuse the aggregate function to calculate aggregate statistics for a field in a tableperform sql like equi-joins on petl data tablesperform insert and delete operationscreate sql indexes on tablesadd a foreign key constraint between tablesretrieve information about a remote resource using a head requestimplement split operations on data stored within petl tablesuse the facet petl function to define filters on specific fields in a tablerecognize the messages conveyed in the different status codes sent in an http responsedownload a set of files sequentially using httpximplement specialized types of joins such as anti joins and cross joinsdrop a table, recreate it, and insert rows into itexecute alter operations to add constraints and indices to tablesanalyze the common and distinct values in two tables using various petl functionsinsert and edit rows and columns in petl data tablesperform joins based on overlapping intervals rather than absolute valuesautomate operations using triggersinstall sqlalchemy and connect to mysqluse slicing, dicing, and merging operations on petl data tablesuse an httpx.cookies instance to send a collection of properties to a remote serversubmit http get requests with one or more parameters using httpxmake use of the rowreduce() function to reduce rows and compute aggregate statisticscalculate aggregate statistics for a field in a table using the aggregate function
EARN A DIGITAL BADGE WHEN YOU COMPLETE THIS COURSE
Skillsoft is providing you the opportunity to earn a digital badge upon successful completion on some of our courses, which can be shared on any social network or business platform.Digital badges are yours to keep, forever.