jhconning

# Example
shpfile = r'zip://ag1860/1860county.zip'
gdf = GeoDataFrame.from_file(shpfile)

jhconning

jhconning

From: https://stackoverflow.com/questions/20264909/suppress-section-numberings-in-nbconvert-to-latex

create: secnum.tplx
---------------------------------
((* extends 'article.tplx' *))

((* block commands *))
\setcounter{secnumdepth}{0} % Turns off numbering for sections
((( super() )))
((* endblock commands *))

jhconning

jhconning

import pandas as pd
import pymysql

mysql_connection = pymysql.connect(host='localhost',
                    user='root',
                    password='',
                    db='tutorfall2016',
                    charset='utf8',
                    cursorclass=pymysql.cursors.DictCursor)
                    

jhconning

from sympy import init_printing; init_printing(use_latex='mathjax')

jhconning

# to create a multinindex

df.sort_values(by = ['Year', 'UnitDesc','bin'], inplace = True)
df = df.set_index(['Year', 'UnitDesc','bin'],drop = False)

# To turn one level of the index into a column
df = df.unstack('UnitDesc')['Value']
df.head()

# to pull out all data in level='Year' 

jhconning

jhconning

def drop_cols(df):
    '''drop columns that don't vary'''
    df.drop([ col for col in df.columns if (len(df[col].unique()) == 1)], 
        axis=1, inplace=True)

jhconning

{
 "cells": [
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "# Mapping largest cities\n",
    "## Experiments with folium, zipfile and pandas"
   ]
  },