save_keys.py

key1l1 = "Household 1,Household 2,Household 2,Household 3,Household 4,Household 5,Household 6,Household 7,Household 7,Household 8,Household 8,Household 9,Household 10,Household 10,Household 11,Household 11,Household 12,Household 13,Household 14,Household 14,Household 15,Household 15,Household 16,Household 17,Household 18,Household 18,Household 18,Household 19,Household 20,Household 21,Household 21,Household 22,Household 23,Household 23,Household 23,Household 24,Household 24,Household 25,Household 25,Household 25,Household 26,Household 27,Household 27,Household 28,Household 28,Household 29,Household 30,Household 30,Household 30,Household 30,Household 30,Household 30,Household 31,Household 31,Household 32,Household 32,Household 33,Household 33,Household 33,Household 34,Household 34,Household 34,Household 34,Household 35,Household 35,Household 36,Household 37,Household 37,Household 38,Household 39,Household 39,Household 39,Household 40,Household 40,Household 41,Household 41,Household 42,Household 42,Household 43,Household 43,Household 44,Household 44,Household 44,Household 45,Household 46,Household 46,Household 47,Household 48,Household 48,Household 48,Household 49,Household 49,Household 50,Household 50,Household 51,Household 51,Household 52,Household 52,Household 53,Household 53,Household 54,Household 54,Household 55,Household 55,Household 56,Household 57,Household 57,Household 57,Household 58,Household 58,Household 59,Household 60,Household 61,Household 62,Household 62,Household 63,Household 63,Household 64,Household 64,Household 65,Household 66,Household 67,Household 67,Household 68,Household 69,Household 70,Household 70,Household 71,Household 72,Household 73,Household 73,Household 74,Household 75,Household 75,Household 76,Household 76,Household 77,Household 77,Household 78,Household 79,Household 80,Household 81,Household 81,Household 81,Household 81,Household 81,Household 82,Household 82,Household 83,Household 83,Household 84,Household 85,Household 85,Household 86,Household 86,Household 87,Household 87,Household 87,Household 88,Household 88,Household 88,Household 89,Household 89,Household 90,Household 91,Household 91,Household 92,Household 92,Household 92,Household 92,Household 92,Household 92,Household 93,Household 93,Household 94,Household 94,Household 95,Household 95,Household 96,Household 96,Household 96,Household 97,Household 97,Household 98,Household 98,Household 99,Household 100,Household 101,Household 102,Household 103,Household 103,Household 104,Household 105,Household 105,Household 106,Household 107,Household 108,Household 108,Household 109,Household 110,Household 110,Household 111,Household 112,Household 113,Household 113,Household 114,Household 114,Household 115,Household 116,Household 116,Household 117,Household 117,Household 118,Household 118,Household 119,Household 119,Household 120,Household 120,Household 121,Household 121,Household 122,Household 123,Household 123,Household 124,Household 124,Household 125,Household 126,Household 126,Household 127,Household 128,Household 129,Household 129,Household 130,Household 130,Household 131,Household 131,Household 131,Household 132,Household 133,Household 134,Household 134,Household 134,Household 135,Household 135,Household 136,Household 137,Household 138,Household 138,Household 139,Household 139,Household 140,Household 141,Household 141,Household 142,Household 142,Household 143,Household 143,Household 144,Household 144,Household 145,Household 146,Household 146,Household 147,Household 148,Household 149,Household 149,Household 150,Household 150,Household 151,Household 151,Household 151,Household 152,Household 152,Household 153,Household 154,Household 155,Household 155,Household 156,Household 157,Household 158,Household 158,Household 158,Household 158,Household 158,Household 159,Household 160,Household 160,Household 160,Household 161,Household 162,Household 162,Household 163,Household 164,Household 165,Household 165,Household 166,Household 167,Household 167,Household 168,Household 168,Household 169,Household 170,Household 170,Household 171,Household 171,Household 172,Household 173,Household 174,Household 174,Household 175,Household 175,Household 176,Household 176,Household 177,Household 178,Household 179,Household 179,Household 180,Household 180,Household 181,Household 182,Household 183,Household 183,Household 184,Household 185,Household 186,Household 186,Household 187,Household 188,Household 188,Household 189,Household 190,Household 190,Household 191,Household 192,Household 192,Household 193,Household 194,Household 194,Household 195,Household 196,Household 196,Household 197,Household 198,Household 199,Household 199,Household 200,Household 200"
key2l1 = "Vehicle 1,Vehicle 2,Vehicle 3,Vehicle 4,Vehicle 5,Vehicle 6,Vehicle 7,Vehicle 8,Vehicle 9,Vehicle 10,Vehicle 11,Vehicle 12,Vehicle 13,Vehicle 14,Vehicle 15,Vehicle 16,Vehicle 17,Vehicle 18,Vehicle 19,Vehicle 20,Vehicle 21,Vehicle 22,Vehicle 23,Vehicle 24,Vehicle 25,Vehicle 26,Vehicle 27,Vehicle 28,Vehicle 29,Vehicle 30,Vehicle 31,Vehicle 32,Vehicle 33,Vehicle 34,Vehicle 35,Vehicle 36,Vehicle 37,Vehicle 38,Vehicle 39,Vehicle 40,Vehicle 41,Vehicle 42,Vehicle 43,Vehicle 44,Vehicle 45,Vehicle 46,Vehicle 47,Vehicle 48,Vehicle 49,Vehicle 50,Vehicle 51,Vehicle 52,Vehicle 53,Vehicle 54,Vehicle 55,Vehicle 56,Vehicle 57,Vehicle 58,Vehicle 59,Vehicle 60,Vehicle 61,Vehicle 62,Vehicle 63,Vehicle 64,Vehicle 65,Vehicle 66,Vehicle 67,Vehicle 68,Vehicle 69,Vehicle 70,Vehicle 71,Vehicle 72,Vehicle 73,Vehicle 74,Vehicle 75,Vehicle 76,Vehicle 77,Vehicle 78,Vehicle 79,Vehicle 80,Vehicle 81,Vehicle 82,Vehicle 83,Vehicle 84,Vehicle 85,Vehicle 86,Vehicle 87,Vehicle 88,Vehicle 89,Vehicle 90,Vehicle 91,Vehicle 92,Vehicle 93,Vehicle 94,Vehicle 95,Vehicle 96,Vehicle 97,Vehicle 98,Vehicle 99,Vehicle 100,Vehicle 101,Vehicle 102,Vehicle 103,Vehicle 104,Vehicle 105,Vehicle 106,Vehicle 107,Vehicle 108,Vehicle 109,Vehicle 110,Vehicle 111,Vehicle 112,Vehicle 113,Vehicle 114,Vehicle 115,Vehicle 116,Vehicle 117,Vehicle 118,Vehicle 119,Vehicle 120,Vehicle 121,Vehicle 122,Vehicle 123,Vehicle 124,Vehicle 125,Vehicle 126,Vehicle 127,Vehicle 128,Vehicle 129,Vehicle 130,Vehicle 131,Vehicle 132,Vehicle 133,Vehicle 134,Vehicle 135,Vehicle 136,Vehicle 137,Vehicle 138,Vehicle 139,Vehicle 140,Vehicle 141,Vehicle 142,Vehicle 143,Vehicle 144,Vehicle 145,Vehicle 146,Vehicle 147,Vehicle 148,Vehicle 149,Vehicle 150,Vehicle 151,Vehicle 152,Vehicle 153,Vehicle 154,Vehicle 155,Vehicle 156,Vehicle 157,Vehicle 158,Vehicle 159,Vehicle 160,Vehicle 161,Vehicle 162,Vehicle 163,Vehicle 164,Vehicle 165,Vehicle 166,Vehicle 167,Vehicle 168,Vehicle 169,Vehicle 170,Vehicle 171,Vehicle 172,Vehicle 173,Vehicle 174,Vehicle 175,Vehicle 176,Vehicle 177,Vehicle 178,Vehicle 179,Vehicle 180,Vehicle 181,Vehicle 182,Vehicle 183,Vehicle 184,Vehicle 185,Vehicle 186,Vehicle 187,Vehicle 188,Vehicle 189,Vehicle 190,Vehicle 191,Vehicle 192,Vehicle 193,Vehicle 194,Vehicle 195,Vehicle 196,Vehicle 197,Vehicle 198,Vehicle 199,Vehicle 200,Vehicle 201,Vehicle 202,Vehicle 203,Vehicle 204,Vehicle 205,Vehicle 206,Vehicle 207,Vehicle 208,Vehicle 209,Vehicle 210,Vehicle 211,Vehicle 212,Vehicle 213,Vehicle 214,Vehicle 215,Vehicle 216,Vehicle 217,Vehicle 218,Vehicle 219,Vehicle 220,Vehicle 221,Vehicle 222,Vehicle 223,Vehicle 224,Vehicle 225,Vehicle 226,Vehicle 227,Vehicle 228,Vehicle 229,Vehicle 230,Vehicle 231,Vehicle 232,Vehicle 233,Vehicle 234,Vehicle 235,Vehicle 236,Vehicle 237,Vehicle 238,Vehicle 239,Vehicle 240,Vehicle 241,Vehicle 242,Vehicle 243,Vehicle 244,Vehicle 245,Vehicle 246,Vehicle 247,Vehicle 248,Vehicle 249,Vehicle 250,Vehicle 251,Vehicle 252,Vehicle 253,Vehicle 254,Vehicle 255,Vehicle 256,Vehicle 257,Vehicle 258,Vehicle 259,Vehicle 260,Vehicle 261,Vehicle 262,Vehicle 263,Vehicle 264,Vehicle 265,Vehicle 266,Vehicle 267,Vehicle 268,Vehicle 269,Vehicle 270,Vehicle 271,Vehicle 272,Vehicle 273,Vehicle 274,Vehicle 275,Vehicle 276,Vehicle 277,Vehicle 278,Vehicle 279,Vehicle 280,Vehicle 281,Vehicle 282,Vehicle 283,Vehicle 284,Vehicle 285,Vehicle 286,Vehicle 287,Vehicle 288,Vehicle 289,Vehicle 290,Vehicle 291,Vehicle 292,Vehicle 293,Vehicle 294,Vehicle 295,Vehicle 296,Vehicle 297,Vehicle 298,Vehicle 299,Vehicle 300,Vehicle 301,Vehicle 302,Vehicle 303,Vehicle 304,Vehicle 305,Vehicle 306,Vehicle 307,Vehicle 308,Vehicle 309,Vehicle 310,Vehicle 311,Vehicle 312,Vehicle 313,Vehicle 314,Vehicle 315,Vehicle 316,Vehicle 317,Vehicle 318,Vehicle 319,Vehicle 320,Vehicle 321,Vehicle 322,Vehicle 323,Vehicle 324,Vehicle 325,Vehicle 326,Vehicle 327,Vehicle 328,Vehicle 329,Vehicle 330,Vehicle 331,Vehicle 332,Vehicle 333,Vehicle 334,Vehicle 335,Vehicle 336,Vehicle 337,Vehicle 338,Vehicle 339,Vehicle 340,Vehicle 341,Vehicle 342,Vehicle 343,Vehicle 344,Vehicle 345,Vehicle 346,Vehicle 347,Vehicle 348"

