{
"cells": [
{
"cell_type": "code",
"execution_count": 64,
"metadata": {},
"outputs": [
{
"data": {
"text/html": [
"
\n",
"\n",
"
\n",
" \n",
" \n",
" | \n",
" Patron Type Code | \n",
" Patron Type Definition | \n",
" Total Checkouts | \n",
" Total Renewals | \n",
" Age Range | \n",
" Home Library Code | \n",
" Home Library Definition | \n",
" Circulation Active Month | \n",
" Circulation Active Year | \n",
" Notice Preference Code | \n",
" Notice Preference Definition | \n",
" Provided Email Address | \n",
" Year Patron Registered | \n",
" Outside of County | \n",
" Supervisor District | \n",
"
\n",
" \n",
" \n",
" \n",
" 0 | \n",
" 0 | \n",
" ADULT | \n",
" 1092 | \n",
" 761 | \n",
" 60 to 64 years | \n",
" M6 | \n",
" Mission | \n",
" July | \n",
" 2016 | \n",
" p | \n",
" phone | \n",
" False | \n",
" 2003 | \n",
" False | \n",
" 9.0 | \n",
"
\n",
" \n",
" 1 | \n",
" 0 | \n",
" ADULT | \n",
" 0 | \n",
" 0 | \n",
" 20 to 24 years | \n",
" P1 | \n",
" Park | \n",
" None | \n",
" None | \n",
" z | \n",
" email | \n",
" True | \n",
" 2014 | \n",
" False | \n",
" 5.0 | \n",
"
\n",
" \n",
" 2 | \n",
" 0 | \n",
" ADULT | \n",
" 31 | \n",
" 22 | \n",
" 25 to 34 years | \n",
" S7 | \n",
" Sunset | \n",
" April | \n",
" 2016 | \n",
" z | \n",
" email | \n",
" True | \n",
" 2010 | \n",
" False | \n",
" 4.0 | \n",
"
\n",
" \n",
" 3 | \n",
" 0 | \n",
" ADULT | \n",
" 0 | \n",
" 0 | \n",
" 45 to 54 years | \n",
" P1 | \n",
" Park | \n",
" None | \n",
" None | \n",
" a | \n",
" print | \n",
" False | \n",
" 2016 | \n",
" True | \n",
" NaN | \n",
"
\n",
" \n",
" 4 | \n",
" 0 | \n",
" ADULT | \n",
" 0 | \n",
" 0 | \n",
" 25 to 34 years | \n",
" X | \n",
" Main Library | \n",
" None | \n",
" None | \n",
" z | \n",
" email | \n",
" True | \n",
" 2015 | \n",
" False | \n",
" 3.0 | \n",
"
\n",
" \n",
" 5 | \n",
" 0 | \n",
" ADULT | \n",
" 126 | \n",
" 11 | \n",
" 45 to 54 years | \n",
" M2 | \n",
" Marina | \n",
" January | \n",
" 2016 | \n",
" z | \n",
" email | \n",
" True | \n",
" 2003 | \n",
" False | \n",
" 2.0 | \n",
"
\n",
" \n",
" 6 | \n",
" 3 | \n",
" SENIOR | \n",
" 0 | \n",
" 0 | \n",
" 65 to 74 years | \n",
" C2 | \n",
" Chinatown | \n",
" None | \n",
" None | \n",
" z | \n",
" email | \n",
" True | \n",
" 2015 | \n",
" True | \n",
" NaN | \n",
"
\n",
" \n",
" 7 | \n",
" 0 | \n",
" ADULT | \n",
" 3002 | \n",
" 1689 | \n",
" 25 to 34 years | \n",
" P5 | \n",
" Portola | \n",
" July | \n",
" 2016 | \n",
" p | \n",
" phone | \n",
" True | \n",
" 2004 | \n",
" False | \n",
" 9.0 | \n",
"
\n",
" \n",
" 8 | \n",
" 0 | \n",
" ADULT | \n",
" 4 | \n",
" 0 | \n",
" 25 to 34 years | \n",
" C2 | \n",
" Chinatown | \n",
" July | \n",
" 2014 | \n",
" p | \n",
" phone | \n",
" True | \n",
" 2014 | \n",
" False | \n",
" 5.0 | \n",
"
\n",
" \n",
" 9 | \n",
" 0 | \n",
" ADULT | \n",
" 20 | \n",
" 0 | \n",
" 25 to 34 years | \n",
" S7 | \n",
" Sunset | \n",
" June | \n",
" 2015 | \n",
" z | \n",
" email | \n",
" True | \n",
" 2011 | \n",
" False | \n",
" 7.0 | \n",
"
\n",
" \n",
"
\n",
"
"
],
"text/plain": [
" Patron Type Code Patron Type Definition Total Checkouts Total Renewals \\\n",
"0 0 ADULT 1092 761 \n",
"1 0 ADULT 0 0 \n",
"2 0 ADULT 31 22 \n",
"3 0 ADULT 0 0 \n",
"4 0 ADULT 0 0 \n",
"5 0 ADULT 126 11 \n",
"6 3 SENIOR 0 0 \n",
"7 0 ADULT 3002 1689 \n",
"8 0 ADULT 4 0 \n",
"9 0 ADULT 20 0 \n",
"\n",
" Age Range Home Library Code Home Library Definition \\\n",
"0 60 to 64 years M6 Mission \n",
"1 20 to 24 years P1 Park \n",
"2 25 to 34 years S7 Sunset \n",
"3 45 to 54 years P1 Park \n",
"4 25 to 34 years X Main Library \n",
"5 45 to 54 years M2 Marina \n",
"6 65 to 74 years C2 Chinatown \n",
"7 25 to 34 years P5 Portola \n",
"8 25 to 34 years C2 Chinatown \n",
"9 25 to 34 years S7 Sunset \n",
"\n",
" Circulation Active Month Circulation Active Year Notice Preference Code \\\n",
"0 July 2016 p \n",
"1 None None z \n",
"2 April 2016 z \n",
"3 None None a \n",
"4 None None z \n",
"5 January 2016 z \n",
"6 None None z \n",
"7 July 2016 p \n",
"8 July 2014 p \n",
"9 June 2015 z \n",
"\n",
" Notice Preference Definition Provided Email Address \\\n",
"0 phone False \n",
"1 email True \n",
"2 email True \n",
"3 print False \n",
"4 email True \n",
"5 email True \n",
"6 email True \n",
"7 phone True \n",
"8 phone True \n",
"9 email True \n",
"\n",
" Year Patron Registered Outside of County Supervisor District \n",
"0 2003 False 9.0 \n",
"1 2014 False 5.0 \n",
"2 2010 False 4.0 \n",
"3 2016 True NaN \n",
"4 2015 False 3.0 \n",
"5 2003 False 2.0 \n",
"6 2015 True NaN \n",
"7 2004 False 9.0 \n",
"8 2014 False 5.0 \n",
"9 2011 False 7.0 "
]
},
"execution_count": 64,
"metadata": {},
"output_type": "execute_result"
}
],
"source": [
"import pandas as pd\n",
"\n",
"df = pd.read_csv('../data/Library_Usage_Small.csv')\n",
"df.to_json('../data/Library_Usage_Small.json')\n",
"df = pd.read_json('../data/Library_Usage_Small.json')\n",
"df"
]
},