Marlene marlenezw

## inner_join
artist_number_of_displays = art.mutate(c_artist=art['artist']).groupby("c_artist").count("display_title")

most_popular_artist = artists_at_portrero.inner_join(
    artist_number_of_displays,
    predicates=artists_at_portrero["artist"] == artist_number_of_displays["c_artist"]
    ).materialize()

## select_artists_at_location
artist_location = art["street_address_or_intersection", "artist"]
artists_at_portrero = artist_location.filter(artist_location["street_address_or_intersection"] == "1001 Portrero Avenue").distinct()

## groupby_and_sort
art_loc = art.groupby("street_address_or_intersection").count('display_title')
most_art = art_loc.sort_by(ibis.desc(art_loc.display_title))

## filtering_data
adrianes_art = art.filter(art["artist"] == 'Colburn, Adriane')
adrianes_art

## distinct_and_count
distinct_artists = art["artist"].distinct()
distinct_artists.count()

## select_columns
art["artist", "display_title"]

## readable_table_name
art = db.table("civicArtTable")
art.columns

## list_db_tables
 db.list_tables()

## connecting_to_database
import ibis
ibis.options.interactive = True
db = ibis.sqlite.connect("civicArt.db")

## check_sqlite_table_created
.tables   (this lets you check the table has been correctly created)
.schema civicArtTable (describes the table)
	artist_number_of_displays = art.mutate(c_artist=art['artist']).groupby("c_artist").count("display_title")

	most_popular_artist = artists_at_portrero.inner_join(
	artist_number_of_displays,
	predicates=artists_at_portrero["artist"] == artist_number_of_displays["c_artist"]
	).materialize()
	artist_location = art["street_address_or_intersection", "artist"]
	artists_at_portrero = artist_location.filter(artist_location["street_address_or_intersection"] == "1001 Portrero Avenue").distinct()
	art_loc = art.groupby("street_address_or_intersection").count('display_title')
	most_art = art_loc.sort_by(ibis.desc(art_loc.display_title))
	adrianes_art = art.filter(art["artist"] == 'Colburn, Adriane')
	adrianes_art
	distinct_artists = art["artist"].distinct()
	distinct_artists.count()
	import ibis
	ibis.options.interactive = True
	db = ibis.sqlite.connect("civicArt.db")
	.tables (this lets you check the table has been correctly created)
	.schema civicArtTable (describes the table)