---

quati: A python Quick Actions Toolkit for data engeneering

What is it?

quati provides dynamic functions aimed at data engineering, offering a wide range of collections to accelerate development. It has a comprehensive and flexible ecosystem of tools, libraries, and community resources, allowing data engineers to easily build and deploy applications.

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 pandas does well:

• norm_str_num_values(): Converts string-based number values to their numerical equivalents
• norm_rename_columns(): Renames DataFrame columns based on a normalization function
• sync_dtypes_with_table(): Synchronize the data types of a Pandas DataFrame with a BigQuery table's schema
• quick_query(): Executes a BigQuery SQL query and returns the result as a Pandas DataFrame
• gsheets_get_worksheet(): Import a worksheet object from gsheets
• gsheets_get_worksheet_df(): Import a worksheet object from gsheets as a pandas dataframe
• gsheets_dedup(): Returns dataframe where the column passed as parameter is considered the core set for duplicate data row remover
• gsheets_worksheet_next_available_row(): Return the ID of the next cell into which data can be entered
• gsheets_update(): Update a Google Sheets spreadsheet from a reference column
• send_email(): Send an email (Types: error, tip, note, important or warning) with main info about it
• delete_file(): Deletes any specified file
• rename_file(): Renames a file
• search_file(): Searches for the existence of a file
• progress_bar(): Waits for the specified number of seconds with an optional progress bar
• get_system_info(): Retrieves system information using the 'uname -a' command
• start_browser(): Initialize a Chrome browser using Selenium -->

• import_cookies(): Import cookies to browser
• check_element(): Function to check if an element exists on a web page based on the provided XPath
• esc_or_click(): Function to either press the ESC key or click on an element on a web page

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