
{
"cell_type": "code",
"execution_count": 41,
"metadata": {},
"outputs": [
{
"data": {
"text/html": [
"\n",
"\n",
"
\n",
" \n",
" \n",
" | \n",
" Patron Type Code | \n",
" Patron Type Definition | \n",
" Total Checkouts | \n",
" Total Renewals | \n",
" Age Range | \n",
" Home Library Code | \n",
" Home Library Definition | \n",
" Circulation Active Month | \n",
" Circulation Active Year | \n",
" Notice Preference Code | \n",
" Notice Preference Definition | \n",
" Provided Email Address | \n",
" Year Patron Registered | \n",
" Outside of County | \n",
" Supervisor District | \n",
"
\n",
" \n",
" \n",
" \n",
" 0 | \n",
" 0 | \n",
" ADULT | \n",
" 1092 | \n",
" 761 | \n",
" 60 to 64 years | \n",
" M6 | \n",
" Mission | \n",
" July | \n",
" 2016 | \n",
" p | \n",
" phone | \n",
" False | \n",
" 2003 | \n",
" False | \n",
" 9.0 | \n",
"
\n",
" \n",
" 1 | \n",
" 0 | \n",
" ADULT | \n",
" 0 | \n",
" 0 | \n",
" 20 to 24 years | \n",
" P1 | \n",
" Park | \n",
" None | \n",
" None | \n",
" z | \n",
" email | \n",
" True | \n",
" 2014 | \n",
" False | \n",
" 5.0 | \n",
"
\n",
" \n",
" 2 | \n",
" 0 | \n",
" ADULT | \n",
" 31 | \n",
" 22 | \n",
" 25 to 34 years | \n",
" S7 | \n",
" Sunset | \n",
" April | \n",
" 2016 | \n",
" z | \n",
" email | \n",
" True | \n",
" 2010 | \n",
" False | \n",
" 4.0 | \n",
"
\n",
" \n",
" 3 | \n",
" 0 | \n",
" ADULT | \n",
" 0 | \n",
" 0 | \n",
" 45 to 54 years | \n",
" P1 | \n",
" Park | \n",
" None | \n",
" None | \n",
" a | \n",
" print | \n",
" False | \n",
" 2016 | \n",
" True | \n",
" NaN | \n",
"
\n",
" \n",
" 4 | \n",
" 0 | \n",
" ADULT | \n",
" 0 | \n",
" 0 | \n",
" 25 to 34 years | \n",
" X | \n",
" Main Library | \n",
" None | \n",
" None | \n",
" z | \n",
" email | \n",
" True | \n",
" 2015 | \n",
" False | \n",
" 3.0 | \n",
"
\n",
" \n",
" 5 | \n",
" 0 | \n",
" ADULT | \n",
" 126 | \n",
" 11 | \n",
" 45 to 54 years | \n",
" M2 | \n",
" Marina | \n",
" January | \n",
" 2016 | \n",
" z | \n",
" email | \n",
" True | \n",
" 2003 | \n",
" False | \n",
" 2.0 | \n",
"
\n",
" \n",
" 6 | \n",
" 3 | \n",
" SENIOR | \n",
" 0 | \n",
" 0 | \n",
" 65 to 74 years | \n",
" C2 | \n",
" Chinatown | \n",
" None | \n",
" None | \n",
" z | \n",
" email | \n",
" True | \n",
" 2015 | \n",
" True | \n",
" NaN | \n",
"
\n",
" \n",
" 7 | \n",
" 0 | \n",
" ADULT | \n",
" 3002 | \n",
" 1689 | \n",
" 25 to 34 years | \n",
" P5 | \n",
" Portola | \n",
" July | \n",
" 2016 | \n",
" p | \n",
" phone | \n",
" True | \n",
" 2004 | \n",
" False | \n",
" 9.0 | \n",
"
\n",
" \n",
" 8 | \n",
" 0 | \n",
" ADULT | \n",
" 4 | \n",
" 0 | \n",
" 25 to 34 years | \n",
" C2 | \n",
" Chinatown | \n",
" July | \n",
" 2014 | \n",
" p | \n",
" phone | \n",
" True | \n",
" 2014 | \n",
" False | \n",
" 5.0 | \n",
"
\n",
" \n",
" 9 | \n",
" 0 | \n",
" ADULT | \n",
" 20 | \n",
" 0 | \n",
" 25 to 34 years | \n",
" S7 | \n",
" Sunset | \n",
" June | \n",
" 2015 | \n",
" z | \n",
" email | \n",
" True | \n",
" 2011 | \n",
" False | \n",
" 7.0 | \n",
"
\n",
" \n",
"
\n",
"
"
],
"text/plain": [
" Patron Type Code Patron Type Definition Total Checkouts Total Renewals \\\n",
"0 0 ADULT 1092 761 \n",
"1 0 ADULT 0 0 \n",
"2 0 ADULT 31 22 \n",
"3 0 ADULT 0 0 \n",
"4 0 ADULT 0 0 \n",
"5 0 ADULT 126 11 \n",
"6 3 SENIOR 0 0 \n",
"7 0 ADULT 3002 1689 \n",
"8 0 ADULT 4 0 \n",
"9 0 ADULT 20 0 \n",
"\n",
" Age Range Home Library Code Home Library Definition \\\n",
"0 60 to 64 years M6 Mission \n",
"1 20 to 24 years P1 Park \n",
"2 25 to 34 years S7 Sunset \n",
"3 45 to 54 years P1 Park \n",
"4 25 to 34 years X Main Library \n",
"5 45 to 54 years M2 Marina \n",
"6 65 to 74 years C2 Chinatown \n",
"7 25 to 34 years P5 Portola \n",
"8 25 to 34 years C2 Chinatown \n",
"9 25 to 34 years S7 Sunset \n",
"\n",
" Circulation Active Month Circulation Active Year Notice Preference Code \\\n",
"0 July 2016 p \n",
"1 None None z \n",
"2 April 2016 z \n",
"3 None None a \n",
"4 None None z \n",
"5 January 2016 z \n",
"6 None None z \n",
"7 July 2016 p \n",
"8 July 2014 p \n",
"9 June 2015 z \n",
"\n",
" Notice Preference Definition Provided Email Address \\\n",
"0 phone False \n",
"1 email True \n",
"2 email True \n",
"3 print False \n",
"4 email True \n",
"5 email True \n",
"6 email True \n",
"7 phone True \n",
"8 phone True \n",
"9 email True \n",
"\n",
" Year Patron Registered Outside of County Supervisor District \n",
"0 2003 False 9.0 \n",
"1 2014 False 5.0 \n",
"2 2010 False 4.0 \n",
"3 2016 True NaN \n",
"4 2015 False 3.0 \n",
"5 2003 False 2.0 \n",
"6 2015 True NaN \n",
"7 2004 False 9.0 \n",
"8 2014 False 5.0 \n",
"9 2011 False 7.0 "
]
},
"execution_count": 41,
"metadata": {},
"output_type": "execute_result"
}
],
"source": [
"df.to_html('../data/Library_Usage_Small.html', index=False)\n",
"df = pd.read_html('../data/Library_Usage_Small.html')\n",
"df = df[0]\n",
"df"
]
},