semvec/pypi-packages huggingface dataset:
yoda-powers 1.0.1
Use it to import very handy functions.
Keywords: python

=====================================
Welcome to Yoda powers documentation!
=====================================

.. image:: https://raw.githubusercontent.com/sravel/yoda-powers/master/docs/source/SupplementaryFiles/yoda.png
    :target: https://raw.githubusercontent.com/sravel/yoda-powers/master/docs/source/SupplementaryFiles/yoda.png
    :alt: yoda Logo

|PythonVersions| |PypiPackage|


.. contents:: Table of Contents
    :depth: 2


About this package
==================

Use it to import very handy functions.

**Documentation available at :** `<https://yoda-powers.readthedocs.io/en/latest>`_


Install
=======

Global install
--------------

To compile and install yoda_powers you should do this::

    # for all users (requiring super-user rights)
    sudo pip install yoda_powers
    # for the current user only
    pip install yoda_powers --user

Install for a specific version of python for example python3.7::

    # for all users (requiring super-user rights)
    sudo python3.7 -m pip install yoda_powers
    # for the current user only
    python3.7 -m pip install yoda_powers --user

Developing version
------------------

If you want to use an **unofficial version** of the ``yoda_powers`` module, you need to work from
a clone of this ``git`` repository.
following actions:

1. Clone from github ::

    git clone https://github.com/sravel/yoda-powers.git

2. Go in the cloned directory ::

    cd yoda_powers

3. Install in editable mode ::

    pip install -e . --user

.. |PythonVersions| image:: https://img.shields.io/badge/python-3.7+-blue.svg
    :target: https://www.python.org/downloads
    :alt: Python /3.7+

.. |PypiPackage| image:: https://badge.fury.io/py/yoda-powers.svg
    :target: https://pypi.org/project/yoda-powers
    :alt: PyPi package
data-tap 0.0.7
A python wrapper that connects to multiple 3rd party resources for AWS.
Requires Python: >=3
Keywords: aws,s3,google,google analytics,google search console,data,pipeline

# data-tap

A python wrapper that connects to multiple 3rd party resources for AWS.

[![Python Tests](https://github.com/DirksCGM/data-tap/actions/workflows/tests.yml/badge.svg)](https://github.com/DirksCGM/data-tap/actions/workflows/tests.yml)
[![Publish PyPi Package](https://github.com/DirksCGM/data-tap/actions/workflows/publish.yml/badge.svg)](https://github.com/DirksCGM/data-tap/actions/workflows/publish.yml)

# Google Analytics

The GoogleAnalyticsTap connects to the v4 GA api and returns data from Google Analytics.

```yaml
batch_dates: 'bool. enables batching of queries by date'
start_date: 'str. "yesterday", "today",  "3_days_ago" or "2020-01-01" etc...'
end_date: 'str. "yesterday", "today",  "3_days_ago" or "2020-01-01" etc...'
metrics:
  - expression: 'str. metric name'
dimensions:
  - name: 'str. dimension name'
pageSize: 'int. page size, defaults to 1000'
view_ids:
  - 'str. a list of view to iterate over'
```

```python
from datetime import datetime

import pandas as pd

from data_tap.google_tap.google_analytics import GoogleAnalyticsTap

ga_tap = GoogleAnalyticsTap(
    config_file='',
    creds_file='',
    auth_method='',
    service_account_email=''
)

dfA = pd.DataFrame()
for report in ga_tap.run_query():
    dfB = pd.DataFrame(report)
    dfA = dfA.append(dfB, ignore_index=True)

dfA.to_json(f"{datetime.utcnow()}.json")
```

# Google Search Console

The GoogleSearchConsoleTap connects to the v3 GSC api and returns data from Google Search Console.
Functionality to generate an authentication token is available.

```yaml
batch_dates: 'bool. enables batching of queries by date'
start_date: 'str. "yesterday", "today",  "3_days_ago" or "2020-01-01" etc...'
end_date: 'str. "yesterday", "today",  "3_days_ago" or "2020-01-01" etc...'
dimensions:
  - 'str. dimension name'
metrics:
  - 'str. metric name'
search_types:
  - 'str. available gsc search types'
site_urls:
  - 'str. website urls in question'
row_limit: 'int. max row limit is 25000'
```

```python
from datetime import datetime

import pandas as pd

from data_tap.google_tap.google_seach_console import GoogleSeachConsoleTap

gsc_tap = GoogleSeachConsoleTap(
    config_file='',
    creds_file='.pickle'
)

dfA = pd.DataFrame()
for report in gsc_tap.run_query():
    dfB = pd.DataFrame(report)
    dfA = dfA.append(dfB, ignore_index=True)

dfA.to_json(f"{datetime.utcnow()}.json")
```
pyvba 0.6.0
Data mine and write scrips for VBA applications on Windows.
Requires Python: >=3.7

# pyvba
![PyPI - Python Version](https://img.shields.io/pypi/pyversions/pyvba)
[![PyPI](https://img.shields.io/pypi/v/pyvba)](https://pypi.org/project/pyvba/)
[![GitHub](https://img.shields.io/github/license/TheEric960/pyvba)](https://github.com/TheEric960/pyvba)

The pyvba package was designed to gather data from VBA-based applications (e.g. Microsoft Excel, CATIA, etc.). It may also be used to assist programming VBA macro scripts using the Python language. 

## Getting Started
Install the Python Package:
```cmd
pip install pyvba
```

To export data from a VBA program:
```python
import pyvba

catia = pyvba.Browser("CATIA.Application")
active_document = catia.ActiveDocument

exporter = pyvba.XMLExport(active_document)
exporter.save("output", r"C:\Documents")
```

The current supported output types are XML and JSON formats. Both support a form the imitates the VBA object tree as well as a dictionary form where each unique object is in the outermost layer.

Example Output:
> Note: `BrowserObject` denotes an object defined elsewhere in the output.
```JSON
{ "MainBody": [
	{ "Pad": [
		{ "Shapes": [
			{ "DirectionOrientation": 0 },
			{ "DirectionType": 0 },
			{ "FirstLimit": "BrowserObject" },
			{ "IsSymmetric": false },
			{ "IsThin": false },
			{ "MergeEnd": false },
			{ "Name": "Pad.1" },
			{ "NeutralFiber": false },
			{ "SecondLimit": "BrowserObject" },
			{ "Sketch": "BrowserObject" }
		]},
		{ "Shapes": [
			{ "DirectionOrientation": 0 },
			{ "DirectionType": 0 },
			{ "FirstLimit": "BrowserObject" },
			{ "IsSymmetric": false },
			{ "IsThin": false },
			{ "MergeEnd": false },
			{ "Name": "Pad.1" },
			{ "NeutralFiber": false },
			{ "SecondLimit": "BrowserObject" },
			{ "Sketch": "BrowserObject" }
		]},
		{ "Shapes": [
			{ "DirectionOrientation": 0 },
			{ "DirectionType": 0 },
			{ "FirstLimit": "BrowserObject" },
			{ "IsSymmetric": false },
			{ "IsThin": false },
			{ "MergeEnd": false },
			{ "Name": "Pad.3" },
			{ "NeutralFiber": false },
			{ "SecondLimit": "BrowserObject" },
			{ "Sketch": "BrowserObject" }
		]}
	]}
]}
```


## Developer Notes
This package is in beta. Therefore, there are still some problematic bugs and issues that cause errors in certain applications. Contributors are welcome! The project is [hosted on GitHub](https://github.com/TheEric960/pyvba). Report any issues at [the issue tracker](https://github.com/TheEric960/pyvba/issues), but please check to see if the issue already exists!