PyPI	GitHub	Info	Stats

What is Meerschaum?

Meerschaum is a tool for quickly synchronizing time-series data streams called pipes. With Meerschaum, you can have a data visualization stack running in minutes.

Why Meerschaum?

If you've worked with time-series data, you know the headaches that come with ETL. Data engineering often gets in analysts' way, and when work needs to get done, every minute spent on pipelining is time taken away from real analysis.

Rather than copy / pasting your ETL scripts, simply build pipes with Meerschaum! Meerschaum gives you the tools to design your data streams how you like ― and don't worry — you can always incorporate Meerschaum into your existing systems!

Want to Learn More?

You can find a wealth of information at meerschaum.io!

Additionally, below are several articles published about Meerschaum:

• Interview featured in Console 100 - The Open Source Newsletter
• A Data Scientist's Guide to Fetching COVID-19 Data in 2022 (Towards Data Science)
• Time-Series ETL with Meerschaum (Towards Data Science)
• How I automatically extract my M1 Finance transactions

Features

• 📊 Built for Data Scientists and Analysts
  • Integrate with Pandas, Grafana and other popular data analysis tools.
  • Persist your dataframes and always get the latest data.
• ⚡️ Production-Ready, Batteries Included
  • Synchronization engine concurrently updates many time-series data streams.
  • One-click deploy a TimescaleDB and Grafana stack for prototyping.
  • Serve data to your entire organization through the power of uvicorn, gunicorn, and FastAPI.
• 🔌 Easily Expandable
  • Ingest any data source with a simple plugin. Just return a DataFrame, and Meerschaum handles the rest.
  • Add any function as a command to the Meerschaum system.
  • Include Meerschaum in your projects with its easy-to-use Python API.
• ✨ Tailored for Your Experience
  • Rich CLI makes managing your data streams surprisingly enjoyable!
  • Web dashboard for those who prefer a more graphical experience.
  • Manage your database connections with Meerschaum connectors
  • Utility commands with sensible syntax let you control many pipes with grace.
• 💼 Portable from the Start
  • The environment variable $MRSM_ROOT_DIR lets you emulate multiple installations and group together your instances.
  • No dependencies required; anything needed will be installed into a virtual environment.
  • Specify required packages for your plugins, and users will get those packages in a virtual environment.

Installation

For a more thorough setup guide, visit the Getting Started page at meerschaum.io.

TL;DR

pip install -U --user meerschaum
mrsm stack up -d db grafana
mrsm bootstrap pipes

Usage Documentation

Please visit meerschaum.io for setup, usage, and troubleshooting information. You can find technical documentation at docs.meerschaum.io, and here is a complete list of the Meerschaum actions.

>>> import meerschaum as mrsm
>>> pipe = mrsm.Pipe("plugin:noaa", "weather")
>>> df = pipe.get_data(begin='2022-02-02')
>>> df[['timestamp', 'station', 'temperature (wmoUnit:degC)']]
               timestamp station  temperature (wmoUnit:degC)
0    2022-03-29 09:54:00    KCEU                         8.3
1    2022-03-29 09:52:00    KATL                        10.6
2    2022-03-29 09:52:00    KCLT                         7.2
3    2022-03-29 08:54:00    KCEU                         8.3
4    2022-03-29 08:52:00    KATL                        11.1
...                  ...     ...                         ...
1626 2022-02-02 01:52:00    KATL                        10.0
1627 2022-02-02 01:52:00    KCLT                         7.8
1628 2022-02-02 00:54:00    KCEU                         8.3
1629 2022-02-02 00:52:00    KATL                        10.0
1630 2022-02-02 00:52:00    KCLT                         8.3

[1631 rows x 3 columns]
>>>

Plugins

Here is the list of community plugins and the public plugins repository.

For details on installing, using, and writing plugins, check out the plugins documentation at meerschaum.io.

Example Plugin

# ~/.config/meerschaum/plugins/example.py
__version__ = '0.0.1'
required = []

def register(pipe, **kw):
    return {
        'columns': {
            'datetime': 'dt',
            'id': 'id',
            'value': 'val',
        }
    }

def fetch(pipe, **kw):
    import datetime, random
    return {
        'dt': [datetime.datetime.utcnow()],
        'id': [1],
        'val': [random.randint(0, 100)],
    }

Support Meerschaum's Development

For consulting services and to support Meerschaum's development, please considering sponsoring me on GitHub sponsors.

Additionally, you can always buy me a coffee☕!

License

Copyright 2021 Bennett Meares

Licensed under the Apache License, Version 2.0 (the "License"); you may not use this file except in compliance with the License. You may obtain a copy of the License at

http://www.apache.org/licenses/LICENSE-2.0

Unless required by applicable law or agreed to in writing, software distributed under the License is distributed on an "AS IS" BASIS, WITHOUT WARRANTIES OR CONDITIONS OF ANY KIND, either express or implied. See the License for the specific language governing permissions and limitations under the License.