日本語話者データ(米国）

🚧 建造中 🚧

Tables & Visuals 表・見える化

Code

import pandas as pd
import geopandas as gpd
import folium
import itables
import geoplot

jpmap = gpd.read_file("../../census/jpmap.gpkg")
itables.options.css = """
.dt-column-header {
  font-size: small;
}
"""

itables.show(pd.DataFrame(jpmap.loc[:,["ST","state","population","epopulation","eng","eeng","jpn","ejpn","bilingual","ebilingual",
                            "jpnloweng","ejpnloweng","pctjpn","pctbilingual","bilingualratio"]]), 
                            maxBytes=200000, style="width:100%", 
                            buttons=["pageLength", {"extend": "colvisGroup","text": "Hide Errors","hide": [1,3,5,7,9,11]},
                                                    {"extend": "colvisGroup","text": "Show all","show": "*"}],
                            columnDefs=[{"className":"dt-left", "targets":[0]}, 
                                        {"targets":[1,3,5,7,9,11], "visible":False}],
                            columnControl=["order"],
                            ordering={"indicators": False, "handler": False})

^ⓘST	state	population	epopulation	eng	eeng	jpn	ejpn	bilingual	ebilingual	jpnloweng	ejpnloweng	pctjpn	pctbilingual	bilingualratio
AL	alabama	4793030	601	4503218	5359	2528	541	1228	414	1300	327	0.052743	0.025621	48.575949
AK	alaska	689070	169	585162	2727	1494	390	1033	281	461	254	0.216814	0.149912	69.143240
AZ	arizona	6981320	285	5184054	11544	7952	907	5119	706	2833	511	0.113904	0.073324	64.373742
AR	arkansas	2869111	548	2630451	4441	935	266	495	195	440	218	0.032588	0.017253	52.941176
CA	california	37121454	487	20642638	54450	133419	4594	78900	3190	54519	2222	0.359412	0.212546	59.137004
CO	colorado	5549558	577	4650283	9223	5893	658	4494	563	1399	266	0.106189	0.080979	76.259969
CT	connecticut	3442817	90	2638366	6723	3281	640	2322	504	959	329	0.095300	0.067445	70.771106
DE	delaware	966580	46	820336	3432	805	272	603	229	202	102	0.083283	0.062385	74.906832
DC	district of columbia	640841	66	518478	3204	1054	285	692	244	362	145	0.164471	0.107983	65.654649
FL	florida	21289728	707	14769458	25976	12222	1183	8153	993	4069	647	0.057408	0.038295	66.707577
(41 more rows not shown)

🚧 UNDER CONSTRUCTION 🚧

Borrowed from https://llm2human.pages.dev/

Code

regionallang = jpmap.loc[:,["population","eng","jpn","bilingual","jpnloweng","region"]].groupby(["region"], as_index=False).sum()
regionallang["pctjpn"] = (regionallang.jpn * 100) / regionallang.population
regionallang["pctbilingual"] = (regionallang.bilingual * 100) / regionallang.population
itables.show(regionallang, maxBytes=200000, style="width:100%",
                            columnDefs=[{"className":"dt-left", "targets":[0]}],
                            columnControl=["order"],
                            ordering={"indicators": False, "handler": False})

^ⓘregion	population	eng	jpn	bilingual	jpnloweng	pctjpn	pctbilingual
midwest	65194303	57229624	58473	33954	24519	0.089690	0.052081
northeast	54393479	41199327	68163	41873	26290	0.125315	0.076982
south	121811243	96711452	96036	59928	36108	0.078840	0.049197
west	74743523	50626636	239733	148271	91462	0.320741	0.198373

Code

jpmetro = pd.read_csv("../../census/jpmetro.csv")

itables.show(pd.DataFrame(jpmetro.loc[:,["metro-area","population","epopulation","eng","eeng","jpn","ejpn","bilingual","ebilingual","pctjpn","pctbilingual","bilingualratio"]]), 
                            maxBytes=200000, style="width:100%", 
                            buttons=["pageLength", {"extend": "colvisGroup","text": "Hide Errors","hide": [2,4,6,8]},
                                                    {"extend": "colvisGroup","text": "Show all","show": "*"}],
                            columnDefs=[{"className":"dt-left", "targets":[0]}, 
                                        {"targets":[2,4,6,8], "visible":False}],
                            columnControl=["order"],
                            ordering={"indicators": False, "handler": False,},
                            classes="display")

^ⓘmetro-area	population	epopulation	eng	eeng	jpn	ejpn	bilingual	ebilingual	pctjpn	pctbilingual	bilingualratio
atlanta-sandy springs-roswell, ga metro division; atlanta-sandy springs-roswell, ga metro area	4591766	311	3642234	10169	6239	1064	3574	761	0.135874	0.077835	57.284821
marietta, ga metro division; atlanta-sandy springs-roswell, ga metro area	1301511	115	1076929	5376	1237	306	859	248	0.095043	0.066000	69.442199
boston, ma metro division; boston-cambridge-newton, ma-nh metro area	1947655	150	1421953	6523	3073	660	2165	531	0.157779	0.111159	70.452327
cambridge-newton-framingham, ma metro division; boston-cambridge-newton, ma-nh metro area	2325264	78	1652376	7223	4417	480	3116	405	0.189957	0.134006	70.545619
rockingham county-strafford county, nh metro division; boston-cambridge-newton, ma-nh metro area	431393	101	404899	1812	140	80	135	81	0.032453	0.031294	96.428571
chicago-naperville-schaumburg, il metro division; chicago-naperville-elgin, il-in metro area	6789711	111	4576500	12296	9881	1000	5936	774	0.145529	0.087426	60.074891
elgin, il metro division; chicago-naperville-elgin, il-in metro area	712200	39	517436	3885	375	194	256	158	0.052654	0.035945	68.266667
lake county, il metro division; chicago-naperville-elgin, il-in metro area	676256	4	463738	3120	1269	292	901	243	0.187651	0.133234	71.000788
lake county-porter county-jasper county, in metro division; chicago-naperville-elgin, il-in metro area	682320	96	596637	2864	268	158	191	132	0.039278	0.027993	71.268657
dallas-plano-irving, tx metro division; dallas-fort worth-arlington, tx metro area	5038495	155	3303773	12593	7177	1326	4410	1043	0.142443	0.087526	61.446287
(27 more rows not shown)