import%20marimo%0A%0A__generated_with%20%3D%20%220.25.2%22%0Aapp%20%3D%20marimo.App(width%3D%22medium%22%2C%20app_title%3D%22Glossary%22)%0A%0Awith%20app.setup%3A%0A%20%20%20%20import%20marimo%20as%20mo%0A%0A%20%20%20%20S%2C%20G%2C%20P%20%3D%20%2200_start.py%22%2C%20%2210_get_round.py%22%2C%20%2290_primers.py%22%0A%20%20%20%20C%2C%20D%2C%20B%20%3D%20%2220_check_round.py%22%2C%20%2222_store_round.py%22%2C%20%2221_debugging_drill.py%22%0A%20%20%20%20E%2C%20R%2C%20W%2C%20K%2C%20X%20%3D%20%2230_new_edition.py%22%2C%20%2231_share_round.py%22%2C%20%2232_datasette.py%22%2C%20%2233_capstone_next_round.py%22%2C%20%2283_stretch_day3.py%22%0A%0A%20%20%20%20%23%20One%20entry%20per%20term%3A%20what%20it%20means%2C%20a%20small%20example%2C%20and%20where%20you%20meet%20it.%0A%20%20%20%20%23%20%22where%22%20is%20a%20list%20of%20(notebook%2C%20how%20to%20find%20it%2C%20a%20heading%20in%20that%20notebook).%20The%20course's%20tests%20check%20every%20heading%20exists.%0A%20%20%20%20TERMS%20%3D%20%5B%0A%20%20%20%20%20%20%20%20%23%20Python%0A%20%20%20%20%20%20%20%20%7B%22term%22%3A%20%22value%22%2C%20%22kind%22%3A%20%22Python%22%2C%20%22meaning%22%3A%20%22A%20piece%20of%20data%3A%20a%20number%2C%20a%20text%2C%20a%20yes%2Fno%2C%20a%20list%E2%80%A6%22%2C%20%22example%22%3A%20'42%2C%20%220128%22%2C%20True'%2C%20%22where%22%3A%20%5B(S%2C%20%22%C2%A73.1%22%2C%20%22%23%23%23%203.1%20Values%20and%20their%20types%22)%5D%7D%2C%0A%20%20%20%20%20%20%20%20%7B%22term%22%3A%20%22type%22%2C%20%22kind%22%3A%20%22Python%22%2C%20%22meaning%22%3A%20%22What%20kind%20of%20value%20something%20is%3B%20it%20decides%20what%20you%20can%20do%20with%20it.%20type(x)%20tells%20you.%22%2C%20%22example%22%3A%20'type(%220128%22)%20is%20str'%2C%20%22where%22%3A%20%5B(S%2C%20%22%C2%A73.1%22%2C%20%22%23%23%23%203.1%20Values%20and%20their%20types%22)%5D%7D%2C%0A%20%20%20%20%20%20%20%20%7B%22term%22%3A%20%22int%22%2C%20%22kind%22%3A%20%22Python%22%2C%20%22meaning%22%3A%20%22A%20whole%20number.%20It%20cannot%20keep%20leading%20zeros.%22%2C%20%22example%22%3A%20'int(%220128%22)%20gives%20128'%2C%20%22where%22%3A%20%5B(S%2C%20%22%C2%A73.1%22%2C%20%22%23%23%23%203.1%20Values%20and%20their%20types%22)%2C%20(S%2C%20%22%C2%A74.1%22%2C%20%22%23%23%23%204.1%20Codes%20are%20text%22)%5D%7D%2C%0A%20%20%20%20%20%20%20%20%7B%22term%22%3A%20%22float%22%2C%20%22kind%22%3A%20%22Python%22%2C%20%22meaning%22%3A%20%22A%20decimal%20number.%20A%20number%20column%20with%20missing%20values%20is%20usually%20float%2C%20so%20a%20code%20comes%20out%20as%20100305000.0.%22%2C%20%22example%22%3A%20%22100305000.0%22%2C%20%22where%22%3A%20%5B(S%2C%20%22%C2%A73.1%22%2C%20%22%23%23%23%203.1%20Values%20and%20their%20types%22)%2C%20(G%2C%20%22%C2%A71%22%2C%20%22%23%23%201%20%C2%B7%20Read%20Round%201%20without%20losing%20anything%22)%5D%7D%2C%0A%20%20%20%20%20%20%20%20%7B%22term%22%3A%20%22str%20(text%2C%20string)%22%2C%20%22kind%22%3A%20%22Python%22%2C%20%22meaning%22%3A%20%22Text.%20Keeps%20every%20character%2C%20leading%20zeros%20included.%20Written%20in%20quotes.%22%2C%20%22example%22%3A%20'%220100305000%22'%2C%20%22where%22%3A%20%5B(S%2C%20%22%C2%A73.1%22%2C%20%22%23%23%23%203.1%20Values%20and%20their%20types%22)%5D%7D%2C%0A%20%20%20%20%20%20%20%20%7B%22term%22%3A%20%22bool%22%2C%20%22kind%22%3A%20%22Python%22%2C%20%22meaning%22%3A%20%22True%20or%20False.%20Comparisons%20give%20one.%22%2C%20%22example%22%3A%20%225%20%3E%203%20gives%20True%22%2C%20%22where%22%3A%20%5B(S%2C%20%22%C2%A73.1%22%2C%20%22%23%23%23%203.1%20Values%20and%20their%20types%22)%5D%7D%2C%0A%20%20%20%20%20%20%20%20%7B%22term%22%3A%20%22None%22%2C%20%22kind%22%3A%20%22Python%22%2C%20%22meaning%22%3A%20%22Python's%20'no%20value'.%20A%20function%20without%20return%20gives%20None%3B%20missing%20data%20often%20becomes%20None.%22%2C%20%22example%22%3A%20'to_number(%22..%22)%20gives%20None'%2C%20%22where%22%3A%20%5B(S%2C%20%22%C2%A73.1%22%2C%20%22%23%23%23%203.1%20Values%20and%20their%20types%22)%5D%7D%2C%0A%20%20%20%20%20%20%20%20%7B%22term%22%3A%20%22list%22%2C%20%22kind%22%3A%20%22Python%22%2C%20%22meaning%22%3A%20%22Values%20in%20order%2C%20in%20square%20brackets%3B%20can%20repeat.%22%2C%20%22example%22%3A%20'%5B%22hhid%22%2C%20%22age%22%5D'%2C%20%22where%22%3A%20%5B(S%2C%20%22%C2%A74.2%22%2C%20%22%23%23%23%204.2%20Collections%3A%20lists%2C%20sets%20and%20dictionaries%22)%5D%7D%2C%0A%20%20%20%20%20%20%20%20%7B%22term%22%3A%20%22set%22%2C%20%22kind%22%3A%20%22Python%22%2C%20%22meaning%22%3A%20%22Values%20without%20order%2C%20each%20once%2C%20in%20curly%20brackets.%20Good%20for%20'in%20one%20but%20not%20the%20other'.%22%2C%20%22example%22%3A%20'%7B%2201%22%2C%20%2202%22%7D%20-%20%7B%2202%22%7D%20gives%20%7B%2201%22%7D'%2C%20%22where%22%3A%20%5B(S%2C%20%22%C2%A74.2%22%2C%20%22%23%23%23%204.2%20Collections%3A%20lists%2C%20sets%20and%20dictionaries%22)%5D%7D%2C%0A%20%20%20%20%20%20%20%20%7B%22term%22%3A%20%22dictionary%20(dict)%22%2C%20%22kind%22%3A%20%22Python%22%2C%20%22meaning%22%3A%20%22Keys%20mapped%20to%20values.%20Look%20a%20value%20up%20with%20d%5Bkey%5D.%22%2C%20%22example%22%3A%20'roles%20%3D%20%7B%22area_code%22%3A%20%22psgc%22%7D%3B%20roles%5B%22area_code%22%5D'%2C%20%22where%22%3A%20%5B(S%2C%20%22%C2%A74.2%22%2C%20%22%23%23%23%204.2%20Collections%3A%20lists%2C%20sets%20and%20dictionaries%22)%5D%7D%2C%0A%20%20%20%20%20%20%20%20%7B%22term%22%3A%20%22tuple%20(pair)%22%2C%20%22kind%22%3A%20%22Python%22%2C%20%22meaning%22%3A%20%22A%20fixed%20group%20of%20values%20in%20round%20brackets%3B%20a%20function%20can%20return%20two%20values%20as%20a%20pair.%22%2C%20%22example%22%3A%20'(1842300%2C%20%22published%22)'%2C%20%22where%22%3A%20%5B(G%2C%20%22Exercise%204.2%22%2C%20%22%23%23%23%20Exercise%204.2.%22)%5D%7D%2C%0A%20%20%20%20%20%20%20%20%7B%22term%22%3A%20%22variable%22%2C%20%22kind%22%3A%20%22Python%22%2C%20%22meaning%22%3A%20%22A%20name%20that%20points%20to%20a%20value%2C%20made%20with%20%3D.%22%2C%20%22example%22%3A%20%22household_size%20%3D%205%22%2C%20%22where%22%3A%20%5B(S%2C%20%22%C2%A73.2%22%2C%20%22%23%23%23%203.2%20Variables%3A%20names%20for%20values%22)%5D%7D%2C%0A%20%20%20%20%20%20%20%20%7B%22term%22%3A%20%22assignment%20(%3D)%22%2C%20%22kind%22%3A%20%22Python%22%2C%20%22meaning%22%3A%20%22Giving%20a%20name%20to%20a%20value.%20One%20%3D%20assigns%3B%20two%20%3D%3D%20compare.%22%2C%20%22example%22%3A%20%22total%20%3D%2010%20%2B%205%22%2C%20%22where%22%3A%20%5B(S%2C%20%22%C2%A73.2%22%2C%20%22%23%23%23%203.2%20Variables%3A%20names%20for%20values%22)%5D%7D%2C%0A%20%20%20%20%20%20%20%20%7B%22term%22%3A%20%22comment%20(%23)%22%2C%20%22kind%22%3A%20%22Python%22%2C%20%22meaning%22%3A%20%22Everything%20after%20%23%20on%20a%20line%20is%20skipped%20by%20Python%3A%20notes%20for%20people.%22%2C%20%22example%22%3A%20%22%23%20keep%20codes%20as%20text%22%2C%20%22where%22%3A%20%5B(S%2C%20%22%C2%A73.3%22%2C%20'%23%23%23%203.3%20Comments%2C%20and%20%22commenting%20out%22')%5D%7D%2C%0A%20%20%20%20%20%20%20%20%7B%22term%22%3A%20%22commenting%20out%22%2C%20%22kind%22%3A%20%22Python%22%2C%20%22meaning%22%3A%20%22Putting%20%23%20in%20front%20of%20a%20line%20of%20code%20to%20switch%20it%20off%20without%20deleting%20it.%20Ctrl%20%2B%20%2F%20(Cmd%20%2B%20%2F)%20does%20it.%22%2C%20%22example%22%3A%20%22%23%20total%20%3D%200%22%2C%20%22where%22%3A%20%5B(S%2C%20%22%C2%A73.3%22%2C%20'%23%23%23%203.3%20Comments%2C%20and%20%22commenting%20out%22')%5D%7D%2C%0A%20%20%20%20%20%20%20%20%7B%22term%22%3A%20%22indentation%22%2C%20%22kind%22%3A%20%22Python%22%2C%20%22meaning%22%3A%20%22The%20spaces%20at%20the%20start%20of%20a%20line.%20They%20decide%20which%20lines%20belong%20to%20an%20if%2C%20a%20loop%2C%20a%20function%20or%20a%20try.%22%2C%20%22example%22%3A%20%22if%20x%3A%5Cn%20%20%20%20y%20%3D%201%22%2C%20%22where%22%3A%20%5B(S%2C%20%22%C2%A73.4%22%2C%20%22%23%23%23%203.4%20Blocks%3A%20%60if%60%2C%20and%20why%20indentation%20matters%22)%5D%7D%2C%0A%20%20%20%20%20%20%20%20%7B%22term%22%3A%20%22if%20%2F%20elif%20%2F%20else%22%2C%20%22kind%22%3A%20%22Python%22%2C%20%22meaning%22%3A%20%22Run%20some%20lines%20only%20when%20a%20condition%20is%20true%3B%20elif%20tries%20another%20condition%3B%20else%20catches%20the%20rest.%22%2C%20%22example%22%3A%20'if%20text%20%3D%3D%20%22..%22%3A%20...'%2C%20%22where%22%3A%20%5B(S%2C%20%22%C2%A73.4%22%2C%20%22%23%23%23%203.4%20Blocks%3A%20%60if%60%2C%20and%20why%20indentation%20matters%22)%5D%7D%2C%0A%20%20%20%20%20%20%20%20%7B%22term%22%3A%20%22function%22%2C%20%22kind%22%3A%20%22Python%22%2C%20%22meaning%22%3A%20%22Named%20steps%20that%20take%20inputs%20and%20return%20a%20result.%20Every%20exercise%20is%20one.%22%2C%20%22example%22%3A%20%22def%20pad_code(code%2C%20width)%3A%20...%22%2C%20%22where%22%3A%20%5B(S%2C%20%22%C2%A73.5%22%2C%20%22%23%23%23%203.5%20Functions%3A%20give%20steps%20a%20name%2C%20take%20inputs%2C%20return%20a%20result%22)%5D%7D%2C%0A%20%20%20%20%20%20%20%20%7B%22term%22%3A%20%22input%20(parameter)%22%2C%20%22kind%22%3A%20%22Python%22%2C%20%22meaning%22%3A%20%22A%20name%20in%20a%20function's%20brackets%3B%20inside%2C%20it%20points%20to%20the%20value%20the%20caller%20gave.%22%2C%20%22example%22%3A%20%22code%20and%20width%20in%20pad_code(code%2C%20width)%22%2C%20%22where%22%3A%20%5B(S%2C%20%22%C2%A73.5%22%2C%20%22%23%23%23%203.5%20Functions%3A%20give%20steps%20a%20name%2C%20take%20inputs%2C%20return%20a%20result%22)%5D%7D%2C%0A%20%20%20%20%20%20%20%20%7B%22term%22%3A%20%22return%22%2C%20%22kind%22%3A%20%22Python%22%2C%20%22meaning%22%3A%20%22Ends%20a%20function%20and%20hands%20its%20result%20back%20to%20the%20caller.%20print%20only%20shows%20text%3B%20return%20gives%20a%20value.%22%2C%20%22example%22%3A%20%22return%20code.zfill(width)%22%2C%20%22where%22%3A%20%5B(S%2C%20%22%C2%A73.5%22%2C%20%22%23%23%23%203.5%20Functions%3A%20give%20steps%20a%20name%2C%20take%20inputs%2C%20return%20a%20result%22)%5D%7D%2C%0A%20%20%20%20%20%20%20%20%7B%22term%22%3A%20%22default%20value%22%2C%20%22kind%22%3A%20%22Python%22%2C%20%22meaning%22%3A%20%22A%20value%20an%20input%20takes%20when%20the%20caller%20leaves%20it%20out.%22%2C%20%22example%22%3A%20%22def%20region_of(area_code%2C%20width%3D2)%22%2C%20%22where%22%3A%20%5B(S%2C%20%22%C2%A73.5%22%2C%20%22%23%23%23%203.5%20Functions%3A%20give%20steps%20a%20name%2C%20take%20inputs%2C%20return%20a%20result%22)%5D%7D%2C%0A%20%20%20%20%20%20%20%20%7B%22term%22%3A%20%22docstring%22%2C%20%22kind%22%3A%20%22Python%22%2C%20%22meaning%22%3A%20%22A%20text%20in%20triple%20quotes%20right%20under%20def%2C%20describing%20what%20the%20function%20does.%22%2C%20%22example%22%3A%20'%22%22%22Pad%20a%20code%20with%20zeros.%22%22%22'%2C%20%22where%22%3A%20%5B(S%2C%20%22%C2%A73.5%22%2C%20%22%23%23%23%203.5%20Functions%3A%20give%20steps%20a%20name%2C%20take%20inputs%2C%20return%20a%20result%22)%5D%7D%2C%0A%20%20%20%20%20%20%20%20%7B%22term%22%3A%20%22lambda%22%2C%20%22kind%22%3A%20%22Python%22%2C%20%22meaning%22%3A%20%22A%20small%20function%20without%20a%20name%2C%20written%20inline.%22%2C%20%22example%22%3A%20%22lambda%20v%3A%20v.zfill(10)%22%2C%20%22where%22%3A%20%5B(P%2C%20%22primer%201%22%2C%20%22%23%23%201%20%C2%B7%20Doing%20something%20to%20every%20value%22)%5D%7D%2C%0A%20%20%20%20%20%20%20%20%7B%22term%22%3A%20%22method%22%2C%20%22kind%22%3A%20%22Python%22%2C%20%22meaning%22%3A%20%22A%20function%20that%20belongs%20to%20a%20value%2C%20called%20with%20a%20dot.%22%2C%20%22example%22%3A%20'%22128%22.zfill(4)%2C%20table.rename(...)'%2C%20%22where%22%3A%20%5B(S%2C%20%22%C2%A74.1%22%2C%20%22%23%23%23%204.1%20Codes%20are%20text%22)%5D%7D%2C%0A%20%20%20%20%20%20%20%20%7B%22term%22%3A%20%22f-string%22%2C%20%22kind%22%3A%20%22Python%22%2C%20%22meaning%22%3A%20%22Text%20with%20an%20f%20in%20front%3B%20names%20in%20%7B%20%7D%20are%20replaced%20by%20their%20values.%22%2C%20%22example%22%3A%20'f%22SELECT%20*%20FROM%20%7Btable%7D%22'%2C%20%22where%22%3A%20%5B(S%2C%20%22%C2%A74.3%22%2C%20%22%23%23%23%204.3%20Loops%20and%20f-strings%20that%20write%20SQL%22)%5D%7D%2C%0A%20%20%20%20%20%20%20%20%7B%22term%22%3A%20%22for%20loop%22%2C%20%22kind%22%3A%20%22Python%22%2C%20%22meaning%22%3A%20%22Repeat%20the%20indented%20lines%20once%20for%20each%20item%20of%20a%20list.%22%2C%20%22example%22%3A%20%22for%20column%20in%20columns%3A%20...%22%2C%20%22where%22%3A%20%5B(S%2C%20%22%C2%A74.3%22%2C%20%22%23%23%23%204.3%20Loops%20and%20f-strings%20that%20write%20SQL%22)%5D%7D%2C%0A%20%20%20%20%20%20%20%20%7B%22term%22%3A%20%22while%20loop%22%2C%20%22kind%22%3A%20%22Python%22%2C%20%22meaning%22%3A%20%22Repeat%20the%20indented%20lines%20as%20long%20as%20a%20condition%20is%20true.%22%2C%20%22example%22%3A%20%22while%20page_name%20is%20not%20None%3A%20...%22%2C%20%22where%22%3A%20%5B(G%2C%20%22Exercise%204.3%22%2C%20%22%23%23%23%20Exercise%204.3.%22)%5D%7D%2C%0A%20%20%20%20%20%20%20%20%7B%22term%22%3A%20%22slice%22%2C%20%22kind%22%3A%20%22Python%22%2C%20%22meaning%22%3A%20%22Part%20of%20a%20text%20or%20list%2C%20from%20a%20start%20position%20up%20to%20(not%20including)%20a%20stop%20position%2C%20counting%20from%200.%22%2C%20%22example%22%3A%20'%220100305000%22%5B%3A2%5D%20gives%20%2201%22'%2C%20%22where%22%3A%20%5B(S%2C%20%22%C2%A74.4%22%2C%20%22%23%23%23%204.4%20Slices%3A%20parts%20of%20a%20text%22)%5D%7D%2C%0A%20%20%20%20%20%20%20%20%7B%22term%22%3A%20%22class%22%2C%20%22kind%22%3A%20%22Python%22%2C%20%22meaning%22%3A%20%22A%20description%20of%20what%20one%20record%20must%20look%20like.%20With%20pydantic%2C%20it%20also%20checks%20each%20record.%22%2C%20%22example%22%3A%20%22class%20Household(BaseModel)%3A%20...%22%2C%20%22where%22%3A%20%5B(S%2C%20%22%C2%A74.6%22%2C%20%22%23%23%23%204.6%20Classes%3A%20the%20shape%20of%20a%20record%22)%5D%7D%2C%0A%20%20%20%20%20%20%20%20%7B%22term%22%3A%20%22exception%20(error)%22%2C%20%22kind%22%3A%20%22Python%22%2C%20%22meaning%22%3A%20%22What%20Python%20raises%20when%20something%20goes%20wrong.%20Its%20name%20says%20what%20kind%20of%20problem.%22%2C%20%22example%22%3A%20%22ValueError%2C%20KeyError%22%2C%20%22where%22%3A%20%5B(S%2C%20%22%C2%A74.7%22%2C%20%22%23%23%23%204.7%20Errors%20you%20expect%3A%20%60try%60%20and%20%60except%60%22)%2C%20(P%2C%20%22primer%2010%22%2C%20%22%23%23%2010%20%C2%B7%20Reading%20an%20error%22)%5D%7D%2C%0A%20%20%20%20%20%20%20%20%7B%22term%22%3A%20%22try%20%2F%20except%22%2C%20%22kind%22%3A%20%22Python%22%2C%20%22meaning%22%3A%20%22Run%20some%20lines%2C%20and%20if%20they%20raise%20a%20specific%20error%2C%20run%20other%20lines%20instead.%22%2C%20%22example%22%3A%20%22try%3A%20int(text)%5Cnexcept%20ValueError%3A%20None%22%2C%20%22where%22%3A%20%5B(S%2C%20%22%C2%A74.7%22%2C%20%22%23%23%23%204.7%20Errors%20you%20expect%3A%20%60try%60%20and%20%60except%60%22)%5D%7D%2C%0A%20%20%20%20%20%20%20%20%7B%22term%22%3A%20%22traceback%22%2C%20%22kind%22%3A%20%22Python%22%2C%20%22meaning%22%3A%20%22The%20error%20report%20Python%20prints.%20Read%20the%20last%20line%20first%2C%20then%20your%20line%20just%20above%20it.%22%2C%20%22example%22%3A%20%22KeyError%3A%20'code'%22%2C%20%22where%22%3A%20%5B(P%2C%20%22primer%2010%22%2C%20%22%23%23%2010%20%C2%B7%20Reading%20an%20error%22)%5D%7D%2C%0A%20%20%20%20%20%20%20%20%7B%22term%22%3A%20%22NotImplementedError%22%2C%20%22kind%22%3A%20%22Python%22%2C%20%22meaning%22%3A%20%22The%20course's%20'not%20written%20yet'%20marker.%20Delete%20that%20line%20when%20your%20code%20is%20ready.%22%2C%20%22example%22%3A%20'raise%20NotImplementedError(%22Exercise%201.1%22)'%2C%20%22where%22%3A%20%5B(S%2C%20%22%C2%A73.6%22%2C%20%22%23%23%23%203.6%20How%20the%20exercises%20work%22)%5D%7D%2C%0A%20%20%20%20%20%20%20%20%7B%22term%22%3A%20%22import%20%2F%20module%22%2C%20%22kind%22%3A%20%22Python%22%2C%20%22meaning%22%3A%20%22import%20brings%20in%20code%20from%20a%20library%20or%20another%20file%20(a%20module).%22%2C%20%22example%22%3A%20%22import%20pandas%20as%20pd%22%2C%20%22where%22%3A%20%5B(S%2C%20%22%C2%A74.8%22%2C%20%22%23%23%23%204.8%20Paths%20and%20imports%22)%5D%7D%2C%0A%20%20%20%20%20%20%20%20%7B%22term%22%3A%20%22path%22%2C%20%22kind%22%3A%20%22Python%22%2C%20%22meaning%22%3A%20%22Where%20a%20file%20is.%20Built%20with%20%2F%20so%20it%20works%20on%20every%20computer.%22%2C%20%22example%22%3A%20'PATHS.rounds%20%2F%20%222023Q4%22%20%2F%20%22survey.dta%22'%2C%20%22where%22%3A%20%5B(S%2C%20%22%C2%A74.8%22%2C%20%22%23%23%23%204.8%20Paths%20and%20imports%22)%5D%7D%2C%0A%20%20%20%20%20%20%20%20%23%20pandas%0A%20%20%20%20%20%20%20%20%7B%22term%22%3A%20%22DataFrame%22%2C%20%22kind%22%3A%20%22pandas%22%2C%20%22meaning%22%3A%20%22A%20table%3A%20named%20columns%2C%20one%20row%20per%20record.%22%2C%20%22example%22%3A%20%22round1%22%2C%20%22where%22%3A%20%5B(S%2C%20%22%C2%A74.5%22%2C%20%22%23%23%23%204.5%20pandas%3A%20Series%20and%20DataFrames%22)%5D%7D%2C%0A%20%20%20%20%20%20%20%20%7B%22term%22%3A%20%22Series%22%2C%20%22kind%22%3A%20%22pandas%22%2C%20%22meaning%22%3A%20%22One%20column%20of%20a%20table.%22%2C%20%22example%22%3A%20'round1%5B%22area_code%22%5D'%2C%20%22where%22%3A%20%5B(S%2C%20%22%C2%A74.5%22%2C%20%22%23%23%23%204.5%20pandas%3A%20Series%20and%20DataFrames%22)%5D%7D%2C%0A%20%20%20%20%20%20%20%20%7B%22term%22%3A%20%22missing%20value%20(NaN)%22%2C%20%22kind%22%3A%20%22pandas%22%2C%20%22meaning%22%3A%20%22A%20cell%20with%20no%20value.%20.isna()%20finds%20them.%20An%20empty%20text%20''%20is%20not%20missing.%22%2C%20%22example%22%3A%20'pd.isna(float(%22nan%22))%20is%20True'%2C%20%22where%22%3A%20%5B(S%2C%20%22%C2%A74.5%22%2C%20%22%23%23%23%204.5%20pandas%3A%20Series%20and%20DataFrames%22)%5D%7D%2C%0A%20%20%20%20%20%20%20%20%7B%22term%22%3A%20%22dtype%22%2C%20%22kind%22%3A%20%22pandas%22%2C%20%22meaning%22%3A%20%22The%20type%20of%20a%20column's%20values%3A%20int64%2C%20float64%2C%20str%2C%20bool%E2%80%A6%22%2C%20%22example%22%3A%20'raw%5B%22psgc%22%5D.dtype%20is%20float64'%2C%20%22where%22%3A%20%5B(G%2C%20%22%C2%A71%22%2C%20%22%23%23%201%20%C2%B7%20Read%20Round%201%20without%20losing%20anything%22)%5D%7D%2C%0A%20%20%20%20%20%20%20%20%7B%22term%22%3A%20%22map%22%2C%20%22kind%22%3A%20%22pandas%22%2C%20%22meaning%22%3A%20%22Call%20a%20function%20on%20every%20value%20of%20a%20column%2C%20giving%20a%20new%20column.%22%2C%20%22example%22%3A%20%22codes.map(lambda%20v%3A%20v.zfill(10))%22%2C%20%22where%22%3A%20%5B(P%2C%20%22primer%201%22%2C%20%22%23%23%201%20%C2%B7%20Doing%20something%20to%20every%20value%22)%5D%7D%2C%0A%20%20%20%20%20%20%20%20%7B%22term%22%3A%20%22condition%20(filter%2C%20mask)%22%2C%20%22kind%22%3A%20%22pandas%22%2C%20%22meaning%22%3A%20%22A%20True%2FFalse%20per%20row%3B%20table%5Bcondition%5D%20keeps%20the%20True%20rows.%20Combine%20with%20%26%20%7C%20~.%22%2C%20%22example%22%3A%20'table%5Btable%5B%22level%22%5D%20%3D%3D%20%22City%22%5D'%2C%20%22where%22%3A%20%5B(P%2C%20%22primer%202%22%2C%20%22%23%23%202%20%C2%B7%20Keeping%20rows%22)%5D%7D%2C%0A%20%20%20%20%20%20%20%20%7B%22term%22%3A%20%22method%20chain%22%2C%20%22kind%22%3A%20%22pandas%22%2C%20%22meaning%22%3A%20%22Several%20methods%20one%20after%20another%2C%20each%20working%20on%20what%20the%20previous%20one%20gave%20back.%22%2C%20%22example%22%3A%20%22t.drop_duplicates(...).rename(...)%22%2C%20%22where%22%3A%20%5B(P%2C%20%22primer%203%22%2C%20%22%23%23%203%20%C2%B7%20Reading%20a%20chain%22)%5D%7D%2C%0A%20%20%20%20%20%20%20%20%7B%22term%22%3A%20%22groupby%20%2F%20agg%22%2C%20%22kind%22%3A%20%22pandas%22%2C%20%22meaning%22%3A%20%22Split%20rows%20into%20groups%2C%20calculate%20inside%20each%2C%20combine%3A%20one%20row%20per%20group.%22%2C%20%22example%22%3A%20't.groupby(%22area_code%22).agg(persons%3D(%22hhid%22%2C%20%22size%22))'%2C%20%22where%22%3A%20%5B(P%2C%20%22primer%205%22%2C%20%22%23%23%205%20%C2%B7%20Grouping%22)%5D%7D%2C%0A%20%20%20%20%20%20%20%20%7B%22term%22%3A%20%22merge%22%2C%20%22kind%22%3A%20%22pandas%22%2C%20%22meaning%22%3A%20%22pandas'%20join.%22%2C%20%22example%22%3A%20'people.merge(codes%2C%20on%3D%22area_code%22%2C%20how%3D%22left%22)'%2C%20%22where%22%3A%20%5B(G%2C%20%22%C2%A73%22%2C%20%22%23%23%23%20What%20a%20join%20does%22)%2C%20(P%2C%20%22primer%206%22%2C%20%22%23%23%206%20%C2%B7%20Joins%22)%5D%7D%2C%0A%20%20%20%20%20%20%20%20%7B%22term%22%3A%20%22melt%22%2C%20%22kind%22%3A%20%22pandas%22%2C%20%22meaning%22%3A%20%22Turn%20a%20wide%20table%20(one%20column%20per%20year)%20into%20a%20long%20one%20(one%20row%20per%20year).%22%2C%20%22example%22%3A%20'wide.melt(id_vars%3D%22geolocation%22%2C%20var_name%3D%22year%22)'%2C%20%22where%22%3A%20%5B(G%2C%20%22%C2%A74%22%2C%20%22%23%23%23%20Wide%20and%20long%22)%5D%7D%2C%0A%20%20%20%20%20%20%20%20%7B%22term%22%3A%20%22index%22%2C%20%22kind%22%3A%20%22pandas%22%2C%20%22meaning%22%3A%20%22A%20table's%20row%20labels.%20After%20groupby%20the%20group%20column%20becomes%20the%20index%3B%20.reset_index()%20makes%20it%20a%20column%20again.%22%2C%20%22example%22%3A%20%22.reset_index(drop%3DTrue)%22%2C%20%22where%22%3A%20%5B(P%2C%20%22primer%205%22%2C%20%22%23%23%205%20%C2%B7%20Grouping%22)%5D%7D%2C%0A%20%20%20%20%20%20%20%20%23%20SQL%20and%20DuckDB%0A%20%20%20%20%20%20%20%20%7B%22term%22%3A%20%22SQL%22%2C%20%22kind%22%3A%20%22SQL%22%2C%20%22meaning%22%3A%20%22The%20language%20of%20databases%3A%20SELECT%20%E2%80%A6%20FROM%20%E2%80%A6%20WHERE%20%E2%80%A6%20GROUP%20BY%20%E2%80%A6%20ORDER%20BY.%22%2C%20%22example%22%3A%20%22SELECT%20region%2C%20count(*)%20FROM%20round1%20GROUP%20BY%20region%22%2C%20%22where%22%3A%20%5B(P%2C%20%22primer%204%22%2C%20%22%23%23%204%20%C2%B7%20SQL%20in%20five%20minutes%22)%5D%7D%2C%0A%20%20%20%20%20%20%20%20%7B%22term%22%3A%20%22DuckDB%22%2C%20%22kind%22%3A%20%22SQL%22%2C%20%22meaning%22%3A%20%22The%20database%20engine%20the%20course%20uses%2C%20inside%20Python.%20It%20can%20query%20files%20and%20pandas%20tables.%22%2C%20%22example%22%3A%20'con.sql(%22SELECT%20...%22).df()'%2C%20%22where%22%3A%20%5B(P%2C%20%22primer%204%22%2C%20%22%23%23%204%20%C2%B7%20SQL%20in%20five%20minutes%22)%5D%7D%2C%0A%20%20%20%20%20%20%20%20%7B%22term%22%3A%20%22SQL%20cell%22%2C%20%22kind%22%3A%20%22SQL%22%2C%20%22meaning%22%3A%20%22A%20marimo%20cell%20written%20in%20SQL%3B%20it%20can%20query%20any%20table%20in%20the%20notebook%20by%20name.%22%2C%20%22example%22%3A%20%22SUMMARIZE%20round1%22%2C%20%22where%22%3A%20%5B(S%2C%20%22%C2%A72%22%2C%20%22%23%23%202%20%C2%B7%20How%20a%20marimo%20notebook%20works%22)%2C%20(G%2C%20%22%C2%A72%22%2C%20%22%23%23%23%20Look%20before%20you%20move%20on%22)%5D%7D%2C%0A%20%20%20%20%20%20%20%20%7B%22term%22%3A%20%22SUMMARIZE%22%2C%20%22kind%22%3A%20%22SQL%22%2C%20%22meaning%22%3A%20%22A%20DuckDB%20command%20describing%20every%20column%20of%20a%20table%20at%20once.%22%2C%20%22example%22%3A%20%22SUMMARIZE%20round1%22%2C%20%22where%22%3A%20%5B(G%2C%20%22%C2%A72%22%2C%20%22%23%23%23%20Look%20before%20you%20move%20on%22)%5D%7D%2C%0A%20%20%20%20%20%20%20%20%7B%22term%22%3A%20%22CAST%20%2F%20VARCHAR%22%2C%20%22kind%22%3A%20%22SQL%22%2C%20%22meaning%22%3A%20%22CAST%20turns%20a%20value%20into%20another%20type%3B%20VARCHAR%20is%20text.%22%2C%20%22example%22%3A%20%22CAST(region_code%20AS%20VARCHAR)%22%2C%20%22where%22%3A%20%5B(G%2C%20%22Exercise%203.4%22%2C%20%22%23%23%23%20Exercise%203.4.%22)%5D%7D%2C%0A%20%20%20%20%20%20%20%20%7B%22term%22%3A%20%22lpad%22%2C%20%22kind%22%3A%20%22SQL%22%2C%20%22meaning%22%3A%20%22Pad%20text%20on%20the%20left%20to%20a%20length%2C%20like%20.zfill%20in%20Python.%22%2C%20%22example%22%3A%20%22lpad('1'%2C%202%2C%20'0')%20gives%20'01'%22%2C%20%22where%22%3A%20%5B(G%2C%20%22Exercise%203.4%22%2C%20%22%23%23%23%20Exercise%203.4.%22)%5D%7D%2C%0A%20%20%20%20%20%20%20%20%7B%22term%22%3A%20%22attach%22%2C%20%22kind%22%3A%20%22SQL%22%2C%20%22meaning%22%3A%20%22Connect%20another%20database%20so%20its%20tables%20can%20be%20queried%20next%20to%20yours.%22%2C%20%22example%22%3A%20%22ATTACH%20'legacy_system.sqlite'%20AS%20legacy%20(TYPE%20sqlite%2C%20READ_ONLY)%22%2C%20%22where%22%3A%20%5B(G%2C%20%22%C2%A73%22%2C%20%22%23%23%23%20Another%20system's%20database%22)%5D%7D%2C%0A%20%20%20%20%20%20%20%20%23%20Data%20management%0A%20%20%20%20%20%20%20%20%7B%22term%22%3A%20%22code%20(as%20a%20label)%22%2C%20%22kind%22%3A%20%22Data%20management%22%2C%20%22meaning%22%3A%20%22An%20identifier%20such%20as%20an%20area%20code%3A%20a%20label%2C%20never%20a%20number%20to%20calculate%20with.%20Keep%20it%20as%20text.%22%2C%20%22example%22%3A%20'%220100305000%22'%2C%20%22where%22%3A%20%5B(G%2C%20%22%C2%A71%22%2C%20%22%23%23%201%20%C2%B7%20Read%20Round%201%20without%20losing%20anything%22)%5D%7D%2C%0A%20%20%20%20%20%20%20%20%7B%22term%22%3A%20%22leading%20zero%22%2C%20%22kind%22%3A%20%22Data%20management%22%2C%20%22meaning%22%3A%20%22A%20zero%20at%20the%20start%20of%20a%20code.%20Storing%20the%20code%20as%20a%20number%20loses%20it.%22%2C%20%22example%22%3A%20%220100305000%20becomes%20100305000%22%2C%20%22where%22%3A%20%5B(S%2C%20%22%C2%A74.1%22%2C%20%22%23%23%23%204.1%20Codes%20are%20text%22)%2C%20(G%2C%20%22%C2%A71%22%2C%20%22%23%23%201%20%C2%B7%20Read%20Round%201%20without%20losing%20anything%22)%5D%7D%2C%0A%20%20%20%20%20%20%20%20%7B%22term%22%3A%20%22value%20label%22%2C%20%22kind%22%3A%20%22Data%20management%22%2C%20%22meaning%22%3A%20%22A%20name%20for%20a%20coded%20value%2C%20kept%20beside%20the%20data%3A%201%20%3D%20Male.%22%2C%20%22example%22%3A%20%22c_sex%3A%201%20%3D%20Male%2C%202%20%3D%20Female%22%2C%20%22where%22%3A%20%5B(G%2C%20%22%C2%A71%22%2C%20%22%23%23%201%20%C2%B7%20Read%20Round%201%20without%20losing%20anything%22)%5D%7D%2C%0A%20%20%20%20%20%20%20%20%7B%22term%22%3A%20%22round%22%2C%20%22kind%22%3A%20%22Data%20management%22%2C%20%22meaning%22%3A%20%22One%20release%20of%20a%20recurring%20survey%2C%20named%20by%20year%20and%20quarter.%22%2C%20%22example%22%3A%20%222023Q4%22%2C%20%22where%22%3A%20%5B(G%2C%20%22%C2%A71%22%2C%20%22%23%23%201%20%C2%B7%20Read%20Round%201%20without%20losing%20anything%22)%5D%7D%2C%0A%20%20%20%20%20%20%20%20%7B%22term%22%3A%20%22role%22%2C%20%22kind%22%3A%20%22Data%20management%22%2C%20%22meaning%22%3A%20%22What%20a%20column%20means%20to%20the%20pipeline%20(area%20code%2C%20weight%E2%80%A6)%2C%20whatever%20the%20file%20calls%20it.%22%2C%20%22example%22%3A%20'area_code%20is%20the%20column%20%22psgc%22%20in%20Round%201'%2C%20%22where%22%3A%20%5B(G%2C%20%22%C2%A72%22%2C%20%22%23%23%202%20%C2%B7%20Describe%20the%20round%20in%20a%20configuration%20file%22)%5D%7D%2C%0A%20%20%20%20%20%20%20%20%7B%22term%22%3A%20%22configuration%22%2C%20%22kind%22%3A%20%22Data%20management%22%2C%20%22meaning%22%3A%20%22A%20small%20file%20saying%20how%20to%20read%20one%20round%3A%20which%20column%20plays%20which%20role%2C%20and%20your%20decisions.%20The%20pipeline%20reads%20it%20every%20time.%22%2C%20%22example%22%3A%20%22config%2Frounds%2F2023Q4.toml%22%2C%20%22where%22%3A%20%5B(G%2C%20%22%C2%A72%22%2C%20%22%23%23%202%20%C2%B7%20Describe%20the%20round%20in%20a%20configuration%20file%22)%5D%7D%2C%0A%20%20%20%20%20%20%20%20%7B%22term%22%3A%20%22TOML%22%2C%20%22kind%22%3A%20%22Data%20management%22%2C%20%22meaning%22%3A%20%22A%20simple%20text%20format%20for%20configuration%20files%3A%20name%20%3D%20value%20lines.%22%2C%20%22example%22%3A%20'round_id%20%3D%20%222023Q4%22'%2C%20%22where%22%3A%20%5B(G%2C%20%22%C2%A72%22%2C%20%22%23%23%202%20%C2%B7%20Describe%20the%20round%20in%20a%20configuration%20file%22)%5D%7D%2C%0A%20%20%20%20%20%20%20%20%7B%22term%22%3A%20%22validation%20(pydantic)%22%2C%20%22kind%22%3A%20%22Data%20management%22%2C%20%22meaning%22%3A%20%22Checking%20that%20data%20or%20a%20configuration%20has%20the%20right%20shape%20before%20using%20it%2C%20and%20refusing%20it%20with%20reasons%20if%20not.%22%2C%20%22example%22%3A%20%22RoundConfig(...)%20refuses%20round_id%20%3D%202023-4%22%2C%20%22where%22%3A%20%5B(S%2C%20%22%C2%A74.6%22%2C%20%22%23%23%23%204.6%20Classes%3A%20the%20shape%20of%20a%20record%22)%2C%20(G%2C%20%22%C2%A72%22%2C%20%22%23%23%23%20The%20shape%20of%20a%20configuration%22)%5D%7D%2C%0A%20%20%20%20%20%20%20%20%7B%22term%22%3A%20%22profile%22%2C%20%22kind%22%3A%20%22Data%20management%22%2C%20%22meaning%22%3A%20%22Describing%20a%20new%20table%20before%20using%20it%3A%20types%2C%20counts%2C%20missing%20values%2C%20ranges.%22%2C%20%22example%22%3A%20%22SUMMARIZE%20round1%22%2C%20%22where%22%3A%20%5B(G%2C%20%22%C2%A72%22%2C%20%22%23%23%23%20Look%20before%20you%20move%20on%22)%5D%7D%2C%0A%20%20%20%20%20%20%20%20%7B%22term%22%3A%20%22code%20list%20(PSGC)%22%2C%20%22kind%22%3A%20%22Data%20management%22%2C%20%22meaning%22%3A%20%22The%20official%20list%20of%20geographic%20codes%20with%20their%20names%20and%20levels.%22%2C%20%22example%22%3A%20%22reference%2Fpsgc_2023Q4.xlsx%22%2C%20%22where%22%3A%20%5B(G%2C%20%22%C2%A73%22%2C%20%22%23%23%203%20%C2%B7%20Reference%20data%22)%5D%7D%2C%0A%20%20%20%20%20%20%20%20%7B%22term%22%3A%20%22edition%22%2C%20%22kind%22%3A%20%22Data%20management%22%2C%20%22meaning%22%3A%20%22A%20version%20of%20a%20code%20list.%20Codes%20can%20change%20between%20editions%3B%20each%20round's%20configuration%20says%20which%20edition%20it%20uses.%22%2C%20%22example%22%3A%20%222023Q4%2C%202024Q2%22%2C%20%22where%22%3A%20%5B(G%2C%20%22%C2%A73%22%2C%20%22%23%23%203%20%C2%B7%20Reference%20data%22)%2C%20(E%2C%20%22%C2%A72%22%2C%20%22%23%23%202%20%C2%B7%20Find%20out%20why%2C%20in%20a%20fixed%20order%22)%5D%7D%2C%0A%20%20%20%20%20%20%20%20%7B%22term%22%3A%20%22key%22%2C%20%22kind%22%3A%20%22Data%20management%22%2C%20%22meaning%22%3A%20%22The%20column%20two%20tables%20are%20matched%20on.%20On%20the%20'one'%20side%20of%20a%20join%20it%20must%20be%20unique.%22%2C%20%22example%22%3A%20%22area_code%22%2C%20%22where%22%3A%20%5B(G%2C%20%22%C2%A73%22%2C%20%22%23%23%23%20What%20a%20join%20does%22)%2C%20(P%2C%20%22primer%206%22%2C%20%22%23%23%206%20%C2%B7%20Joins%22)%5D%7D%2C%0A%20%20%20%20%20%20%20%20%7B%22term%22%3A%20%22join%22%2C%20%22kind%22%3A%20%22Data%20management%22%2C%20%22meaning%22%3A%20%22Putting%20two%20tables%20side%20by%20side%20by%20matching%20a%20key.%20Compare%20row%20counts%20before%20and%20after.%22%2C%20%22example%22%3A%20%22round1%20joined%20to%20the%20code%20list%22%2C%20%22where%22%3A%20%5B(G%2C%20%22%C2%A73%22%2C%20%22%23%23%23%20What%20a%20join%20does%22)%2C%20(P%2C%20%22primer%206%22%2C%20%22%23%23%206%20%C2%B7%20Joins%22)%5D%7D%2C%0A%20%20%20%20%20%20%20%20%7B%22term%22%3A%20%22left%20join%22%2C%20%22kind%22%3A%20%22Data%20management%22%2C%20%22meaning%22%3A%20%22Keeps%20every%20row%20of%20the%20left%20table%3B%20rows%20without%20a%20match%20get%20empty%20values.%22%2C%20%22example%22%3A%20'how%3D%22left%22'%2C%20%22where%22%3A%20%5B(P%2C%20%22primer%206%22%2C%20%22%23%23%206%20%C2%B7%20Joins%22)%5D%7D%2C%0A%20%20%20%20%20%20%20%20%7B%22term%22%3A%20%22inner%20join%22%2C%20%22kind%22%3A%20%22Data%20management%22%2C%20%22meaning%22%3A%20%22Keeps%20only%20rows%20that%20found%20a%20match%3B%20others%20disappear%20without%20warning.%22%2C%20%22example%22%3A%20'how%3D%22inner%22'%2C%20%22where%22%3A%20%5B(P%2C%20%22primer%206%22%2C%20%22%23%23%206%20%C2%B7%20Joins%22)%5D%7D%2C%0A%20%20%20%20%20%20%20%20%7B%22term%22%3A%20%22anti-join%22%2C%20%22kind%22%3A%20%22Data%20management%22%2C%20%22meaning%22%3A%20%22Keeps%20only%20the%20left%20rows%20that%20found%20no%20match%3A%20the%20records%20to%20report.%22%2C%20%22example%22%3A%20%22LEFT%20JOIN%20%E2%80%A6%20WHERE%20c.code%20IS%20NULL%22%2C%20%22where%22%3A%20%5B(G%2C%20%22Exercise%203.3%22%2C%20%22%23%23%23%20Exercise%203.3.%22)%2C%20(P%2C%20%22primer%206%22%2C%20%22%23%23%206%20%C2%B7%20Joins%22)%5D%7D%2C%0A%20%20%20%20%20%20%20%20%7B%22term%22%3A%20%22validate%20(many_to_one)%22%2C%20%22kind%22%3A%20%22Data%20management%22%2C%20%22meaning%22%3A%20%22Tells%20a%20join%20which%20side%20must%20be%20unique%2C%20so%20it%20refuses%20instead%20of%20copying%20rows.%22%2C%20%22example%22%3A%20'validate%3D%22many_to_one%22'%2C%20%22where%22%3A%20%5B(G%2C%20%22Exercise%203.2%22%2C%20%22%23%23%23%20Exercise%203.2.%22)%5D%7D%2C%0A%20%20%20%20%20%20%20%20%7B%22term%22%3A%20%22duplicate%22%2C%20%22kind%22%3A%20%22Data%20management%22%2C%20%22meaning%22%3A%20%22The%20same%20key%20more%20than%20once.%20On%20the%20code%20list%20side%20of%20a%20join%20it%20copies%20rows.%22%2C%20%22example%22%3A%20%22one%20city%20listed%20twice%22%2C%20%22where%22%3A%20%5B(G%2C%20%22%C2%A73%22%2C%20%22%23%23%23%20What%20a%20join%20does%22)%5D%7D%2C%0A%20%20%20%20%20%20%20%20%7B%22term%22%3A%20%22decision%20(with%20a%20reason)%22%2C%20%22kind%22%3A%20%22Data%20management%22%2C%20%22meaning%22%3A%20%22A%20choice%20code%20cannot%20make%20for%20you%2C%20saved%20with%20its%20reason%20so%20it%20can%20be%20reviewed%20later.%22%2C%20%22example%22%3A%20%22unmatched%20%3D%20keep-and-flag%22%2C%20%22where%22%3A%20%5B(G%2C%20%22%C2%A73%22%2C%20%22%23%23%23%20Decide%22)%5D%7D%2C%0A%20%20%20%20%20%20%20%20%7B%22term%22%3A%20%22read-only%22%2C%20%22kind%22%3A%20%22Data%20management%22%2C%20%22meaning%22%3A%20%22Opened%20so%20that%20nothing%20you%20do%20can%20change%20it.%20Always%20use%20it%20on%20another%20system's%20data.%22%2C%20%22example%22%3A%20%22(TYPE%20sqlite%2C%20READ_ONLY)%22%2C%20%22where%22%3A%20%5B(G%2C%20%22%C2%A73%22%2C%20%22%23%23%23%20Another%20system's%20database%22)%5D%7D%2C%0A%20%20%20%20%20%20%20%20%7B%22term%22%3A%20%22wide%20%2F%20long%22%2C%20%22kind%22%3A%20%22Data%20management%22%2C%20%22meaning%22%3A%20%22Wide%3A%20one%20column%20per%20year.%20Long%3A%20one%20row%20per%20region%20and%20year%3B%20better%20for%20checking%20and%20joining.%22%2C%20%22example%22%3A%20%22melt%20turns%20wide%20into%20long%22%2C%20%22where%22%3A%20%5B(G%2C%20%22%C2%A74%22%2C%20%22%23%23%23%20Wide%20and%20long%22)%5D%7D%2C%0A%20%20%20%20%20%20%20%20%7B%22term%22%3A%20%22placeholder%20(..%20and%20-)%22%2C%20%22kind%22%3A%20%22Data%20management%22%2C%20%22meaning%22%3A%20%22Marks%20in%20a%20published%20table%20where%20there%20is%20no%20number%3A%20..%20not%20available%2C%20-%20not%20applicable.%20Both%20become%20missing%2C%20never%20zero.%22%2C%20%22example%22%3A%20'%22..%22%20gives%20(None%2C%20%22not%20available%22)'%2C%20%22where%22%3A%20%5B(G%2C%20%22Exercise%204.2%22%2C%20%22%23%23%23%20Exercise%204.2.%22)%5D%7D%2C%0A%20%20%20%20%20%20%20%20%7B%22term%22%3A%20%22API%22%2C%20%22kind%22%3A%20%22Data%20management%22%2C%20%22meaning%22%3A%20%22A%20web%20address%20that%20answers%20with%20data%20(often%20JSON)%20instead%20of%20a%20page.%22%2C%20%22example%22%3A%20%22the%20portal's%20population%20API%22%2C%20%22where%22%3A%20%5B(G%2C%20%22%C2%A74%22%2C%20%22%23%23%23%20The%20same%20table%20from%20the%20API%22)%5D%7D%2C%0A%20%20%20%20%20%20%20%20%7B%22term%22%3A%20%22JSON%22%2C%20%22kind%22%3A%20%22Data%20management%22%2C%20%22meaning%22%3A%20%22Text%20made%20of%20objects%20%7B%20%7D%20and%20arrays%20%5B%20%5D%2C%20like%20Python's%20dictionaries%20and%20lists.%22%2C%20%22example%22%3A%20'%7B%22key%22%3A%20%5B%2201%22%2C%20%222019%22%5D%2C%20%22values%22%3A%20%5B%221746085%22%5D%7D'%2C%20%22where%22%3A%20%5B(P%2C%20%22primer%208%22%2C%20%22%23%23%208%20%C2%B7%20JSON%22)%5D%7D%2C%0A%20%20%20%20%20%20%20%20%7B%22term%22%3A%20%22page%20(pagination)%22%2C%20%22kind%22%3A%20%22Data%20management%22%2C%20%22meaning%22%3A%20%22An%20API's%20answer%20split%20into%20parts%2C%20each%20naming%20the%20next%20one.%22%2C%20%22example%22%3A%20'%22next%22%3A%20%22page-2.json%22'%2C%20%22where%22%3A%20%5B(G%2C%20%22Exercise%204.3%22%2C%20%22%23%23%23%20Exercise%204.3.%22)%2C%20(W%2C%20%22Exercise%205.1%22%2C%20%22%23%23%23%20Exercise%205.1.%20Every%20page%20of%20a%20Datasette%20table%22)%5D%7D%2C%0A%20%20%20%20%20%20%20%20%7B%22term%22%3A%20%22weight%22%2C%20%22kind%22%3A%20%22Data%20management%22%2C%20%22meaning%22%3A%20%22How%20many%20people%20in%20the%20population%20a%20respondent%20stands%20for.%22%2C%20%22example%22%3A%20%22a%20weight%20of%20600%22%2C%20%22where%22%3A%20%5B(P%2C%20%22primer%207%22%2C%20%22%23%23%207%20%C2%B7%20What%20a%20survey%20weight%20is%22)%5D%7D%2C%0A%20%20%20%20%20%20%20%20%7B%22term%22%3A%20%22weighted%20count%22%2C%20%22kind%22%3A%20%22Data%20management%22%2C%20%22meaning%22%3A%20%22The%20sum%20of%20the%20weights%3A%20an%20estimate%20of%20how%20many%20people%20there%20are.%22%2C%20%22example%22%3A%20'round1%5B%22weight%22%5D.sum()'%2C%20%22where%22%3A%20%5B(P%2C%20%22primer%207%22%2C%20%22%23%23%207%20%C2%B7%20What%20a%20survey%20weight%20is%22)%5D%7D%2C%0A%20%20%20%20%20%20%20%20%7B%22term%22%3A%20%22reconcile%22%2C%20%22kind%22%3A%20%22Data%20management%22%2C%20%22meaning%22%3A%20%22Compare%20your%20totals%20with%20an%20independent%20source%2C%20and%20explain%20the%20differences.%22%2C%20%22example%22%3A%20%22Round%201%20against%20the%20published%20population%22%2C%20%22where%22%3A%20%5B(G%2C%20%22Exercise%204.4%22%2C%20%22%23%23%23%20Exercise%204.4.%22)%5D%7D%2C%0A%20%20%20%20%20%20%20%20%7B%22term%22%3A%20%22tolerance%22%2C%20%22kind%22%3A%20%22Data%20management%22%2C%20%22meaning%22%3A%20%22How%20far%20apart%20two%20figures%20may%20be%20before%20someone%20should%20look.%22%2C%20%22example%22%3A%20%221%20%25%22%2C%20%22where%22%3A%20%5B(P%2C%20%22primer%209%22%2C%20%22%23%23%209%20%C2%B7%20Percent%20difference%22)%5D%7D%2C%0A%20%20%20%20%20%20%20%20%7B%22term%22%3A%20%22staging%22%2C%20%22kind%22%3A%20%22Data%20management%22%2C%20%22meaning%22%3A%20%22Writing%20a%20round%2C%20read%20and%20joined%20but%20not%20yet%20checked%2C%20to%20the%20course%20database.%22%2C%20%22example%22%3A%20%22the%20table%20staging_2023q4%22%2C%20%22where%22%3A%20%5B(G%2C%20%22%C2%A75%22%2C%20%22%23%23%205%20%C2%B7%20One%20function%20for%20the%20whole%20stage%22)%5D%7D%2C%0A%20%20%20%20%20%20%20%20%7B%22term%22%3A%20%22pipeline%22%2C%20%22kind%22%3A%20%22Data%20management%22%2C%20%22meaning%22%3A%20%22The%20steps%20that%20take%20a%20round%20from%20its%20file%20to%20a%20release%2C%20run%20the%20same%20way%20every%20time.%22%2C%20%22example%22%3A%20%22Get%20%E2%86%92%20Check%20%E2%86%92%20Store%20%E2%86%92%20Share%22%2C%20%22where%22%3A%20%5B(G%2C%20%22%C2%A75%22%2C%20%22%23%23%205%20%C2%B7%20One%20function%20for%20the%20whole%20stage%22)%5D%7D%2C%0A%20%20%20%20%20%20%20%20%23%20Check%20and%20Store%3A%20checking%2C%20cleaning%2C%20storing%0A%20%20%20%20%20%20%20%20%7B%22term%22%3A%20%22contract%22%2C%20%22kind%22%3A%20%22Data%20management%22%2C%20%22meaning%22%3A%20%22The%20rules%20a%20correct%20round%20must%20meet%2C%20written%20once%20and%20checked%20by%20a%20program%20on%20every%20round.%22%2C%20%22example%22%3A%20%22survey_schema(...)%22%2C%20%22where%22%3A%20%5B(C%2C%20%22%C2%A72%22%2C%20%22%23%23%202%20%C2%B7%20The%20contract%3A%20rules%20written%20once%22)%5D%7D%2C%0A%20%20%20%20%20%20%20%20%7B%22term%22%3A%20%22schema%20(pandera)%22%2C%20%22kind%22%3A%20%22pandas%22%2C%20%22meaning%22%3A%20%22pandera's%20way%20to%20write%20a%20contract%3A%20one%20entry%20per%20column%20(type%2C%20may%20it%20be%20missing%2C%20checks)%2C%20plus%20rules%20on%20several%20columns.%22%2C%20%22example%22%3A%20'pa.DataFrameSchema(%7B%22age%22%3A%20pa.Column(float%2C%20pa.Check.in_range(0%2C%20120))%7D)'%2C%20%22where%22%3A%20%5B(C%2C%20%22%C2%A72%22%2C%20%22%23%23%202%20%C2%B7%20The%20contract%3A%20rules%20written%20once%22)%2C%20(P%2C%20%22primer%2011%22%2C%20%22%23%23%2011%20%C2%B7%20Rules%20with%20pandera%22)%5D%7D%2C%0A%20%20%20%20%20%20%20%20%7B%22term%22%3A%20%22lazy%20validation%22%2C%20%22kind%22%3A%20%22pandas%22%2C%20%22meaning%22%3A%20%22Checking%20every%20rule%20on%20every%20row%20before%20reporting%2C%20so%20all%20failures%20come%20at%20once%20(lazy%3DTrue).%22%2C%20%22example%22%3A%20%22schema.validate(table%2C%20lazy%3DTrue)%22%2C%20%22where%22%3A%20%5B(P%2C%20%22primer%2011%22%2C%20%22%23%23%2011%20%C2%B7%20Rules%20with%20pandera%22)%2C%20(B%2C%20%22bug%204%22%2C%20%22%23%23%20Bug%204%20%C2%B7%20Counting%20failures%22)%5D%7D%2C%0A%20%20%20%20%20%20%20%20%7B%22term%22%3A%20%22failure%20report%22%2C%20%22kind%22%3A%20%22Data%20management%22%2C%20%22meaning%22%3A%20%22The%20table%20of%20every%20failure%20a%20validation%20found%3A%20column%2C%20rule%2C%20value%2C%20row.%22%2C%20%22example%22%3A%20%22errors.failure_cases%22%2C%20%22where%22%3A%20%5B(C%2C%20%22%C2%A72%22%2C%20%22%23%23%23%20Run%20the%20contract%20on%20Round%202%22)%5D%7D%2C%0A%20%20%20%20%20%20%20%20%7B%22term%22%3A%20%22nullable%22%2C%20%22kind%22%3A%20%22pandas%22%2C%20%22meaning%22%3A%20%22A%20column%20that%20may%20hold%20missing%20values.%20Without%20nullable%3DTrue%2C%20a%20missing%20value%20is%20a%20failure.%22%2C%20%22example%22%3A%20%22pa.Column(float%2C%20nullable%3DTrue)%22%2C%20%22where%22%3A%20%5B(C%2C%20%22Exercise%202.1%22%2C%20%22%23%23%23%20Exercise%202.1.%20The%20contract%20for%20a%20survey%20round%22)%5D%7D%2C%0A%20%20%20%20%20%20%20%20%7B%22term%22%3A%20%22coerce%22%2C%20%22kind%22%3A%20%22pandas%22%2C%20%22meaning%22%3A%20%22Convert%20a%20column%20to%20the%20schema's%20type%20before%20checking%20it%2C%20such%20as%20whole%20numbers%20to%20decimals.%22%2C%20%22example%22%3A%20%22pa.Column(float%2C%20coerce%3DTrue)%22%2C%20%22where%22%3A%20%5B(C%2C%20%22Exercise%202.1%22%2C%20%22%23%23%23%20Exercise%202.1.%20The%20contract%20for%20a%20survey%20round%22)%5D%7D%2C%0A%20%20%20%20%20%20%20%20%7B%22term%22%3A%20%22warning%20check%22%2C%20%22kind%22%3A%20%22Data%20management%22%2C%20%22meaning%22%3A%20%22A%20check%20that%20reports%20instead%20of%20failing%20(raise_warning%3DTrue)%3A%20for%20the%20unusual%2C%20not%20the%20impossible.%22%2C%20%22example%22%3A%20%22totals%202.6%20%25%20from%20the%20published%20figure%22%2C%20%22where%22%3A%20%5B(C%2C%20%22%C2%A73%22%2C%20%22%23%23%203%20%C2%B7%20Warnings%2C%20and%20looking%20before%20you%20change%20a%20rule%22)%5D%7D%2C%0A%20%20%20%20%20%20%20%20%7B%22term%22%3A%20%22cleaning%20as%20code%22%2C%20%22kind%22%3A%20%22Data%20management%22%2C%20%22meaning%22%3A%20%22Fixing%20data%20with%20code%20that%20runs%20again%20on%20every%20round%20and%20reports%20what%20it%20changed%2C%20never%20by%20editing%20the%20file.%22%2C%20%22example%22%3A%20%22clean_round(...)%22%2C%20%22where%22%3A%20%5B(C%2C%20%22%C2%A74%22%2C%20%22%23%23%204%20%C2%B7%20Cleaning%20as%20code%2C%20part%201%22)%5D%7D%2C%0A%20%20%20%20%20%20%20%20%7B%22term%22%3A%20%22exact%20duplicate%22%2C%20%22kind%22%3A%20%22Data%20management%22%2C%20%22meaning%22%3A%20%22The%20same%20row%20twice%2C%20every%20value%20equal.%20One%20copy%20goes.%22%2C%20%22example%22%3A%20%22table.drop_duplicates()%22%2C%20%22where%22%3A%20%5B(C%2C%20%22Exercise%204.1%22%2C%20%22%23%23%23%20Exercise%204.1.%22)%5D%7D%2C%0A%20%20%20%20%20%20%20%20%7B%22term%22%3A%20%22duplicate%20rule%22%2C%20%22kind%22%3A%20%22Data%20management%22%2C%20%22meaning%22%3A%20%22The%20written%20rule%20that%20says%20which%20row%20stays%20when%20the%20same%20person%20appears%20with%20different%20values.%22%2C%20%22example%22%3A%20%22first%20in%20the%20file%2C%20or%20fewer%20missing%20values%22%2C%20%22where%22%3A%20%5B(C%2C%20%22%C2%A74%22%2C%20%22%23%23%23%20Decide%3A%20which%20copy%20wins%20in%20Round%202%3F%22)%5D%7D%2C%0A%20%20%20%20%20%20%20%20%7B%22term%22%3A%20%22missing-value%20code%20(not%20stated)%22%2C%20%22kind%22%3A%20%22Data%20management%22%2C%20%22meaning%22%3A%20%22A%20value%20that%20means%20'not%20given'%2C%20such%20as%20999%20for%20age%20or%209%20for%20sex.%20It%20must%20become%20missing%20before%20any%20total.%22%2C%20%22example%22%3A%20%22age%20999%22%2C%20%22where%22%3A%20%5B(C%2C%20%22Exercise%204.2%22%2C%20%22%23%23%23%20Exercise%204.2.%22)%5D%7D%2C%0A%20%20%20%20%20%20%20%20%7B%22term%22%3A%20%22lookup%20table%22%2C%20%22kind%22%3A%20%22Data%20management%22%2C%20%22meaning%22%3A%20%22A%20table%20of%20codes%20and%20their%20labels%2C%20used%20by%20a%20join%20to%20recode.%22%2C%20%22example%22%3A%20%22lookup_sex%3A%201%20Male%2C%202%20Female%22%2C%20%22where%22%3A%20%5B(C%2C%20%22Exercise%205.1%22%2C%20%22%23%23%23%20Exercise%205.1.%22)%5D%7D%2C%0A%20%20%20%20%20%20%20%20%7B%22term%22%3A%20%22cleaning%20report%22%2C%20%22kind%22%3A%20%22Data%20management%22%2C%20%22meaning%22%3A%20%22One%20row%20per%20cleaning%20step%3A%20rows%20before%20and%20after%2C%20values%20changed%2C%20and%20why.%22%2C%20%22example%22%3A%20%22values%20changed%3A%2015%22%2C%20%22where%22%3A%20%5B(C%2C%20%22%C2%A75%22%2C%20%22%23%23%23%20The%20whole%20cleaning%2C%20as%20one%20function%22)%5D%7D%2C%0A%20%20%20%20%20%20%20%20%7B%22term%22%3A%20%22constraint%22%2C%20%22kind%22%3A%20%22SQL%22%2C%20%22meaning%22%3A%20%22A%20rule%20a%20database%20table%20enforces%20on%20every%20row%20it%20is%20given.%22%2C%20%22example%22%3A%20%22CHECK%20(age%20BETWEEN%200%20AND%20120)%22%2C%20%22where%22%3A%20%5B(D%2C%20%22%C2%A71%22%2C%20%22%23%23%201%20%C2%B7%20What%20a%20constraint%20is%22)%2C%20(P%2C%20%22primer%2012%22%2C%20%22%23%23%2012%20%C2%B7%20Database%20constraints%22)%5D%7D%2C%0A%20%20%20%20%20%20%20%20%7B%22term%22%3A%20%22primary%20key%22%2C%20%22kind%22%3A%20%22SQL%22%2C%20%22meaning%22%3A%20%22The%20columns%20that%20identify%20a%20row%3A%20no%20two%20rows%20may%20share%20them.%22%2C%20%22example%22%3A%20%22PRIMARY%20KEY%20(round%2C%20hhid%2C%20member_no)%22%2C%20%22where%22%3A%20%5B(D%2C%20%22%C2%A71%22%2C%20%22%23%23%201%20%C2%B7%20What%20a%20constraint%20is%22)%5D%7D%2C%0A%20%20%20%20%20%20%20%20%7B%22term%22%3A%20%22NOT%20NULL%22%2C%20%22kind%22%3A%20%22SQL%22%2C%20%22meaning%22%3A%20%22A%20column%20that%20may%20never%20be%20missing.%22%2C%20%22example%22%3A%20%22weight%20DOUBLE%20NOT%20NULL%22%2C%20%22where%22%3A%20%5B(D%2C%20%22%C2%A71%22%2C%20%22%23%23%201%20%C2%B7%20What%20a%20constraint%20is%22)%5D%7D%2C%0A%20%20%20%20%20%20%20%20%7B%22term%22%3A%20%22CHECK%20constraint%22%2C%20%22kind%22%3A%20%22SQL%22%2C%20%22meaning%22%3A%20%22A%20condition%20every%20row%20must%20meet.%20A%20missing%20value%20does%20not%20break%20it%3B%20NOT%20NULL%20does%20that.%22%2C%20%22example%22%3A%20%22CHECK%20(sex%20IN%20('1'%2C%20'2'))%22%2C%20%22where%22%3A%20%5B(D%2C%20%22%C2%A72%22%2C%20%22%23%23%202%20%C2%B7%20Every%20rule%20written%20once%22)%5D%7D%2C%0A%20%20%20%20%20%20%20%20%7B%22term%22%3A%20%22foreign%20key%20(REFERENCES)%22%2C%20%22kind%22%3A%20%22SQL%22%2C%20%22meaning%22%3A%20%22A%20column%20whose%20value%20must%20exist%20in%20another%20table.%22%2C%20%22example%22%3A%20%22area_code%20VARCHAR%20REFERENCES%20areas%20(code)%22%2C%20%22where%22%3A%20%5B(D%2C%20%22%C2%A71%22%2C%20%22%23%23%201%20%C2%B7%20What%20a%20constraint%20is%22)%2C%20(P%2C%20%22primer%2012%22%2C%20%22%23%23%2012%20%C2%B7%20Database%20constraints%22)%5D%7D%2C%0A%20%20%20%20%20%20%20%20%7B%22term%22%3A%20%22CREATE%20TABLE%22%2C%20%22kind%22%3A%20%22SQL%22%2C%20%22meaning%22%3A%20%22The%20SQL%20statement%20that%20defines%20a%20table%3A%20its%20columns%2C%20types%20and%20constraints.%20Here%20it%20is%20generated%20from%20the%20contract.%22%2C%20%22example%22%3A%20%22CREATE%20TABLE%20persons%20(...)%22%2C%20%22where%22%3A%20%5B(D%2C%20%22%C2%A72%22%2C%20%22%23%23%202%20%C2%B7%20Every%20rule%20written%20once%22)%5D%7D%2C%0A%20%20%20%20%20%20%20%20%7B%22term%22%3A%20%22area_code_reported%22%2C%20%22kind%22%3A%20%22Data%20management%22%2C%20%22meaning%22%3A%20%22The%20area%20code%20exactly%20as%20the%20file%20gave%20it.%20area_code%20holds%20it%20only%20when%20it%20is%20in%20the%20code%20list%2C%20so%20the%20foreign%20key%20holds.%22%2C%20%22example%22%3A%20%220600399000%20reported%2C%20area_code%20empty%22%2C%20%22where%22%3A%20%5B(D%2C%20%22%C2%A73%22%2C%20%22%23%23%203%20%C2%B7%20Safe%20loads%22)%5D%7D%2C%0A%20%20%20%20%20%20%20%20%7B%22term%22%3A%20%22transaction%22%2C%20%22kind%22%3A%20%22SQL%22%2C%20%22meaning%22%3A%20%22Steps%20kept%20all%20together%20(COMMIT)%20or%20undone%20all%20together%20(ROLLBACK).%22%2C%20%22example%22%3A%20%22BEGIN%20TRANSACTION%20%E2%80%A6%20COMMIT%22%2C%20%22where%22%3A%20%5B(D%2C%20%22%C2%A73%22%2C%20%22%23%23%203%20%C2%B7%20Safe%20loads%22)%2C%20(P%2C%20%22primer%2013%22%2C%20%22%23%23%2013%20%C2%B7%20Transactions%22)%5D%7D%2C%0A%20%20%20%20%20%20%20%20%7B%22term%22%3A%20%22idempotent%22%2C%20%22kind%22%3A%20%22Data%20management%22%2C%20%22meaning%22%3A%20%22Running%20it%20twice%20gives%20the%20same%20result%20as%20running%20it%20once.%20A%20load%20that%20deletes%20the%20round%20before%20inserting%20it%20is%20idempotent.%22%2C%20%22example%22%3A%20%22load%20twice%3A%2017%2C967%20rows%20both%20times%22%2C%20%22where%22%3A%20%5B(D%2C%20%22Exercise%203.1%22%2C%20%22%23%23%23%20Exercise%203.1.%20Load%20a%20round%20safely%22)%5D%7D%2C%0A%20%20%20%20%20%20%20%20%7B%22term%22%3A%20%22query%20parameter%20(%3F)%22%2C%20%22kind%22%3A%20%22SQL%22%2C%20%22meaning%22%3A%20%22A%20%3F%20in%20a%20query%2C%20filled%20in%20by%20the%20database%20with%20a%20value%20you%20pass%20separately%3A%20safer%20than%20putting%20the%20value%20into%20the%20text.%22%2C%20%22example%22%3A%20'con.execute(%22DELETE%20FROM%20persons%20WHERE%20round%20%3D%20%3F%22%2C%20%5Bround_id%5D)'%2C%20%22where%22%3A%20%5B(D%2C%20%22Exercise%203.1%22%2C%20%22%23%23%23%20Exercise%203.1.%20Load%20a%20round%20safely%22)%5D%7D%2C%0A%20%20%20%20%20%20%20%20%7B%22term%22%3A%20%22layer%22%2C%20%22kind%22%3A%20%22Data%20management%22%2C%20%22meaning%22%3A%20%22One%20of%20the%20pipeline's%20lines%20of%20defence%3A%20Get%2C%20the%20contract%2C%20the%20cleaning%2C%20the%20database.%20Each%20catches%20different%20problems.%22%2C%20%22example%22%3A%20%22%22%2C%20%22where%22%3A%20%5B(D%2C%20%22%C2%A74%22%2C%20%22%23%23%204%20%C2%B7%20Which%20layer%20catches%20what%22)%5D%7D%2C%0A%20%20%20%20%20%20%20%20%7B%22term%22%3A%20%22debugging%22%2C%20%22kind%22%3A%20%22Python%22%2C%20%22meaning%22%3A%20%22Finding%20why%20code%20gives%20a%20wrong%20result%3A%20read%20the%20error%2C%20find%20the%20line%2C%20look%20at%20the%20values%2C%20fix%2C%20check%20again.%22%2C%20%22example%22%3A%20%22%22%2C%20%22where%22%3A%20%5B(B%2C%20%22the%20drill%22%2C%20%22%23%20Debugging%20drill%22)%2C%20(P%2C%20%22primer%2010%22%2C%20%22%23%23%2010%20%C2%B7%20Reading%20an%20error%22)%5D%7D%2C%0A%20%20%20%20%20%20%20%20%23%20marimo%20and%20the%20course%0A%20%20%20%20%20%20%20%20%7B%22term%22%3A%20%22cell%22%2C%20%22kind%22%3A%20%22marimo%22%2C%20%22meaning%22%3A%20%22One%20block%20of%20code%20in%20a%20notebook%3B%20its%20result%20shows%20above%20it.%22%2C%20%22example%22%3A%20%22%22%2C%20%22where%22%3A%20%5B(S%2C%20%22%C2%A72%22%2C%20%22%23%23%202%20%C2%B7%20How%20a%20marimo%20notebook%20works%22)%5D%7D%2C%0A%20%20%20%20%20%20%20%20%7B%22term%22%3A%20%22multiple%20definitions%22%2C%20%22kind%22%3A%20%22marimo%22%2C%20%22meaning%22%3A%20%22marimo's%20message%20when%20two%20cells%20create%20the%20same%20name.%20Rename%20one%2C%20or%20start%20it%20with%20_.%22%2C%20%22example%22%3A%20%22_total%22%2C%20%22where%22%3A%20%5B(S%2C%20%22%C2%A72%22%2C%20%22%23%23%202%20%C2%B7%20How%20a%20marimo%20notebook%20works%22)%5D%7D%2C%0A%20%20%20%20%20%20%20%20%7B%22term%22%3A%20%22exercise%20check%22%2C%20%22kind%22%3A%20%22marimo%22%2C%20%22meaning%22%3A%20%22The%20box%20under%20an%20exercise%3A%20it%20runs%20your%20function%20on%20several%20inputs%20and%20says%20grey%2C%20green%20or%20red.%22%2C%20%22example%22%3A%20%22%22%2C%20%22where%22%3A%20%5B(S%2C%20%22%C2%A73.6%22%2C%20%22%23%23%23%203.6%20How%20the%20exercises%20work%22)%5D%7D%2C%0A%20%20%20%20%20%20%20%20%7B%22term%22%3A%20%22Try%20it%20cell%22%2C%20%22kind%22%3A%20%22marimo%22%2C%20%22meaning%22%3A%20%22A%20cell%20under%20each%20exercise%20that%20calls%20your%20function%20and%20shows%20what%20it%20gives%20back.%22%2C%20%22example%22%3A%20%22course.try_it(code_to_text%2C%20100305000.0%2C%2010)%22%2C%20%22where%22%3A%20%5B(G%2C%20%22Exercise%201.1%22%2C%20%22%23%23%23%20Exercise%201.1.%22)%5D%7D%2C%0A%20%20%20%20%20%20%20%20%7B%22term%22%3A%20%22run.py%22%2C%20%22kind%22%3A%20%22marimo%22%2C%20%22meaning%22%3A%20%22The%20one%20command%20that%20runs%20your%20pipeline%20on%20a%20round%2C%20using%20your%20notebook's%20functions.%22%2C%20%22example%22%3A%20%22uv%20run%20python%20run.py%20--round%202023Q4%22%2C%20%22where%22%3A%20%5B(G%2C%20%22%C2%A75%22%2C%20%22%23%23%23%20Run%20it%20from%20the%20terminal%22)%5D%7D%2C%0A%20%20%20%20%20%20%20%20%23%20A%20new%20edition%20and%20Share%0A%20%20%20%20%20%20%20%20%7B%22term%22%3A%20%22crosswalk%22%2C%20%22kind%22%3A%20%22Data%20management%22%2C%20%22meaning%22%3A%20%22A%20table%20that%20translates%20codes%20of%20one%20edition%20into%20another's%3A%20one%20row%20per%20pair%20of%20codes%20covering%20the%20same%20ground.%22%2C%20%22example%22%3A%20%22code_2024q2%200100306000%20%E2%86%92%20code_2023q4%200100304000%22%2C%20%22where%22%3A%20%5B(E%2C%20%22%C2%A73%22%2C%20%22%23%23%203%20%C2%B7%20Making%20rounds%20comparable%20across%20editions%22)%2C%20(P%2C%20%22primer%2014%22%2C%20%22%23%23%2014%20%C2%B7%20Crosswalks%20between%20editions%22)%5D%7D%2C%0A%20%20%20%20%20%20%20%20%7B%22term%22%3A%20%22split%20(of%20an%20area)%22%2C%20%22kind%22%3A%20%22Data%20management%22%2C%20%22meaning%22%3A%20%22One%20area%20becoming%20two%20in%20a%20new%20edition.%20New%20%E2%86%92%20old%20is%20safe%3B%20old%20%E2%86%92%20new%20cannot%20say%20which%20part%20a%20person%20lives%20in.%22%2C%20%22example%22%3A%20%220100304000%20%E2%86%92%200100304000%20and%200100306000%22%2C%20%22where%22%3A%20%5B(E%2C%20%22%C2%A73%22%2C%20%22%23%23%23%23%20Concept%3A%20a%20crosswalk%20has%20a%20direction%22)%2C%20(X%2C%20%22S3.3%22%2C%20%22%23%23%20S3.3%20%C2%B7%20The%20crosswalk%20the%20other%20way%2C%20by%20shares%22)%5D%7D%2C%0A%20%20%20%20%20%20%20%20%7B%22term%22%3A%20%22one_to_many%22%2C%20%22kind%22%3A%20%22pandas%22%2C%20%22meaning%22%3A%20%22validate%3D%20value%20for%20a%20join%20where%20each%20left%20row%20may%20match%20several%20right%20rows%2C%20but%20each%20right%20key%20appears%20once%20on%20the%20left.%22%2C%20%22example%22%3A%20'totals.merge(crosswalk%2C%20...%2C%20validate%3D%22one_to_many%22)'%2C%20%22where%22%3A%20%5B(X%2C%20%22S3.3%22%2C%20%22%23%23%20S3.3%20%C2%B7%20The%20crosswalk%20the%20other%20way%2C%20by%20shares%22)%5D%7D%2C%0A%20%20%20%20%20%20%20%20%7B%22term%22%3A%20%22release%22%2C%20%22kind%22%3A%20%22Data%20management%22%2C%20%22meaning%22%3A%20%22What%20leaves%20the%20office%3A%20a%20folder%20of%20files%20built%20by%20code%20from%20the%20database%2C%20the%20same%20way%20every%20round.%22%2C%20%22example%22%3A%20%22release%2F2024Q2%2F%22%2C%20%22where%22%3A%20%5B(R%2C%20%22%C2%A71%22%2C%20%22%23%23%201%20%C2%B7%20What%20each%20audience%20gets%22)%5D%7D%2C%0A%20%20%20%20%20%20%20%20%7B%22term%22%3A%20%22microdata%22%2C%20%22kind%22%3A%20%22Data%20management%22%2C%20%22meaning%22%3A%20%22One%20row%20per%20respondent.%20Kept%20inside%20the%20office%3B%20a%20release%20publishes%20tables%20built%20from%20it.%22%2C%20%22example%22%3A%20%22the%20persons%20table%22%2C%20%22where%22%3A%20%5B(R%2C%20%22%C2%A72%22%2C%20%22%23%23%202%20%C2%B7%20The%20release%20table%22)%5D%7D%2C%0A%20%20%20%20%20%20%20%20%7B%22term%22%3A%20%22respondents%22%2C%20%22kind%22%3A%20%22Data%20management%22%2C%20%22meaning%22%3A%20%22How%20many%20people%20a%20cell%20is%20built%20from%20(rows)%2C%20as%20opposed%20to%20how%20many%20people%20it%20estimates%20(weights).%22%2C%20%22example%22%3A%20%2212%20respondents%2C%205%2C010%20weighted%20persons%22%2C%20%22where%22%3A%20%5B(R%2C%20%22Exercise%202.2%22%2C%20%22%23%23%23%20Exercise%202.2.%20People%20by%20province%2C%20sex%20and%20age%20group%22)%5D%7D%2C%0A%20%20%20%20%20%20%20%20%7B%22term%22%3A%20%22small-cell%20suppression%22%2C%20%22kind%22%3A%20%22Data%20management%22%2C%20%22meaning%22%3A%20%22Publishing%20a%20cell%20empty%2C%20and%20marked%2C%20when%20it%20is%20built%20from%20fewer%20respondents%20than%20a%20threshold.%22%2C%20%22example%22%3A%20%22fewer%20than%2030%20respondents%22%2C%20%22where%22%3A%20%5B(R%2C%20%22%C2%A73%22%2C%20%22%23%23%203%20%C2%B7%20Small-cell%20suppression%22)%2C%20(P%2C%20%22primer%2015%22%2C%20%22%23%23%2015%20%C2%B7%20Small-cell%20suppression%22)%5D%7D%2C%0A%20%20%20%20%20%20%20%20%7B%22term%22%3A%20%22complementary%20suppression%22%2C%20%22kind%22%3A%20%22Data%20management%22%2C%20%22meaning%22%3A%20%22Hiding%20a%20second%20cell%20so%20that%20a%20hidden%20cell%20cannot%20be%20worked%20out%20from%20a%20published%20total.%22%2C%20%22example%22%3A%20%22total%20minus%20the%20visible%20cells%22%2C%20%22where%22%3A%20%5B(P%2C%20%22primer%2015%22%2C%20%22%23%23%2015%20%C2%B7%20Small-cell%20suppression%22)%2C%20(X%2C%20%22S3.1%22%2C%20%22%23%23%20S3.1%20%C2%B7%20Complementary%20suppression%22)%5D%7D%2C%0A%20%20%20%20%20%20%20%20%7B%22term%22%3A%20%22threshold%22%2C%20%22kind%22%3A%20%22Data%20management%22%2C%20%22meaning%22%3A%20%22The%20smallest%20number%20of%20respondents%20a%20published%20cell%20may%20be%20built%20from.%22%2C%20%22example%22%3A%20%22THRESHOLD%20%3D%2030%22%2C%20%22where%22%3A%20%5B(R%2C%20%22Exercise%203.1%22%2C%20%22%23%23%23%20Exercise%203.1.%20Suppress%20small%20cells%22)%5D%7D%2C%0A%20%20%20%20%20%20%20%20%7B%22term%22%3A%20%22codebook%22%2C%20%22kind%22%3A%20%22Data%20management%22%2C%20%22meaning%22%3A%20%22What%20each%20column%20of%20a%20dataset%20means%2C%20its%20type%2C%20whether%20it%20may%20be%20empty%2C%20and%20its%20rules.%20Here%2C%20generated%20from%20the%20contract.%22%2C%20%22example%22%3A%20%22codebook.csv%22%2C%20%22where%22%3A%20%5B(R%2C%20%22%C2%A74%22%2C%20%22%23%23%204%20%C2%B7%20The%20codebook%2C%20from%20the%20contract%22)%5D%7D%2C%0A%20%20%20%20%20%20%20%20%7B%22term%22%3A%20%22Parquet%22%2C%20%22kind%22%3A%20%22Data%20management%22%2C%20%22meaning%22%3A%20%22A%20file%20format%20that%20keeps%20each%20column's%20type%20inside%20the%20file%3A%20small%20and%20fast%20for%20analysts.%22%2C%20%22example%22%3A%20%22release_table.parquet%22%2C%20%22where%22%3A%20%5B(R%2C%20%22%C2%A71%22%2C%20%22%23%23%201%20%C2%B7%20What%20each%20audience%20gets%22)%2C%20(P%2C%20%22primer%2016%22%2C%20%22%23%23%2016%20%C2%B7%20File%20formats%22)%5D%7D%2C%0A%20%20%20%20%20%20%20%20%7B%22term%22%3A%20%22Table%20Schema%22%2C%20%22kind%22%3A%20%22Data%20management%22%2C%20%22meaning%22%3A%20%22A%20JSON%20file%20beside%20a%20CSV%20that%20says%20each%20column's%20name%2C%20type%2C%20description%20and%20whether%20it%20is%20required.%22%2C%20%22example%22%3A%20%22release_table.schema.json%22%2C%20%22where%22%3A%20%5B(R%2C%20%22%C2%A75%22%2C%20%22%23%23%205%20%C2%B7%20Write%20the%20files%2C%20and%20check%20every%20one%22)%2C%20(P%2C%20%22primer%2016%22%2C%20%22%23%23%2016%20%C2%B7%20File%20formats%22)%5D%7D%2C%0A%20%20%20%20%20%20%20%20%7B%22term%22%3A%20%22SQLite%22%2C%20%22kind%22%3A%20%22SQL%22%2C%20%22meaning%22%3A%20%22A%20whole%20database%20in%20one%20file%2C%20readable%20by%20almost%20any%20program.%20The%20release's%20file%20for%20the%20portal.%22%2C%20%22example%22%3A%20%22release.sqlite%22%2C%20%22where%22%3A%20%5B(R%2C%20%22%C2%A71%22%2C%20%22%23%23%201%20%C2%B7%20What%20each%20audience%20gets%22)%2C%20(P%2C%20%22primer%2016%22%2C%20%22%23%23%2016%20%C2%B7%20File%20formats%22)%5D%7D%2C%0A%20%20%20%20%20%20%20%20%7B%22term%22%3A%20%22round%20trip%22%2C%20%22kind%22%3A%20%22Data%20management%22%2C%20%22meaning%22%3A%20%22Writing%20a%20file%20and%20reading%20it%20back%2C%20to%20check%20that%20what%20comes%20back%20is%20what%20was%20written.%22%2C%20%22example%22%3A%20%22check_release(folder)%22%2C%20%22where%22%3A%20%5B(R%2C%20%22Exercise%205.1%22%2C%20%22%23%23%23%20Exercise%205.1.%20Open%20every%20file%20you%20wrote%22)%2C%20(P%2C%20%22primer%2016%22%2C%20%22%23%23%2016%20%C2%B7%20File%20formats%22)%5D%7D%2C%0A%20%20%20%20%20%20%20%20%7B%22term%22%3A%20%22data%20portal%22%2C%20%22kind%22%3A%20%22Data%20management%22%2C%20%22meaning%22%3A%20%22A%20website%20where%20anyone%20can%20browse%2C%20filter%20and%20download%20published%20data%2C%20and%20programs%20can%20read%20it.%22%2C%20%22example%22%3A%20%22http%3A%2F%2F127.0.0.1%3A8001%22%2C%20%22where%22%3A%20%5B(W%2C%20%22%C2%A71%22%2C%20%22%23%23%201%20%C2%B7%20What%20Datasette%20is%22)%5D%7D%2C%0A%20%20%20%20%20%20%20%20%7B%22term%22%3A%20%22Datasette%22%2C%20%22kind%22%3A%20%22Data%20management%22%2C%20%22meaning%22%3A%20%22A%20program%20that%20turns%20a%20SQLite%20file%20into%20a%20data%20portal%20and%20a%20JSON%20API.%20The%20course%20uses%20version%201.0a41.%22%2C%20%22example%22%3A%20%22uv%20run%20datasette%20serve%20release.sqlite%22%2C%20%22where%22%3A%20%5B(W%2C%20%22%C2%A71%22%2C%20%22%23%23%201%20%C2%B7%20What%20Datasette%20is%22)%2C%20(P%2C%20%22primer%2017%22%2C%20%22%23%23%2017%20%C2%B7%20Datasette%20addresses%20and%20APIs%22)%5D%7D%2C%0A%20%20%20%20%20%20%20%20%7B%22term%22%3A%20%22metadata%20(Datasette)%22%2C%20%22kind%22%3A%20%22Data%20management%22%2C%20%22meaning%22%3A%20%22What%20the%20data%20means%3A%20titles%2C%20descriptions%2C%20source.%20Given%20with%20-m%20metadata.json.%22%2C%20%22example%22%3A%20'%7B%22title%22%3A%20%22Labour%20survey%20release%2C%20round%202024Q2%22%7D'%2C%20%22where%22%3A%20%5B(W%2C%20%22%C2%A72%22%2C%20%22%23%23%202%20%C2%B7%20Describe%20the%20release%22)%5D%7D%2C%0A%20%20%20%20%20%20%20%20%7B%22term%22%3A%20%22configuration%20(Datasette)%22%2C%20%22kind%22%3A%20%22Data%20management%22%2C%20%22meaning%22%3A%20%22How%20Datasette%20behaves%3A%20facets%2C%20canned%20queries%2C%20permissions.%20Given%20with%20-c%20datasette.json.%22%2C%20%22example%22%3A%20'%7B%22facets%22%3A%20%5B%22sex%22%2C%20%22age_group%22%5D%7D'%2C%20%22where%22%3A%20%5B(W%2C%20%22%C2%A74%22%2C%20%22%23%23%204%20%C2%B7%20Start%20the%20portal%22)%2C%20(P%2C%20%22primer%2017%22%2C%20%22%23%23%2017%20%C2%B7%20Datasette%20addresses%20and%20APIs%22)%5D%7D%2C%0A%20%20%20%20%20%20%20%20%7B%22term%22%3A%20%22canned%20query%22%2C%20%22kind%22%3A%20%22SQL%22%2C%20%22meaning%22%3A%20%22A%20SQL%20query%20saved%20in%20the%20portal's%20configuration%2C%20with%20a%20name%3B%20visitors%20fill%20in%20its%20parameters%20in%20a%20form.%22%2C%20%22example%22%3A%20%22region_summary%22%2C%20%22where%22%3A%20%5B(W%2C%20%22%C2%A73%22%2C%20%22%23%23%203%20%C2%B7%20A%20canned%20query%22)%5D%7D%2C%0A%20%20%20%20%20%20%20%20%7B%22term%22%3A%20%22named%20parameter%20(%3Aname)%22%2C%20%22kind%22%3A%20%22SQL%22%2C%20%22meaning%22%3A%20%22A%20%3Aname%20in%20a%20query%2C%20filled%20with%20a%20value%20passed%20separately%3B%20never%20read%20as%20SQL.%22%2C%20%22example%22%3A%20%22WHERE%20substr(province%2C%201%2C%202)%20%3D%20%3Aregion%22%2C%20%22where%22%3A%20%5B(W%2C%20%22Exercise%203.1%22%2C%20%22%23%23%23%20Exercise%203.1.%20People%20by%20province%20and%20sex%2C%20for%20one%20region%22)%5D%7D%2C%0A%20%20%20%20%20%20%20%20%7B%22term%22%3A%20%22facet%22%2C%20%22kind%22%3A%20%22Data%20management%22%2C%20%22meaning%22%3A%20%22Counts%20of%20rows%20for%20each%20value%20of%20a%20column%2C%20shown%20above%20a%20table%3B%20click%20one%20to%20filter.%22%2C%20%22example%22%3A%20%22%3F_facet%3Dage_group%22%2C%20%22where%22%3A%20%5B(W%2C%20%22%C2%A74%22%2C%20%22%23%23%23%20The%20visitor's%20checklist%22)%2C%20(P%2C%20%22primer%2017%22%2C%20%22%23%23%2017%20%C2%B7%20Datasette%20addresses%20and%20APIs%22)%5D%7D%2C%0A%20%20%20%20%20%20%20%20%7B%22term%22%3A%20%22truncated%22%2C%20%22kind%22%3A%20%22Data%20management%22%2C%20%22meaning%22%3A%20%22An%20answer%20cut%20at%20a%20row%20limit%2C%20with%20rows%20missing.%20A%20program%20must%20stop%2C%20not%20use%20it%20as%20if%20complete.%22%2C%20%22example%22%3A%20'%22truncated%22%3A%20true'%2C%20%22where%22%3A%20%5B(W%2C%20%22Exercise%205.1%22%2C%20%22%23%23%23%20Exercise%205.1.%20Every%20page%20of%20a%20Datasette%20table%22)%5D%7D%2C%0A%20%20%20%20%20%20%20%20%7B%22term%22%3A%20%22capstone%22%2C%20%22kind%22%3A%20%22Data%20management%22%2C%20%22meaning%22%3A%20%22The%20last%20afternoon's%20project%2C%20done%20in%20groups%3A%20the%20next%20round%20through%20your%20pipeline%2C%20your%20own%20data%20through%20the%20four%20stages%2C%20or%20one%20tool%20taken%20further.%20Each%20group%20presents%20it.%22%2C%20%22example%22%3A%20%2233_capstone_next_round.py%2C%2034_capstone_own_data.py%2C%2035_capstone_explore.py%22%2C%20%22where%22%3A%20%5B(K%2C%20%22%C2%A71%22%2C%20%22%23%23%201%20%C2%B7%20The%20brief%22)%5D%7D%2C%0A%20%20%20%20%20%20%20%20%7B%22term%22%3A%20%22largest%20remainder%22%2C%20%22kind%22%3A%20%22Data%20management%22%2C%20%22meaning%22%3A%20%22Rounding%20parts%20so%20they%20add%20up%20to%20their%20rounded%20total%3A%20round%20down%2C%20then%20give%20the%20spare%20units%20to%20the%20largest%20remainders.%22%2C%20%22example%22%3A%20%22334%20%2B%20333%20%2B%20333%20%3D%201%2C000%22%2C%20%22where%22%3A%20%5B(X%2C%20%22S3.2%22%2C%20%22%23%23%20S3.2%20%C2%B7%20Parts%20that%20add%20up%20to%20the%20whole%22)%5D%7D%2C%0A%20%20%20%20%20%20%20%20%7B%22term%22%3A%20%22fuzzy%20matching%22%2C%20%22kind%22%3A%20%22Data%20management%22%2C%20%22meaning%22%3A%20%22Matching%20names%20that%20are%20written%20differently%2C%20by%20similarity.%20A%20close%20match%20is%20a%20guess%20for%20a%20person%20to%20confirm.%22%2C%20%22example%22%3A%20%22Cabiaa%20%E2%89%88%20Cabiao%22%2C%20%22where%22%3A%20%5B(X%2C%20%22S3.5%22%2C%20%22%23%23%20S3.5%20%C2%B7%20Matching%20names%20to%20codes%22)%5D%7D%2C%0A%20%20%20%20%5D%0A%0A%0A%40app.cell(hide_code%3DTrue)%0Adef%20_()%3A%0A%20%20%20%20mo.md(r%22%22%22%0A%20%20%20%20%23%20Glossary%0A%0A%20%20%20%20The%20words%20the%20course%20uses%2C%20in%20plain%20language.%20Type%20in%20the%20box%20to%20find%20one%3B%20each%20entry%20says%20where%20you%20meet%20it%2C%20with%20a%20link%20to%20that%20notebook.%0A%20%20%20%20%22%22%22)%0A%20%20%20%20return%0A%0A%0A%40app.cell(hide_code%3DTrue)%0Adef%20_()%3A%0A%20%20%20%20search%20%3D%20mo.ui.text(placeholder%3D%22type%20a%20word%2C%20like%20join%20or%20weight%22%2C%20label%3D%22Find%3A%22%2C%20full_width%3DTrue)%0A%20%20%20%20kind%20%3D%20mo.ui.dropdown(options%3D%5B%22all%22%2C%20%22Python%22%2C%20%22pandas%22%2C%20%22SQL%22%2C%20%22Data%20management%22%2C%20%22marimo%22%5D%2C%20value%3D%22all%22%2C%20label%3D%22Kind%3A%22)%0A%20%20%20%20mo.hstack(%5Bsearch%2C%20kind%5D%2C%20justify%3D%22start%22%2C%20gap%3D2%2C%20widths%3D%5B3%2C%201%5D)%0A%20%20%20%20return%20kind%2C%20search%0A%0A%0A%40app.cell(hide_code%3DTrue)%0Adef%20_(kind%2C%20search)%3A%0A%20%20%20%20_needle%20%3D%20search.value.strip().lower()%0A%20%20%20%20_found%20%3D%20%5B%0A%20%20%20%20%20%20%20%20t%20for%20t%20in%20sorted(TERMS%2C%20key%3Dlambda%20t%3A%20t%5B%22term%22%5D.lower())%0A%20%20%20%20%20%20%20%20if%20(kind.value%20%3D%3D%20%22all%22%20or%20t%5B%22kind%22%5D%20%3D%3D%20kind.value)%0A%20%20%20%20%20%20%20%20and%20(not%20_needle%20or%20_needle%20in%20t%5B%22term%22%5D.lower()%20or%20_needle%20in%20t%5B%22meaning%22%5D.lower())%0A%20%20%20%20%5D%0A%0A%20%20%20%20def%20_entry(t)%3A%0A%20%20%20%20%20%20%20%20where%20%3D%20%22%3B%20%22.join(f%22%5B%7Bnb%7D%5D(%7B'%2F%3Ffile%3D'%20%2B%20nb%7D)%2C%20%7Bplace%7D%22%20for%20nb%2C%20place%2C%20_%20in%20t%5B%22where%22%5D)%0A%20%20%20%20%20%20%20%20example%20%3D%20f%22%5Cn%5Cn%60%7Bt%5B'example'%5D%7D%60%22%20if%20t%5B%22example%22%5D%20and%20%22%5Cn%22%20not%20in%20t%5B%22example%22%5D%20else%20(f%22%5Cn%5Cn%60%60%60python%5Cn%7Bt%5B'example'%5D%7D%5Cn%60%60%60%22%20if%20t%5B%22example%22%5D%20else%20%22%22)%0A%20%20%20%20%20%20%20%20return%20f%22**%7Bt%5B'term'%5D%7D**%20%C2%B7%20*%7Bt%5B'kind'%5D%7D*%5Cn%5Cn%7Bt%5B'meaning'%5D%7D%7Bexample%7D%5Cn%5CnWhere%3A%20%7Bwhere%7D%22%0A%0A%20%20%20%20mo.vstack(%5B%0A%20%20%20%20%20%20%20%20mo.md(f%22%7Blen(_found)%7D%20of%20%7Blen(TERMS)%7D%20terms.%22)%2C%0A%20%20%20%20%20%20%20%20*%5Bmo.md(_entry(t))%20for%20t%20in%20_found%5D%2C%0A%20%20%20%20%5D%20if%20_found%20else%20%5Bmo.md(f%22No%20term%20matches%20*%7Bsearch.value%7D*.%20Try%20a%20shorter%20word.%22)%5D)%0A%20%20%20%20return%0A%0A%0Aif%20__name__%20%3D%3D%20%22__main__%22%3A%0A%20%20%20%20app.run()%0A
ab413d14e50da9f1be05cae50408e650