mondaytoframe 0.2.0

This python package helps converting data between the Monday API and Dataframes

mondaytoframe

This Python package helps convert data between the Monday.com API and DataFrames.

Installation

You can install the package using pip:

pip install mondaytoframe

Usage

Here's a basic example of how to use the package:

from mondaytoframe import create_board, create_items, read, update
import pandas as pd
import os

monday_token = "your_monday_token_here"

# Create a new board
columns = {"Numbers Column": "numbers", "Text Column": "text"}
board_id = create_board(columns, monday_token)

# Create items in a board
new_df = pd.DataFrame(
    {
        "Name": ["first", "second"],
        "Numbers Column": [1.0, 2.0],
        "Text Column": ["a", "b"],
    }
)
create_items(board_id, new_df, monday_token)

# Read your board as a dataframe...
df = read(board_id, monday_token)

# ... perform data transformation on your dataframe
df_transformed = df.copy()
df_transformed["Numbers Column"] = df["Numbers Column"] + 1

# ... and store the results in Monday again!
update(board_id, df_transformed, monday_token)

[!TIP] Instead of providing monday_token, you could also set MONDAYTOFRAME_TOKEN environment variable.

Features

• Easy conversion between Monday.com API data and DataFrames
• Simplifies data manipulation and analysis
• Support for multiple monday column types

Supported Data Types

Column Type	Supported by read	Supported by update
Item ID	✅	✅
Name	✅	✅
Text	✅	✅
Long Text	✅	✅
Number	✅	✅
Date	✅	✅
Status	✅	✅
Dropdown	✅	✅
People	✅	✅
Tags	✅	✅
Checkbox	✅	✅
Link	✅	✅
Email	✅	✅
Phone	✅	✅
Timeline	❌	❌
Country	❌	❌
Color Picker	❌	❌
Rating	❌	❌
Progress Tracking	❌	❌
Formula	❌	❌
Auto Number	❌	❌
Dependency	❌	❌
Button	❌	❌
World Clock	❌	❌
Location	❌	❌
Hour	❌	❌
Week	❌	❌
File	❌	❌
Board Relation	❌	❌
Mirror	❌	❌
Vote	❌	❌
Subitems	❌	❌

Contributing

Contributions are welcome! Please read the contributing guidelines first.

License

This project is licensed under the BSD 3-Clause License - see the LICENSE file for details.

Contact

For any questions or issues, please open an issue.