package main

import (
	"fmt"
	. "github.com/brydavis/panel"
)

func main() {
	query := `select distinct Id, FirstName, LastName from Persons where FirstName like 'A%'`

	conn := Connect("mssql", "config.json") // Connecting to an Azure DB for example 
	persons := Query(conn, query)

	fmt.Printf(p.Select("FirstName").Unique())

	McNames := persons.Map("LastName", func(s string) string {
		return fmt.Sprintf("Mc%s", s)
	})

	fmt.Println(McNames.Select("FirstName", "LastName"))
}

	{ // Read a CSV
		df := Read("data/iris.csv", true)
		df = df.Map("species", func(s string) string {
			return fmt.Sprintf("__%s", s)
		})

		fmt.Println(df["species"])

	}