💪 Bringing the Power of tidyverse to Pandas!

tidyversetopandas is a Python package designed for users familiar with R’s tidyverse who are transitioning to Python. It bridges the syntax gap between R and Python by offering pandas equivalents to popular tidyverse functions. This package is particularly beneficial for data scientists and analysts who seek to leverage pandas’ robust capabilities with the familiar syntax of tidyverse.

Installation: installation
Documentation: https://tidyversetopandas.readthedocs.io/en/latest/example.html
Source code: https://github.com/UBC-MDS/TidyverseToPandas
Bug reports: https://github.com/UBC-MDS/TidyverseToPandas/issues

🐍 Fitting into the Python Ecosystem

While pandas is a powerful tool for data manipulation in Python, it can be challenging for those accustomed to R’s tidyverse syntax. tidyversetopandas is unique in its approach to blend these two worlds. In the Python ecosystem, tidyversetopandas fits alongside packages that aim to incorporate tidyverse-like functionality into Python’s data manipulation landscape, predominantly with pandas. The goal is to make pandas more accessible to those accustomed to tidyverse syntax.Two notable packages in this domain are tidypandas and siuba. Both of them represent, similar to tidyversetopandas, efforts to bridge the gap between R’s tidyverse approach and Python’s pandas library, offering users familiar with R’s data manipulation tools a more comfortable transition to Python’s data science ecosystem.

🔑 Key Functions:

mutate(): Similar to its tidyverse counterpart, this function allows for the creation of new columns or modification of existing ones in a DataFrame.
filter(): Enables row-wise filtering, making it easier to sift through DataFrame based on specified conditions.
select(): Facilitates the selection of specific columns in a DataFrame, streamlining data manipulation and analysis.
arrange(): Offers sorting capabilities for DataFrame based on one or multiple columns.

⚙️ Installation

pip install tidyversetopandas

🏃 Usage

Lets try to use tidyversetopandas.

Import package

Import the package into your Python environment after installation:

from tidyversetopandas import tidyversetopandas as ttp

Loading Data

Begin by loading your data into a pandas dataframe. This package assumes that you have a dataframe ready for manipulation named df.

Mutate

Use mutate to create new columns or modify existing ones. We can do this by writing the expression we want as a string.

df = ttp.mutate(df, "b=b*2")

Filter

The filter function is used to subset dataframes based on specified conditions. For instance, to select rows where ‘A’ is greater than 1 and ‘B’ is less than 6

df = ttp.filter(df, "A > 1 and B < 6")

Arrange

Sort your dataframe with arrange. You can sort by multiple columns and specify ascending or descending order. For example, to sort by ‘A’ in ascending order and then by ‘C’

df = ttp.arrange(df, True, "A", "C")

Select

To keep only certain columns, use the select function. For example, to keep only the column ‘A’

df = ttp.select(df, "A")

📖 Developer Guide

🛠️ Installation in Development Mode

Clone the repository and navigate to the project root directory.
Create a virtual environment and activate it.

conda env create -f environment.yml
conda activate tidyversetopandas

Make sure poetry is installed. If not, install it here. Once installed, run the following command to install the package in development mode.

poetry install

✅ Testing

To run the tests, use the following command:

pytest tests/

To run tests with coverage, use the following command:

pytest tests/ --cov=tidyversetopandas

To view the coverage report, use the following command:

pytest --cov=tidyversetopandas --cov-report html tests/

This will create a htmlcov directory containing the coverage report in HTML format. Open the index.html file in this directory with a web browser to view the detailed coverage report.

🤝 Contributing

Interested in contributing? Check out the contributing guidelines. Please note that this project is released with a Code of Conduct. By contributing to this project, you agree to abide by its terms.

©️ License

tidyversetopandas was created by Thomas,Sophia,Lily,Nando. It is licensed under the terms of the MIT license.

👥 Contributors

Credits

tidyversetopandas was created with cookiecutter and the py-pkgs-cookiecutter template.