---

quati: A python Quick Actions Toolkit for data engeneering

What is it?

quati is a multifaceted utility framework featuring a suite of high-performance functions engineered to streamline software development and operational automation. It encompasses a robust and adaptable infrastructure of modular tools, specialized libraries, and technical assets, empowering professionals to architect, implement, and orchestrate complex applications with heightened precision and reduced time-to-market.

Table of Contents

• What is it?
• Main Features
• Where to get it / Install
• Documentation
• License
• Dependencies

Main Features

Here are just a few of the things that quati does well:

⠀⠀convert_magnitude_string(): Transforms string-based magnitude suffixes (K, M, B) into numerical integers
⠀⠀format_column_header(): Normalizes DataFrame column names by handling special characters and casing
⠀⠀sync_dataframe_to_bq_schema(): Aligns Pandas DataFrame data types with a specific BigQuery table schema
⠀⠀execute_bq_fetch(): Runs a BigQuery SQL query and returns the results as a Pandas DataFrame
⠀⠀acquire_gsheet_access(): Authorizes and retrieves a Google Sheets worksheet object
⠀⠀retrieve_gsheet_as_df(): Imports Google Sheets data directly into a Pandas DataFrame
⠀⠀remove_gsheet_duplicates(): Deduplicates sheet rows based on specific columns and updates the source
⠀⠀locate_next_empty_cell(): Identifies the next available cell ID for data insertion in a column
⠀⠀push_df_to_gsheet(): Updates a worksheet using a DataFrame starting from a reference pivot cell
⠀⠀Qmail.send_email_msg(): Sends structured HTML alerts (Types: error, warning, note, tip, important) with attachment support
⠀⠀erase_file(): Removes a specified file from the file system
⠀⠀modify_file_name(): Renames an existing file based on path and prefix
⠀⠀locate_and_verify_file(): Searches for a file and validates it against a minimum size threshold
⠀⠀display_timer(): Implements a wait period with an optional visual progress bar
⠀⠀fetch_host_details(): Extracts detailed system architecture and kernel information
⠀⠀launch_navigator(): Initializes a customized Chrome WebDriver instance
⠀⠀save_session_cookies(): Exports active browser session cookies to a local file
⠀⠀load_session_cookies(): Injects saved cookies into the browser to bypass authentication
⠀⠀is_node_present(): Validates the existence of a web element using XPath
⠀⠀dismiss_popup(): Automates popup closure via ESC key or targeted element clicks

Where to get it / Install

The source code is currently hosted on GitHub at: https://github.com/quati-dev/quati

[!WARNING] It's essential to use Python 3.10 version

• PyPI

   # PyPI
   pip install quati
  

• GitHub

   # or GitHub
   pip install git+https://github.com/quati-dev/quati.git
  

Documentation

• Documentation

License

• MIT

Dependencies

• NumPy | Pandas | Selenium | gspread

See the full installation instructions for minimum supported versions of required, recommended and optional dependencies.

⇧ Go to Top