{
    "info": {
        "author": "Vijay Balasubramaniam",
        "author_email": "vbalasu@gmail.com",
        "bugtrack_url": null,
        "classifiers": [
            "Operating System :: OS Independent",
            "Programming Language :: Python :: 3"
        ],
        "description": "\n# trifacta\n\nTrifacta client that makes it easy to integrate Trifacta into your production and data science workflows\n\n### Usage Scenarios\n- **Jupyter**: Invoke Trifacta jobs from a Jupyter notebook and pass data back and forth between Jupyter and Trifacta\n- **Other Notebooks**: Integrate Trifacta with Azure Databricks, Zepellin or any other notebook-style interface that supports Python\n- **Scripts**: Automate Trifacta jobs and input/output using python scripts that can be easily executed from the command line or called from an external scheduler\n\n### Functionality\nThis library makes it simple to do the following:\n1. Connect to a Trifacta instance\n2. Run a job\n3. Download results to a pandas dataframe OR Download results as text/csv\n4. Upload files to Trifacta\n\nNote that file uploads and downloads are performed using httpfs, and require that port 14000 be opened on the Trifacta server\n\n\n```python\n#!pip install trifacta\nimport trifacta\n```\n\n\n```python\n#Step 1: Connect to Trifacta by providing the URL, username and password\nt = trifacta.Client('https://partnerdemo.trifacta.net', 'userid@mydomain.com', 'mypassword')\n```\n\n#### Get the wrangled dataset id from the URL in the Trifacta UI\nMake sure that you have run the job manually at least once\n![Screenshot_recipe](https://cdn.rawgit.com/vbalasu/trifacta/86890c1f/screenshot_recipe.png)\n\n#### Note the output path (be sure to set it to \"replace\")\n![Run Job](https://cdn.rawgit.com/vbalasu/trifacta/86890c1f/run_job_highlight.png)\n\n\n```python\n#Step 2: Run the job\nt.run_job(14478)\n```\n\n    About to run job\n    {'jobgroupId': 3926, 'jobIds': [7513, 7514], 'reason': 'JobStarted', 'sessionId': 'b9d327f0-8e19-11e8-8feb-9fabf204e996'}\n    2018-07-22 18:43:01.427594 InProgress\n    2018-07-22 18:43:06.791576 Complete\n\n\n\n\n\n    True\n\n\n\n\n```python\n#Step 3a: Get a pandas dataframe with the results\ndf = t.get_dataframe('/trifacta/queryResults/demo@trifacta.com/demo_output.csv')\n```\n\n\n```python\ndf\n```\n\n\n\n\n<div>\n<table border=\"1\" class=\"dataframe\">\n  <thead>\n    <tr style=\"text-align: right;\">\n      <th></th>\n      <th>Neighborhood</th>\n      <th>HouseStyle</th>\n      <th>row_count</th>\n      <th>sum_LotArea</th>\n    </tr>\n  </thead>\n  <tbody>\n    <tr>\n      <th>0</th>\n      <td>NAmes</td>\n      <td>1Story</td>\n      <td>159</td>\n      <td>1589811</td>\n    </tr>\n    <tr>\n      <th>1</th>\n      <td>CollgCr</td>\n      <td>1Story</td>\n      <td>91</td>\n      <td>841644</td>\n    </tr>\n    <tr>\n      <th>2</th>\n      <td>Gilbert</td>\n      <td>2Story</td>\n      <td>60</td>\n      <td>668112</td>\n    </tr>\n    <tr>\n      <th>3</th>\n      <td>Timber</td>\n      <td>1Story</td>\n      <td>23</td>\n      <td>554694</td>\n    </tr>\n    <tr>\n      <th>4</th>\n      <td>CollgCr</td>\n      <td>2Story</td>\n      <td>53</td>\n      <td>546602</td>\n    </tr>\n    <tr>\n      <th>5</th>\n      <td>NridgHt</td>\n      <td>1Story</td>\n      <td>51</td>\n      <td>537687</td>\n    </tr>\n    <tr>\n      <th>6</th>\n      <td>Sawyer</td>\n      <td>1Story</td>\n      <td>53</td>\n      <td>528438</td>\n    </tr>\n    <tr>\n      <th>7</th>\n      <td>Edwards</td>\n      <td>1Story</td>\n      <td>53</td>\n      <td>511296</td>\n    </tr>\n    <tr>\n      <th>8</th>\n      <td>NoRidge</td>\n      <td>2Story</td>\n      <td>33</td>\n      <td>485691</td>\n    </tr>\n    <tr>\n      <th>9</th>\n      <td>NWAmes</td>\n      <td>1Story</td>\n      <td>35</td>\n      <td>403813</td>\n    </tr>\n    <tr>\n      <th>10</th>\n      <td>ClearCr</td>\n      <td>1Story</td>\n      <td>11</td>\n      <td>395797</td>\n    </tr>\n    <tr>\n      <th>11</th>\n      <td>Mitchel</td>\n      <td>1Story</td>\n      <td>32</td>\n      <td>394436</td>\n    </tr>\n    <tr>\n      <th>12</th>\n      <td>Somerst</td>\n      <td>1Story</td>\n      <td>37</td>\n      <td>350820</td>\n    </tr>\n    <tr>\n      <th>13</th>\n      <td>NWAmes</td>\n      <td>2Story</td>\n      <td>29</td>\n      <td>348885</td>\n    </tr>\n    <tr>\n      <th>14</th>\n      <td>Somerst</td>\n      <td>2Story</td>\n      <td>49</td>\n      <td>323495</td>\n    </tr>\n    <tr>\n      <th>15</th>\n      <td>NridgHt</td>\n      <td>2Story</td>\n      <td>26</td>\n      <td>300685</td>\n    </tr>\n    <tr>\n      <th>16</th>\n      <td>OldTown</td>\n      <td>2Story</td>\n      <td>32</td>\n      <td>274465</td>\n    </tr>\n    <tr>\n      <th>17</th>\n      <td>SawyerW</td>\n      <td>1Story</td>\n      <td>28</td>\n      <td>271008</td>\n    </tr>\n    <tr>\n      <th>18</th>\n      <td>OldTown</td>\n      <td>1.5Fin</td>\n      <td>33</td>\n      <td>267283</td>\n    </tr>\n    <tr>\n      <th>19</th>\n      <td>ClearCr</td>\n      <td>1.5Fin</td>\n      <td>6</td>\n      <td>266593</td>\n    </tr>\n    <tr>\n      <th>20</th>\n      <td>Crawfor</td>\n      <td>1Story</td>\n      <td>19</td>\n      <td>260639</td>\n    </tr>\n    <tr>\n      <th>21</th>\n      <td>SawyerW</td>\n      <td>2Story</td>\n      <td>25</td>\n      <td>255102</td>\n    </tr>\n    <tr>\n      <th>22</th>\n      <td>NAmes</td>\n      <td>2Story</td>\n      <td>22</td>\n      <td>249793</td>\n    </tr>\n    <tr>\n      <th>23</th>\n      <td>OldTown</td>\n      <td>1Story</td>\n      <td>33</td>\n      <td>240257</td>\n    </tr>\n    <tr>\n      <th>24</th>\n      <td>Edwards</td>\n      <td>1.5Fin</td>\n      <td>22</td>\n      <td>228970</td>\n    </tr>\n    <tr>\n      <th>25</th>\n      <td>Crawfor</td>\n      <td>2Story</td>\n      <td>20</td>\n      <td>222029</td>\n    </tr>\n    <tr>\n      <th>26</th>\n      <td>NAmes</td>\n      <td>SLvl</td>\n      <td>21</td>\n      <td>221177</td>\n    </tr>\n    <tr>\n      <th>27</th>\n      <td>Edwards</td>\n      <td>2Story</td>\n      <td>14</td>\n      <td>185799</td>\n    </tr>\n    <tr>\n      <th>28</th>\n      <td>Timber</td>\n      <td>1.5Fin</td>\n      <td>2</td>\n      <td>178418</td>\n    </tr>\n    <tr>\n      <th>29</th>\n      <td>BrkSide</td>\n      <td>1.5Fin</td>\n      <td>25</td>\n      <td>172233</td>\n    </tr>\n    <tr>\n      <th>...</th>\n      <td>...</td>\n      <td>...</td>\n      <td>...</td>\n      <td>...</td>\n    </tr>\n    <tr>\n      <th>66</th>\n      <td>CollgCr</td>\n      <td>SLvl</td>\n      <td>3</td>\n      <td>30135</td>\n    </tr>\n    <tr>\n      <th>67</th>\n      <td>BrDale</td>\n      <td>2Story</td>\n      <td>16</td>\n      <td>28816</td>\n    </tr>\n    <tr>\n      <th>68</th>\n      <td>Veenker</td>\n      <td>SLvl</td>\n      <td>2</td>\n      <td>25757</td>\n    </tr>\n    <tr>\n      <th>69</th>\n      <td>NoRidge</td>\n      <td>1.5Fin</td>\n      <td>2</td>\n      <td>25398</td>\n    </tr>\n    <tr>\n      <th>70</th>\n      <td>SawyerW</td>\n      <td>SFoyer</td>\n      <td>3</td>\n      <td>25267</td>\n    </tr>\n    <tr>\n      <th>71</th>\n      <td>CollgCr</td>\n      <td>SFoyer</td>\n      <td>3</td>\n      <td>24491</td>\n    </tr>\n    <tr>\n      <th>72</th>\n      <td>MeadowV</td>\n      <td>2Story</td>\n      <td>8</td>\n      <td>19611</td>\n    </tr>\n    <tr>\n      <th>73</th>\n      <td>NPkVill</td>\n      <td>1Story</td>\n      <td>4</td>\n      <td>17942</td>\n    </tr>\n    <tr>\n      <th>74</th>\n      <td>Veenker</td>\n      <td>2Story</td>\n      <td>1</td>\n      <td>17542</td>\n    </tr>\n    <tr>\n      <th>75</th>\n      <td>NAmes</td>\n      <td>1.5Unf</td>\n      <td>2</td>\n      <td>16827</td>\n    </tr>\n    <tr>\n      <th>76</th>\n      <td>SWISU</td>\n      <td>1Story</td>\n      <td>2</td>\n      <td>14692</td>\n    </tr>\n    <tr>\n      <th>77</th>\n      <td>OldTown</td>\n      <td>SFoyer</td>\n      <td>2</td>\n      <td>14179</td>\n    </tr>\n    <tr>\n      <th>78</th>\n      <td>NWAmes</td>\n      <td>1.5Fin</td>\n      <td>1</td>\n      <td>13837</td>\n    </tr>\n    <tr>\n      <th>79</th>\n      <td>SawyerW</td>\n      <td>SLvl</td>\n      <td>1</td>\n      <td>12800</td>\n    </tr>\n    <tr>\n      <th>80</th>\n      <td>IDOTRR</td>\n      <td>1.5Unf</td>\n      <td>2</td>\n      <td>12449</td>\n    </tr>\n    <tr>\n      <th>81</th>\n      <td>SawyerW</td>\n      <td>1.5Fin</td>\n      <td>1</td>\n      <td>12327</td>\n    </tr>\n    <tr>\n      <th>82</th>\n      <td>Gilbert</td>\n      <td>1.5Fin</td>\n      <td>1</td>\n      <td>12134</td>\n    </tr>\n    <tr>\n      <th>83</th>\n      <td>BrkSide</td>\n      <td>2.5Unf</td>\n      <td>1</td>\n      <td>11888</td>\n    </tr>\n    <tr>\n      <th>84</th>\n      <td>Crawfor</td>\n      <td>2.5Fin</td>\n      <td>1</td>\n      <td>11526</td>\n    </tr>\n    <tr>\n      <th>85</th>\n      <td>NPkVill</td>\n      <td>2Story</td>\n      <td>5</td>\n      <td>11465</td>\n    </tr>\n    <tr>\n      <th>86</th>\n      <td>NWAmes</td>\n      <td>SFoyer</td>\n      <td>1</td>\n      <td>10625</td>\n    </tr>\n    <tr>\n      <th>87</th>\n      <td>Crawfor</td>\n      <td>1.5Unf</td>\n      <td>1</td>\n      <td>10594</td>\n    </tr>\n    <tr>\n      <th>88</th>\n      <td>OldTown</td>\n      <td>1.5Unf</td>\n      <td>2</td>\n      <td>9888</td>\n    </tr>\n    <tr>\n      <th>89</th>\n      <td>MeadowV</td>\n      <td>SFoyer</td>\n      <td>6</td>\n      <td>9853</td>\n    </tr>\n    <tr>\n      <th>90</th>\n      <td>SawyerW</td>\n      <td>1.5Unf</td>\n      <td>1</td>\n      <td>9000</td>\n    </tr>\n    <tr>\n      <th>91</th>\n      <td>MeadowV</td>\n      <td>1Story</td>\n      <td>2</td>\n      <td>8448</td>\n    </tr>\n    <tr>\n      <th>92</th>\n      <td>IDOTRR</td>\n      <td>2.5Unf</td>\n      <td>1</td>\n      <td>7200</td>\n    </tr>\n    <tr>\n      <th>93</th>\n      <td>Crawfor</td>\n      <td>2.5Unf</td>\n      <td>1</td>\n      <td>7128</td>\n    </tr>\n    <tr>\n      <th>94</th>\n      <td>Blueste</td>\n      <td>2Story</td>\n      <td>2</td>\n      <td>3250</td>\n    </tr>\n    <tr>\n      <th>95</th>\n      <td>MeadowV</td>\n      <td>SLvl</td>\n      <td>1</td>\n      <td>1596</td>\n    </tr>\n  </tbody>\n</table>\n<p>96 rows \u00d7 4 columns</p>\n</div>\n\n\n\n\n```python\n#Step 3b: Download results as text/csv\nfile_contents = t.get_file_contents('/trifacta/queryResults/demo@trifacta.com/demo_output.csv')\nwith open('demo_output.csv', 'w') as f:\n    f.write(file_contents)\n```\n\n\n```python\n#Show the first few rows of the CSV file\n!head demo_output.csv\n```\n\n    \"Neighborhood\",\"HouseStyle\",\"row_count\",\"sum_LotArea\"\n    \"NAmes\",\"1Story\",\"159\",\"1589811\"\n    \"CollgCr\",\"1Story\",\"91\",\"841644\"\n    \"Gilbert\",\"2Story\",\"60\",\"668112\"\n    \"Timber\",\"1Story\",\"23\",\"554694\"\n    \"CollgCr\",\"2Story\",\"53\",\"546602\"\n    \"NridgHt\",\"1Story\",\"51\",\"537687\"\n    \"Sawyer\",\"1Story\",\"53\",\"528438\"\n    \"Edwards\",\"1Story\",\"53\",\"511296\"\n    \"NoRidge\",\"2Story\",\"33\",\"485691\"\n\n\n\n```python\n#Step 4: Upload files to Trifacta\nt.put_file_contents('/trifacta/uploads/demo_output.csv', file_contents)\n```\n\n\n\n\n    True\n\n\n\n\n",
        "description_content_type": "text/markdown",
        "docs_url": null,
        "download_url": "",
        "downloads": {
            "last_day": -1,
            "last_month": -1,
            "last_week": -1
        },
        "home_page": "https://github.com/vbalasu/trifacta",
        "keywords": "",
        "license": "",
        "maintainer": "",
        "maintainer_email": "",
        "name": "trifacta",
        "package_url": "https://pypi.org/project/trifacta/",
        "platform": "",
        "project_url": "https://pypi.org/project/trifacta/",
        "project_urls": {
            "Homepage": "https://github.com/vbalasu/trifacta"
        },
        "release_url": "https://pypi.org/project/trifacta/1.0.8/",
        "requires_dist": [
            "requests",
            "pywebhdfs",
            "pandas"
        ],
        "requires_python": "",
        "summary": "Trifacta client",
        "version": "1.0.8"
    },
    "last_serial": 4101303,
    "releases": {
        "1.0.7": [
            {
                "comment_text": "",
                "digests": {
                    "md5": "2ec9ffe2d1637c55085de866ea34c1b8",
                    "sha256": "334220aa5ab1aa41c609db02d9978bdfd63948fbfdc59febbebda57d47c302c1"
                },
                "downloads": -1,
                "filename": "trifacta-1.0.7-py3-none-any.whl",
                "has_sig": false,
                "md5_digest": "2ec9ffe2d1637c55085de866ea34c1b8",
                "packagetype": "bdist_wheel",
                "python_version": "py3",
                "requires_python": null,
                "size": 4566,
                "upload_time": "2018-07-23T13:13:00",
                "url": "https://files.pythonhosted.org/packages/f9/87/407b7869e9e14b1924c913b4b235c48935023c1f2c75dd5ada144df9f706/trifacta-1.0.7-py3-none-any.whl"
            },
            {
                "comment_text": "",
                "digests": {
                    "md5": "5b272bf14532b90f87994d5cbdef8ec7",
                    "sha256": "051d7053fa851ddee8f64afaf600b59b3b0a546b08178505b5fbc2d8fa8a5c4a"
                },
                "downloads": -1,
                "filename": "trifacta-1.0.7.tar.gz",
                "has_sig": false,
                "md5_digest": "5b272bf14532b90f87994d5cbdef8ec7",
                "packagetype": "sdist",
                "python_version": "source",
                "requires_python": null,
                "size": 5539,
                "upload_time": "2018-07-23T13:13:02",
                "url": "https://files.pythonhosted.org/packages/13/f0/efaed66e8532e3ff06efb6571ae3ad0820fd980b0c253e5d14116ab52364/trifacta-1.0.7.tar.gz"
            }
        ],
        "1.0.8": [
            {
                "comment_text": "",
                "digests": {
                    "md5": "92b17ed864e09302f537ddb1b314ccf7",
                    "sha256": "c4d7e920f78f1ff96fe059900e76e06b3d3c90eb4512c72d3fd2cb0fcc4e9820"
                },
                "downloads": -1,
                "filename": "trifacta-1.0.8-py3-none-any.whl",
                "has_sig": false,
                "md5_digest": "92b17ed864e09302f537ddb1b314ccf7",
                "packagetype": "bdist_wheel",
                "python_version": "py3",
                "requires_python": null,
                "size": 4588,
                "upload_time": "2018-07-25T16:45:29",
                "url": "https://files.pythonhosted.org/packages/d0/aa/9eff55839183697ea8b9fdb2fadaf0e0261a082caaf21c7ed40635f65039/trifacta-1.0.8-py3-none-any.whl"
            },
            {
                "comment_text": "",
                "digests": {
                    "md5": "aefa91604d3ca8c78d09112b54f6e1aa",
                    "sha256": "fea24a24adf84eaf151886845bc097bd242c6c4fdc65679c133a4647517d7b2c"
                },
                "downloads": -1,
                "filename": "trifacta-1.0.8.tar.gz",
                "has_sig": false,
                "md5_digest": "aefa91604d3ca8c78d09112b54f6e1aa",
                "packagetype": "sdist",
                "python_version": "source",
                "requires_python": null,
                "size": 5566,
                "upload_time": "2018-07-25T16:45:31",
                "url": "https://files.pythonhosted.org/packages/61/e8/26f6f6890900618c472fe44efb933dc2e3c8400c39833ed42c733c74810b/trifacta-1.0.8.tar.gz"
            }
        ]
    },
    "urls": [
        {
            "comment_text": "",
            "digests": {
                "md5": "92b17ed864e09302f537ddb1b314ccf7",
                "sha256": "c4d7e920f78f1ff96fe059900e76e06b3d3c90eb4512c72d3fd2cb0fcc4e9820"
            },
            "downloads": -1,
            "filename": "trifacta-1.0.8-py3-none-any.whl",
            "has_sig": false,
            "md5_digest": "92b17ed864e09302f537ddb1b314ccf7",
            "packagetype": "bdist_wheel",
            "python_version": "py3",
            "requires_python": null,
            "size": 4588,
            "upload_time": "2018-07-25T16:45:29",
            "url": "https://files.pythonhosted.org/packages/d0/aa/9eff55839183697ea8b9fdb2fadaf0e0261a082caaf21c7ed40635f65039/trifacta-1.0.8-py3-none-any.whl"
        },
        {
            "comment_text": "",
            "digests": {
                "md5": "aefa91604d3ca8c78d09112b54f6e1aa",
                "sha256": "fea24a24adf84eaf151886845bc097bd242c6c4fdc65679c133a4647517d7b2c"
            },
            "downloads": -1,
            "filename": "trifacta-1.0.8.tar.gz",
            "has_sig": false,
            "md5_digest": "aefa91604d3ca8c78d09112b54f6e1aa",
            "packagetype": "sdist",
            "python_version": "source",
            "requires_python": null,
            "size": 5566,
            "upload_time": "2018-07-25T16:45:31",
            "url": "https://files.pythonhosted.org/packages/61/e8/26f6f6890900618c472fe44efb933dc2e3c8400c39833ed42c733c74810b/trifacta-1.0.8.tar.gz"
        }
    ]
}