Merging and Choropleths

1. Choropleths

1.1. colormap

1.2. discrete versus continuous

1.3. area effect

2. code

2.1. nbViewer

2.2. notebookfile

2.3. DataLore

3. Reshaping

3.1. Wide to Long

3.1.1. you avoid missing cells

3.1.2. easier for complex plots and some longitudinal methods

3.2. Long to Wide

3.2.1. easier to compute stats for unit of analysis

3.3. These processes help discover issues

3.3.1. key repetitions

3.3.2. key mistypying

4. Re scaling

4.1. Normalization (min-max)

4.2. Standardization

5. Appending

5.1. Direction

5.1.1. Horizontal

5.1.2. Vertical

5.2. Conditions

5.2.1. Condition 1: All DFs share the same column names.

5.2.2. Condition 2: All the DFs columns are in the same location.

5.2.3. Condition 3: All the DFs columns have the same data types.

6. Merging

6.1. Key

6.1.1. DFs to be merged must share common column values in one or several columns

6.2. Default result

6.2.1. only rows whose keys are mutual in both DFs

6.2.2. you can request rows whose keys do not atch

6.3. Fuzzy Merge

6.3.1. Algorithm to match similar keys

6.3.1.1. not one algorithm