
{
"cell_type": "code",
"execution_count": 42,
"metadata": {},
"outputs": [
{
"data": {
"text/html": [
"\n",
"\n",
"
\n",
" \n",
" \n",
" | \n",
" Patron Type Code | \n",
" Patron Type Definition | \n",
" Total Checkouts | \n",
" Total Renewals | \n",
" Age Range | \n",
" Home Library Code | \n",
" Home Library Definition | \n",
" Circulation Active Month | \n",
" Circulation Active Year | \n",
" Notice Preference Code | \n",
" Notice Preference Definition | \n",
" Provided Email Address | \n",
" Year Patron Registered | \n",
" Outside of County | \n",
" Supervisor District | \n",
"
\n",
" \n",
" \n",
" \n",
" 0 | \n",
" 0 | \n",
" ADULT | \n",
" 1092 | \n",
" 761 | \n",
" 60 to 64 years | \n",
" M6 | \n",
" Mission | \n",
" July | \n",
" 2016 | \n",
" p | \n",
" phone | \n",
" False | \n",
" 2003 | \n",
" False | \n",
" 9.0 | \n",
"
\n",
" \n",
" 1 | \n",
" 0 | \n",
" ADULT | \n",
" 0 | \n",
" 0 | \n",
" 20 to 24 years | \n",
" P1 | \n",
" Park | \n",
" None | \n",
" None | \n",
" z | \n",
" email | \n",
" True | \n",
" 2014 | \n",
" False | \n",
" 5.0 | \n",
"
\n",
" \n",
" 2 | \n",
" 0 | \n",
" ADULT | \n",
" 31 | \n",
" 22 | \n",
" 25 to 34 years | \n",
" S7 | \n",
" Sunset | \n",
" April | \n",
" 2016 | \n",
" z | \n",
" email | \n",
" True | \n",
" 2010 | \n",
" False | \n",
" 4.0 | \n",
"
\n",
" \n",
" 3 | \n",
" 0 | \n",
" ADULT | \n",
" 0 | \n",
" 0 | \n",
" 45 to 54 years | \n",
" P1 | \n",
" Park | \n",
" None | \n",
" None | \n",
" a | \n",
" print | \n",
" False | \n",
" 2016 | \n",
" True | \n",
" NaN | \n",
"
\n",
" \n",
" 4 | \n",
" 0 | \n",
" ADULT | \n",
" 0 | \n",
" 0 | \n",
" 25 to 34 years | \n",
" X | \n",
" Main Library | \n",
" None | \n",
" None | \n",
" z | \n",
" email | \n",
" True | \n",
" 2015 | \n",
" False | \n",
" 3.0 | \n",
"
\n",
" \n",
" 5 | \n",
" 0 | \n",
" ADULT | \n",
" 126 | \n",
" 11 | \n",
" 45 to 54 years | \n",
" M2 | \n",
" Marina | \n",
" January | \n",
" 2016 | \n",
" z | \n",
" email | \n",
" True | \n",
" 2003 | \n",
" False | \n",
" 2.0 | \n",
"
\n",
" \n",
" 6 | \n",
" 3 | \n",
" SENIOR | \n",
" 0 | \n",
" 0 | \n",
" 65 to 74 years | \n",
" C2 | \n",
" Chinatown | \n",
" None | \n",
" None | \n",
" z | \n",
" email | \n",
" True | \n",
" 2015 | \n",
" True | \n",
" NaN | \n",
"
\n",
" \n",
" 7 | \n",
" 0 | \n",
" ADULT | \n",
" 3002 | \n",
" 1689 | \n",
" 25 to 34 years | \n",
" P5 | \n",
" Portola | \n",
" July | \n",
" 2016 | \n",
" p | \n",
" phone | \n",
" True | \n",
" 2004 | \n",
" False | \n",
" 9.0 | \n",
"
\n",
" \n",
" 8 | \n",
" 0 | \n",
" ADULT | \n",
" 4 | \n",
" 0 | \n",
" 25 to 34 years | \n",
" C2 | \n",
" Chinatown | \n",
" July | \n",
" 2014 | \n",
" p | \n",
" phone | \n",
" True | \n",
" 2014 | \n",
" False | \n",
" 5.0 | \n",
"
\n",
" \n",
" 9 | \n",
" 0 | \n",
" ADULT | \n",
" 20 | \n",
" 0 | \n",
" 25 to 34 years | \n",
" S7 | \n",
" Sunset | \n",
" June | \n",
" 2015 | \n",
" z | \n",
" email | \n",
" True | \n",
" 2011 | \n",
" False | \n",
" 7.0 | \n",
"
\n",
" \n",
"
\n",
"
"
],
"text/plain": [
" Patron Type Code Patron Type Definition Total Checkouts Total Renewals \\\n",
"0 0 ADULT 1092 761 \n",
"1 0 ADULT 0 0 \n",
"2 0 ADULT 31 22 \n",
"3 0 ADULT 0 0 \n",
"4 0 ADULT 0 0 \n",
"5 0 ADULT 126 11 \n",
"6 3 SENIOR 0 0 \n",
"7 0 ADULT 3002 1689 \n",
"8 0 ADULT 4 0 \n",
"9 0 ADULT 20 0 \n",
"\n",
" Age Range Home Library Code Home Library Definition \\\n",
"0 60 to 64 years M6 Mission \n",
"1 20 to 24 years P1 Park \n",
"2 25 to 34 years S7 Sunset \n",
"3 45 to 54 years P1 Park \n",
"4 25 to 34 years X Main Library \n",
"5 45 to 54 years M2 Marina \n",
"6 65 to 74 years C2 Chinatown \n",
"7 25 to 34 years P5 Portola \n",
"8 25 to 34 years C2 Chinatown \n",
"9 25 to 34 years S7 Sunset \n",
"\n",
" Circulation Active Month Circulation Active Year Notice Preference Code \\\n",
"0 July 2016 p \n",
"1 None None z \n",
"2 April 2016 z \n",
"3 None None a \n",
"4 None None z \n",
"5 January 2016 z \n",
"6 None None z \n",
"7 July 2016 p \n",
"8 July 2014 p \n",
"9 June 2015 z \n",
"\n",
" Notice Preference Definition Provided Email Address \\\n",
"0 phone False \n",
"1 email True \n",
"2 email True \n",
"3 print False \n",
"4 email True \n",
"5 email True \n",
"6 email True \n",
"7 phone True \n",
"8 phone True \n",
"9 email True \n",
"\n",
" Year Patron Registered Outside of County Supervisor District \n",
"0 2003 False 9.0 \n",
"1 2014 False 5.0 \n",
"2 2010 False 4.0 \n",
"3 2016 True NaN \n",
"4 2015 False 3.0 \n",
"5 2003 False 2.0 \n",
"6 2015 True NaN \n",
"7 2004 False 9.0 \n",
"8 2014 False 5.0 \n",
"9 2011 False 7.0 "
]
},
"execution_count": 42,
"metadata": {},
"output_type": "execute_result"
}
],
"source": [
"df.to_excel('../data/Library_Usage_Small.xlsx', index=False)\n",
"df = pd.read_excel('../data/Library_Usage_Small.xlsx')\n",
"df"
]
},
{
"cell_type": "code",
"execution_count": 43,
"metadata": {},
"outputs": [],
"source": [
"df.to_csv('../data/Library_Usage_Small_Copy.csv')"
]
}
],
"metadata": {
"kernelspec": {
"display_name": "Python 3",
"language": "python",
"name": "python3"
},
"language_info": {
"codemirror_mode": {
"name": "ipython",
"version": 3
},
"file_extension": ".py",
"mimetype": "text/x-python",
"name": "python",
"nbconvert_exporter": "python",
"pygments_lexer": "ipython3",
"version": "3.7.4"
}
},
"nbformat": 4,
"nbformat_minor": 2
}