key1l2 = "Household 1,Household 2,Household 2,Household 3,Household 4,Household 5,Household 6,Household 7,Household 7,Household 8,Household 8,Household 9,Household 10,Household 10,Household 11,Household 11,Household 12,Household 13,Household 14,Household 14,Household 15,Household 15,Household 16,Household 17,Household 18,Household 18,Household 18,Household 19,Household 20,Household 21,Household 21,Household 22,Household 23,Household 23,Household 23,Household 24,Household 24,Household 25,Household 25,Household 25,Household 26,Household 27,Household 27,Household 28,Household 28,Household 29,Household 30,Household 30,Household 30,Household 30,Household 30,Household 30,Household 31,Household 31,Household 32,Household 32,Household 33,Household 33,Household 33,Household 34,Household 34,Household 34,Household 34,Household 35,Household 35,Household 36,Household 37,Household 37,Household 38,Household 39,Household 39,Household 39,Household 40,Household 40,Household 41,Household 41,Household 42,Household 42,Household 43,Household 43,Household 44,Household 44,Household 44,Household 45,Household 46,Household 46,Household 47,Household 48,Household 48,Household 48,Household 49,Household 49,Household 50,Household 50,Household 51,Household 51,Household 52,Household 52,Household 53,Household 53,Household 54,Household 54,Household 55,Household 55,Household 56,Household 57,Household 57,Household 57,Household 58,Household 58,Household 59,Household 60,Household 61,Household 62,Household 62,Household 63,Household 63,Household 64,Household 64,Household 65,Household 66,Household 67,Household 67,Household 68,Household 69,Household 70,Household 70,Household 71,Household 72,Household 73,Household 73,Household 74,Household 75,Household 75,Household 76,Household 76,Household 77,Household 77,Household 78,Household 79,Household 80,Household 81,Household 81,Household 81,Household 81,Household 81,Household 82,Household 82,Household 83,Household 83,Household 84,Household 85,Household 85,Household 86,Household 86,Household 87,Household 87,Household 87,Household 88,Household 88,Household 88,Household 89,Household 89,Household 90,Household 91,Household 91,Household 92,Household 92,Household 92,Household 92,Household 92,Household 92,Household 93,Household 93,Household 94,Household 94,Household 95,Household 95,Household 96,Household 96,Household 96,Household 97,Household 97,Household 98,Household 98,Household 99,Household 100,Household 101,Household 102,Household 103,Household 103,Household 104,Household 105,Household 105,Household 106,Household 107,Household 108,Household 108,Household 109,Household 110,Household 110,Household 111,Household 112,Household 113,Household 113,Household 114,Household 114,Household 115,Household 116,Household 116,Household 117,Household 117,Household 118,Household 118,Household 119,Household 119,Household 120,Household 120,Household 121,Household 121,Household 122,Household 123,Household 123,Household 124,Household 124,Household 125,Household 126,Household 126,Household 127,Household 128,Household 129,Household 129,Household 130,Household 130,Household 131,Household 131,Household 131,Household 132,Household 133,Household 134,Household 134,Household 134,Household 135,Household 135,Household 136,Household 137,Household 138,Household 138,Household 139,Household 139,Household 140,Household 141,Household 141,Household 142,Household 142,Household 143,Household 143,Household 144,Household 144,Household 145,Household 146,Household 146,Household 147,Household 148,Household 149,Household 149,Household 150,Household 150,Household 151,Household 151,Household 151,Household 152,Household 152,Household 153,Household 154,Household 155,Household 155,Household 156,Household 157,Household 158,Household 158,Household 158,Household 158,Household 158,Household 159,Household 160,Household 160,Household 160,Household 161,Household 162,Household 162,Household 163,Household 164,Household 165,Household 165,Household 166,Household 167,Household 167,Household 168,Household 168,Household 169,Household 170,Household 170,Household 171,Household 171,Household 172,Household 173,Household 174,Household 174,Household 175,Household 175,Household 176,Household 176,Household 177,Household 178,Household 179,Household 179,Household 180,Household 180,Household 181,Household 182,Household 183,Household 183,Household 184,Household 185,Household 186,Household 186,Household 187,Household 188,Household 188,Household 189,Household 190,Household 190,Household 191,Household 192,Household 192,Household 193,Household 194,Household 194,Household 195,Household 196,Household 196,Household 197,Household 198,Household 199,Household 199,Household 200,Household 200"
key2l2 = "Vehicle 1,Vehicle 2,Vehicle 3,Vehicle 4,Vehicle 5,Vehicle 6,Vehicle 7,Vehicle 8,Vehicle 9,Vehicle 10,Vehicle 11,Vehicle 12,Vehicle 13,Vehicle 14,Vehicle 15,Vehicle 16,Vehicle 17,Vehicle 18,Vehicle 19,Vehicle 20,Vehicle 21,Vehicle 22,Vehicle 23,Vehicle 24,Vehicle 25,Vehicle 26,Vehicle 27,Vehicle 28,Vehicle 29,Vehicle 30,Vehicle 31,Vehicle 32,Vehicle 33,Vehicle 34,Vehicle 35,Vehicle 36,Vehicle 37,Vehicle 38,Vehicle 39,Vehicle 40,Vehicle 41,Vehicle 42,Vehicle 43,Vehicle 44,Vehicle 45,Vehicle 46,Vehicle 47,Vehicle 48,Vehicle 49,Vehicle 50,Vehicle 51,Vehicle 52,Vehicle 53,Vehicle 54,Vehicle 55,Vehicle 56,Vehicle 57,Vehicle 58,Vehicle 59,Vehicle 60,Vehicle 61,Vehicle 62,Vehicle 63,Vehicle 64,Vehicle 65,Vehicle 66,Vehicle 67,Vehicle 68,Vehicle 69,Vehicle 70,Vehicle 71,Vehicle 72,Vehicle 73,Vehicle 74,Vehicle 75,Vehicle 76,Vehicle 77,Vehicle 78,Vehicle 79,Vehicle 80,Vehicle 81,Vehicle 82,Vehicle 83,Vehicle 84,Vehicle 85,Vehicle 86,Vehicle 87,Vehicle 88,Vehicle 89,Vehicle 90,Vehicle 91,Vehicle 92,Vehicle 93,Vehicle 94,Vehicle 95,Vehicle 96,Vehicle 97,Vehicle 98,Vehicle 99,Vehicle 100,Vehicle 101,Vehicle 102,Vehicle 103,Vehicle 104,Vehicle 105,Vehicle 106,Vehicle 107,Vehicle 108,Vehicle 109,Vehicle 110,Vehicle 111,Vehicle 112,Vehicle 113,Vehicle 114,Vehicle 115,Vehicle 116,Vehicle 117,Vehicle 118,Vehicle 119,Vehicle 120,Vehicle 121,Vehicle 122,Vehicle 123,Vehicle 124,Vehicle 125,Vehicle 126,Vehicle 127,Vehicle 128,Vehicle 129,Vehicle 130,Vehicle 131,Vehicle 132,Vehicle 133,Vehicle 134,Vehicle 135,Vehicle 136,Vehicle 137,Vehicle 138,Vehicle 139,Vehicle 140,Vehicle 141,Vehicle 142,Vehicle 143,Vehicle 144,Vehicle 145,Vehicle 146,Vehicle 147,Vehicle 148,Vehicle 149,Vehicle 150,Vehicle 151,Vehicle 152,Vehicle 153,Vehicle 154,Vehicle 155,Vehicle 156,Vehicle 157,Vehicle 158,Vehicle 159,Vehicle 160,Vehicle 161,Vehicle 162,Vehicle 163,Vehicle 164,Vehicle 165,Vehicle 166,Vehicle 167,Vehicle 168,Vehicle 169,Vehicle 170,Vehicle 171,Vehicle 172,Vehicle 173,Vehicle 174,Vehicle 175,Vehicle 176,Vehicle 177,Vehicle 178,Vehicle 179,Vehicle 180,Vehicle 181,Vehicle 182,Vehicle 183,Vehicle 184,Vehicle 185,Vehicle 186,Vehicle 187,Vehicle 188,Vehicle 189,Vehicle 190,Vehicle 191,Vehicle 192,Vehicle 193,Vehicle 194,Vehicle 195,Vehicle 196,Vehicle 197,Vehicle 198,Vehicle 199,Vehicle 200,Vehicle 201,Vehicle 202,Vehicle 203,Vehicle 204,Vehicle 205,Vehicle 206,Vehicle 207,Vehicle 208,Vehicle 209,Vehicle 210,Vehicle 211,Vehicle 212,Vehicle 213,Vehicle 214,Vehicle 215,Vehicle 216,Vehicle 217,Vehicle 218,Vehicle 219,Vehicle 220,Vehicle 221,Vehicle 222,Vehicle 223,Vehicle 224,Vehicle 225,Vehicle 226,Vehicle 227,Vehicle 228,Vehicle 229,Vehicle 230,Vehicle 231,Vehicle 232,Vehicle 233,Vehicle 234,Vehicle 235,Vehicle 236,Vehicle 237,Vehicle 238,Vehicle 239,Vehicle 240,Vehicle 241,Vehicle 242,Vehicle 243,Vehicle 244,Vehicle 245,Vehicle 246,Vehicle 247,Vehicle 248,Vehicle 249,Vehicle 250,Vehicle 251,Vehicle 252,Vehicle 253,Vehicle 254,Vehicle 255,Vehicle 256,Vehicle 257,Vehicle 258,Vehicle 259,Vehicle 260,Vehicle 261,Vehicle 262,Vehicle 263,Vehicle 264,Vehicle 265,Vehicle 266,Vehicle 267,Vehicle 268,Vehicle 269,Vehicle 270,Vehicle 271,Vehicle 272,Vehicle 273,Vehicle 274,Vehicle 275,Vehicle 276,Vehicle 277,Vehicle 278,Vehicle 279,Vehicle 280,Vehicle 281,Vehicle 282,Vehicle 283,Vehicle 284,Vehicle 285,Vehicle 286,Vehicle 287,Vehicle 288,Vehicle 289,Vehicle 290,Vehicle 291,Vehicle 292,Vehicle 293,Vehicle 294,Vehicle 295,Vehicle 296,Vehicle 297,Vehicle 298,Vehicle 299,Vehicle 300,Vehicle 301,Vehicle 302,Vehicle 303,Vehicle 304,Vehicle 305,Vehicle 306,Vehicle 307,Vehicle 308,Vehicle 309,Vehicle 310,Vehicle 311,Vehicle 312,Vehicle 313,Vehicle 314,Vehicle 315,Vehicle 316,Vehicle 317,Vehicle 318,Vehicle 319,Vehicle 320,Vehicle 321,Vehicle 322,Vehicle 323,Vehicle 324,Vehicle 325,Vehicle 326,Vehicle 327,Vehicle 328,Vehicle 329,Vehicle 330,Vehicle 331,Vehicle 332,Vehicle 333,Vehicle 334,Vehicle 335,Vehicle 336,Vehicle 337,Vehicle 338,Vehicle 339,Vehicle 340,Vehicle 341,Vehicle 342,Vehicle 343,Vehicle 344,Vehicle 345,Vehicle 346,Vehicle 347,Vehicle 348"

print(key1l1 == key1l2)
print(key2l1 == key2l2)

pairs = [[key, value] for key, value in zip(key2l1.split(","), key1l1.split(","))]
print(pairs)

lines = [key+","+value+"\n" for key,value in pairs]
lines = ["Vehicle,Household\n"]+lines
print(lines)

with open("raw_data/vehicles.csv", "w") as f:
    f.writelines(lines)

import pandas as pd
data = pd.read_csv("raw_data/vehicles.csv")
print(data)