semvec/pypi-packages huggingface dataset:
colonpython 0.0.3
A programming language that transpiles to python and centres around colons (hence the name).
Requires Python: >=3.7

# ColonPython

A programming language that transpiles to python. It has extremely similar syntax, but you are also able to call functions with only one argument using a colon (`:`) using the following syntax:
```python
function:argument
```

This allows for statements such as this in ColonPython:
```python
print:"hello"
```

or:
```python
str:1234
```

It allows you to call single-argument functions whilst shortening the time it takes to write them.

To use ColonPython, first install it using:
```shell
pip3 install colonpython
```

Then, to use it in your program, create a new python file and before putting in any code write:
```python
import colonpython
```

Please note that sometimes Python will detect what it thinks are syntax errors, even though the code will run. This means that some things are not possible. This problem has caused this project to split into two. ColonPython and ArrowPython. ColonPython is this project: adding a way to call functions with an argument using a colon (`:`), and is used by importing the module and running the code in the file. As python identifies incorrect python syntax before runtime and raises errors, ArrowPython intead lets you run code on external files. It has more non-Python features. If I could use them in the same was as ColonPython, I would, but I cannot as far as I am aware.

Sometimes, you may run into issues. The following code will run fine:
```python
indexes = ("hello", "world")

print(indexes[0:1]) # This returns the string "hello".
```

However, the following code will not:
```python
indexes = ("hello", "world")

start = 0
end = 1

print(indexes[start:end]) # Raises error.
```

Because of this I would reccomend the following:
```python
indexes = ("hello", "world")

start = 0
end = 1

print(indexes[slice(start:end)]) # Does not raise an error, returns the string "hello".
```

Another issue comes to light when you try to try to use type hints. The following code is valid in standard python:
```python
def greeting(name: str) -> str:
    return 'Hello ' + name
```

However, in ColonPython it is not, as this would treat the variable "`name`" as a function. In ColonPython you must declare type hints using the following syntax:
```python
hint(variable, type)
```

Therefore, the following code *is* valid in ColonPython:
```python
def greeting(hint(name, str)) -> str:
    return 'Hello ' + name
```

With that out of the way, this is an example of the popular FizzBuzz program in ColonPython:
```python
import colonpython

def fizbuzz:num:
    for fizzbuzz in range:num:
        if fizzbuzz % 3 == 0 and fizzbuzz % 5 == 0:
            print:"fizzbuzz"
            continue
        elif fizzbuzz % 3 == 0:
            print:"fizz"
            continue
        elif fizzbuzz % 5 == 0:
            print:"buzz"
            continue
        print:fizzbuzz

fizbuzz:51
```

Have fun coding!
lprp-core 1.0.0
Bei Profit bei Simon melden, bei Problemen bei Lars melden
Requires Python: >=3.10,<4.0

# Introduction 
This is the core repository for the license plate recognition parking project. It contains the data model and
persistence manager as well as the services package. The service package contains python implementations of all
REST endpoints that are consumed by Python apps.

# Getting Started
TODO 

# Build and Test
TODO
dbt-excel 1.4.0rc2
The excel adapter plugin for dbt (data build tool)

# dbt-excel: Unleash the Power of Excel in Your Data Stack

## The ultimate solution for the data-driven world

Welcome to dbt-excel, the revolutionary dbt adapter that combines the rigor of dbt with the flexibility and familiarity of Excel. Get ready to change the way you look at data analytics forever.

![dbt-excel logo](assets/dbt-excel.png)

### Features

- Integrate Excel with dbt: query data that you didn't know existed, for people who didn't know you existed, all from Excel!
- Use your favorite Excel functions: VLOOKUP, sheet support, averageif, and more, because life's too short for learning SQL functions.
- Runs blazingly fast queries thanks to duckdb running in the background, so you can have your cake and eat it too!
- Monitor your data assets, collaborate on data models, and document your queries, all within Excel. Remember, if it's not in Excel, it's not worth doing!

### **Installation**

To install dbt-excel, just run the following command in your terminal:

```bash
python -m pip install dbt-excel
```


#### Profile setup

The default profile will create a duckdb file in /tmp, of the custom `excel` type. You can adjust the path if necessary.

```
dbt_excel:
  target: dev
  outputs:
   dev:
     type: excel
     path: /tmp/dbt.duckdb

```


### Running your first DBT Excel model

Steps:

1. `cd` into the `dbt_project` directory, then run `dbt run -s my_first_dbt_model --profiles-dir .` this will run the models in the `models/example/my_first_dbt_model.sql` file.
2. A Excel file exists in `sources/people.xlsx`, which will be read and used by the models. The result will be written to ` first_model.xlsx`.
3. Boom, you just read from AND wrote to Excel!
4. Savour this moment, it's precious.

### Testimonials:

**Enterprise Architect:**

> As an Enterprise Architect, I have been involved in countless failed digital transformation projects. They all make the same mistake. They forget one thing: all data lives in Excel. By moving away from enterprise-grade solutions like Excel to complicated stacks based on FivetPython, dbt and XXX, companies neglect their core competence. 1,048,576 rows ought to be enough for anybody. The only digital winners are the companies that build their stack on top of Excel.

**CEO:**

> Companies worldwide are pouring trillions of dollars into digital transformation. But they forget one thing. In the end, all data lives in Excel. Dbt-excel combines the rigour of software engineering from dbt with the flexibility of Excel. True data democratization starts and ends with Excel.

**Anonymous Analyst:**
> I used to have impostor syndrome working with DBT. With Excel I know I Excel.


### Credits

Big credits to [Josh Wills' excellent DBT Duckdb adapter](https://github.com/jwills/dbt-duckdb) which inspired this project!