Skip to content

Instantly share code, notes, and snippets.

@ricalanis

ricalanis/sfp-datos-opinion.ipynb

Created September 19, 2017 16:39
Show Gist options
  • Save ricalanis/1d7e663e8a884f88bbd73306d7b6cd21 to your computer and use it in GitHub Desktop.
Save ricalanis/1d7e663e8a884f88bbd73306d7b6cd21 to your computer and use it in GitHub Desktop.
Download ZIP
Display the source blob
Display the rendered blob
Raw
sfp-datos-opinion.ipynb
{
"cells": [
{
"cell_type": "code",
"execution_count": 1,
"metadata": {
"collapsed": true
},
"outputs": [],
"source": [
"import pandas as pd"
]
},
{
"cell_type": "code",
"execution_count": 2,
"metadata": {
"collapsed": true
},
"outputs": [],
"source": [
"data = pd.read_excel(\"encuesta_satisfaccion.xlsx\")"
]
},
{
"cell_type": "code",
"execution_count": 16,
"metadata": {},
"outputs": [
{
"data": {
"text/plain": [
"[166,\n",
" 169,\n",
" 171,\n",
" 172,\n",
" 173,\n",
" 174,\n",
" 175,\n",
" 178,\n",
" 179,\n",
" 180,\n",
" 182,\n",
" 183,\n",
" 184,\n",
" 186,\n",
" 188,\n",
" 189,\n",
" 190,\n",
" 191,\n",
" 192,\n",
" 193,\n",
" 194,\n",
" 195,\n",
" 196,\n",
" 197,\n",
" 198,\n",
" 199,\n",
" 200,\n",
" 202,\n",
" 203,\n",
" 204,\n",
" 208,\n",
" 209,\n",
" 210,\n",
" 212,\n",
" 213,\n",
" 214,\n",
" 215,\n",
" 216,\n",
" 217,\n",
" 218,\n",
" 219,\n",
" 221,\n",
" 222,\n",
" 223,\n",
" 224,\n",
" 225,\n",
" 226,\n",
" 227,\n",
" 228,\n",
" 229,\n",
" 230,\n",
" 231,\n",
" 232,\n",
" 233,\n",
" 235,\n",
" 236,\n",
" 242,\n",
" 243,\n",
" 244,\n",
" 245,\n",
" 246,\n",
" 247,\n",
" 248,\n",
" 249,\n",
" 251,\n",
" 254,\n",
" 255,\n",
" 256,\n",
" 257,\n",
" 258,\n",
" 259,\n",
" 260,\n",
" 261,\n",
" 263,\n",
" 264,\n",
" 265,\n",
" 266,\n",
" 267,\n",
" 268,\n",
" 270,\n",
" 271,\n",
" 272,\n",
" 273,\n",
" 274,\n",
" 275,\n",
" 276,\n",
" 277,\n",
" 278,\n",
" 282,\n",
" 283,\n",
" 284,\n",
" 286,\n",
" 287,\n",
" 288,\n",
" 289,\n",
" 291,\n",
" 293,\n",
" 296,\n",
" 298,\n",
" 299,\n",
" 300,\n",
" 301,\n",
" 302,\n",
" 303,\n",
" 304,\n",
" 305,\n",
" 306,\n",
" 307,\n",
" 308,\n",
" 309,\n",
" 311,\n",
" 312,\n",
" 313,\n",
" 315,\n",
" 317,\n",
" 320,\n",
" 321,\n",
" 322,\n",
" 323,\n",
" 324,\n",
" 326,\n",
" 327,\n",
" 328,\n",
" 329,\n",
" 330,\n",
" 331,\n",
" 332,\n",
" 333,\n",
" 334,\n",
" 335,\n",
" 336,\n",
" 339,\n",
" 340,\n",
" 341,\n",
" 344,\n",
" 345,\n",
" 346,\n",
" 347,\n",
" 348,\n",
" 350,\n",
" 351,\n",
" 352,\n",
" 353,\n",
" 354,\n",
" 355,\n",
" 356,\n",
" 357,\n",
" 358,\n",
" 363,\n",
" 364,\n",
" 366,\n",
" 368,\n",
" 369,\n",
" 370,\n",
" 372,\n",
" 373,\n",
" 374,\n",
" 375,\n",
" 376,\n",
" 377,\n",
" 381,\n",
" 383,\n",
" 384,\n",
" 385,\n",
" 387,\n",
" 388,\n",
" 389,\n",
" 390,\n",
" 391,\n",
" 392,\n",
" 393,\n",
" 395,\n",
" 396,\n",
" 397,\n",
" 398,\n",
" 399,\n",
" 400,\n",
" 401,\n",
" 402,\n",
" 403,\n",
" 404,\n",
" 405,\n",
" 406,\n",
" 407,\n",
" 409,\n",
" 410,\n",
" 411,\n",
" 412,\n",
" 413,\n",
" 414,\n",
" 415,\n",
" 416,\n",
" 418,\n",
" 419,\n",
" 420,\n",
" 422,\n",
" 424,\n",
" 425,\n",
" 427,\n",
" 428,\n",
" 430,\n",
" 431,\n",
" 432,\n",
" 434,\n",
" 435,\n",
" 436,\n",
" 437,\n",
" 438,\n",
" 439,\n",
" 440,\n",
" 441,\n",
" 442,\n",
" 443,\n",
" 444,\n",
" 445,\n",
" 446,\n",
" 447,\n",
" 449,\n",
" 450,\n",
" 452,\n",
" 453,\n",
" 454,\n",
" 455,\n",
" 457,\n",
" 458,\n",
" 459,\n",
" 460,\n",
" 461,\n",
" 462,\n",
" 463,\n",
" 464,\n",
" 465,\n",
" 466,\n",
" 467,\n",
" 468,\n",
" 469,\n",
" 470,\n",
" 471,\n",
" 472,\n",
" 473,\n",
" 474,\n",
" 476,\n",
" 477,\n",
" 478,\n",
" 479,\n",
" 480,\n",
" 481,\n",
" 483,\n",
" 484,\n",
" 486,\n",
" 491,\n",
" 492,\n",
" 493,\n",
" 495,\n",
" 496,\n",
" 497,\n",
" 498,\n",
" 499,\n",
" 500,\n",
" 501,\n",
" 502,\n",
" 503,\n",
" 504,\n",
" 507,\n",
" 508,\n",
" 510,\n",
" 511,\n",
" 512,\n",
" 513,\n",
" 514,\n",
" 515,\n",
" 516,\n",
" 517,\n",
" 519,\n",
" 520,\n",
" 521,\n",
" 522,\n",
" 523,\n",
" 524,\n",
" 526,\n",
" 527,\n",
" 530,\n",
" 531,\n",
" 532,\n",
" 534,\n",
" 536,\n",
" 539,\n",
" 540,\n",
" 541,\n",
" 543,\n",
" 546,\n",
" 547,\n",
" 548,\n",
" 549,\n",
" 550,\n",
" 551,\n",
" 552,\n",
" 553,\n",
" 555,\n",
" 556,\n",
" 557,\n",
" 558,\n",
" 559,\n",
" 560,\n",
" 562,\n",
" 563,\n",
" 564,\n",
" 565,\n",
" 566,\n",
" 567,\n",
" 568,\n",
" 569,\n",
" 570,\n",
" 571,\n",
" 573,\n",
" 574,\n",
" 575,\n",
" 576,\n",
" 577,\n",
" 578,\n",
" 579,\n",
" 581,\n",
" 582,\n",
" 583,\n",
" 584,\n",
" 585,\n",
" 586,\n",
" 587,\n",
" 588,\n",
" 589,\n",
" 590,\n",
" 593,\n",
" 595,\n",
" 596,\n",
" 598,\n",
" 599,\n",
" 600,\n",
" 602,\n",
" 603,\n",
" 604,\n",
" 606,\n",
" 607,\n",
" 608,\n",
" 610,\n",
" 613,\n",
" 614,\n",
" 615,\n",
" 616,\n",
" 617,\n",
" 618,\n",
" 619,\n",
" 621,\n",
" 622,\n",
" 623,\n",
" 624,\n",
" 625,\n",
" 626,\n",
" 627,\n",
" 628,\n",
" 629,\n",
" 631,\n",
" 633,\n",
" 636,\n",
" 637,\n",
" 639,\n",
" 640,\n",
" 641,\n",
" 642,\n",
" 643,\n",
" 644,\n",
" 645,\n",
" 646,\n",
" 647,\n",
" 648,\n",
" 649,\n",
" 651,\n",
" 653,\n",
" 654,\n",
" 656,\n",
" 658,\n",
" 659,\n",
" 660,\n",
" 661,\n",
" 663,\n",
" 665,\n",
" 666,\n",
" 667,\n",
" 668,\n",
" 669,\n",
" 670,\n",
" 671,\n",
" 672,\n",
" 679,\n",
" 683,\n",
" 684,\n",
" 685,\n",
" 686,\n",
" 687,\n",
" 688,\n",
" 689,\n",
" 690,\n",
" 692,\n",
" 693,\n",
" 694,\n",
" 695,\n",
" 696,\n",
" 697,\n",
" 698,\n",
" 700,\n",
" 701,\n",
" 702,\n",
" 703,\n",
" 704,\n",
" 709,\n",
" 711,\n",
" 712,\n",
" 713,\n",
" 714,\n",
" 715,\n",
" 718,\n",
" 719,\n",
" 720,\n",
" 721,\n",
" 722,\n",
" 723,\n",
" 724,\n",
" 725,\n",
" 726,\n",
" 727,\n",
" 728,\n",
" 729,\n",
" 730,\n",
" 731,\n",
" 732,\n",
" 735,\n",
" 736,\n",
" 737,\n",
" 738,\n",
" 739,\n",
" 740,\n",
" 742,\n",
" 743,\n",
" 744,\n",
" 746,\n",
" 747,\n",
" 748,\n",
" 750,\n",
" 753,\n",
" 754,\n",
" 755,\n",
" 758,\n",
" 759,\n",
" 760,\n",
" 761,\n",
" 763,\n",
" 764,\n",
" 765,\n",
" 768,\n",
" 769,\n",
" 770,\n",
" 771,\n",
" 772,\n",
" 773,\n",
" 774,\n",
" 779,\n",
" 780,\n",
" 781,\n",
" 784,\n",
" 785,\n",
" 787,\n",
" 788,\n",
" 789,\n",
" 790,\n",
" 791,\n",
" 792,\n",
" 793,\n",
" 794,\n",
" 795,\n",
" 797,\n",
" 799,\n",
" 800,\n",
" 801,\n",
" 802,\n",
" 803,\n",
" 806,\n",
" 808,\n",
" 809,\n",
" 811,\n",
" 812,\n",
" 814,\n",
" 815,\n",
" 816,\n",
" 817,\n",
" 818,\n",
" 819,\n",
" 821,\n",
" 822,\n",
" 823,\n",
" 824,\n",
" 825,\n",
" 826,\n",
" 827,\n",
" 828,\n",
" 829,\n",
" 830,\n",
" 831,\n",
" 835,\n",
" 838,\n",
" 839,\n",
" 840,\n",
" 841,\n",
" 842,\n",
" 843,\n",
" 844,\n",
" 845,\n",
" 846,\n",
" 847,\n",
" 848,\n",
" 849,\n",
" 850,\n",
" 851,\n",
" 852,\n",
" 853,\n",
" 855,\n",
" 856,\n",
" 857,\n",
" 858,\n",
" 859,\n",
" 860,\n",
" 861,\n",
" 862,\n",
" 863,\n",
" 864,\n",
" 865,\n",
" 866,\n",
" 867,\n",
" 869,\n",
" 870,\n",
" 872,\n",
" 873,\n",
" 874,\n",
" 875,\n",
" 876,\n",
" 878,\n",
" 879,\n",
" 880,\n",
" 882,\n",
" 884,\n",
" 885,\n",
" 886,\n",
" 887,\n",
" 889,\n",
" 890,\n",
" 892,\n",
" 894,\n",
" 895,\n",
" 896,\n",
" 897,\n",
" 899,\n",
" 900,\n",
" 901,\n",
" 902,\n",
" 904,\n",
" 905,\n",
" 907,\n",
" 908,\n",
" 909,\n",
" 911,\n",
" 912,\n",
" 914,\n",
" 915,\n",
" 916,\n",
" 918,\n",
" 919,\n",
" 920,\n",
" 922,\n",
" 925,\n",
" 926,\n",
" 927,\n",
" 928,\n",
" 929,\n",
" 930,\n",
" 931,\n",
" 933,\n",
" 934,\n",
" 935,\n",
" 936,\n",
" 937,\n",
" 938,\n",
" 939,\n",
" 941,\n",
" 942,\n",
" 943,\n",
" 944,\n",
" 945,\n",
" 946,\n",
" 947,\n",
" 948,\n",
" 949,\n",
" 950,\n",
" 951,\n",
" 952,\n",
" 953,\n",
" 954,\n",
" 955,\n",
" 956,\n",
" 957,\n",
" 959,\n",
" 961,\n",
" 962,\n",
" 963,\n",
" 964,\n",
" 966,\n",
" 967,\n",
" 970,\n",
" 972,\n",
" 973,\n",
" 974,\n",
" 976,\n",
" 977,\n",
" 978,\n",
" 979,\n",
" 980,\n",
" 981,\n",
" 982,\n",
" 983,\n",
" 984,\n",
" 985,\n",
" 986,\n",
" 987,\n",
" 989,\n",
" 990,\n",
" 991,\n",
" 994,\n",
" 995,\n",
" 999,\n",
" 1000,\n",
" 1001,\n",
" 1003,\n",
" 1004,\n",
" 1005,\n",
" 1006,\n",
" 1007,\n",
" 1008,\n",
" 1009,\n",
" 1010,\n",
" 1011,\n",
" 1012,\n",
" 1013,\n",
" 1016,\n",
" 1017,\n",
" 1018,\n",
" 1019,\n",
" 1020,\n",
" 1021,\n",
" 1022,\n",
" 1023,\n",
" 1024,\n",
" 1025,\n",
" 1026,\n",
" 1027,\n",
" 1028,\n",
" 1029,\n",
" 1030,\n",
" 1031,\n",
" 1033,\n",
" 1034,\n",
" 1037,\n",
" 1038,\n",
" 1040,\n",
" 1041,\n",
" 1042,\n",
" 1043,\n",
" 1044,\n",
" 1046,\n",
" 1047,\n",
" 1048,\n",
" 1049,\n",
" 1052,\n",
" 1053,\n",
" 1054,\n",
" 1055,\n",
" 1056,\n",
" 1057,\n",
" 1058,\n",
" 1059,\n",
" 1061,\n",
" 1062,\n",
" 1063,\n",
" 1065,\n",
" 1066,\n",
" 1067,\n",
" 1069,\n",
" 1070,\n",
" 1071,\n",
" 1072,\n",
" 1073,\n",
" 1074,\n",
" 1075,\n",
" 1076,\n",
" 1077,\n",
" 1078,\n",
" 1079,\n",
" 1080,\n",
" 1081,\n",
" 1082,\n",
" 1083,\n",
" 1084,\n",
" 1085,\n",
" 1087,\n",
" 1088,\n",
" 1089,\n",
" 1090,\n",
" 1091,\n",
" 1092,\n",
" 1094,\n",
" 1095,\n",
" 1096,\n",
" 1098,\n",
" 1101,\n",
" 1107,\n",
" 1108,\n",
" 1110,\n",
" 1111,\n",
" 1114,\n",
" 1115,\n",
" 1116,\n",
" 1117,\n",
" 1118,\n",
" 1119,\n",
" 1120,\n",
" 1121,\n",
" 1122,\n",
" 1125,\n",
" 1126,\n",
" 1129,\n",
" 1131,\n",
" 1133,\n",
" 1134,\n",
" 1135,\n",
" 1136,\n",
" 1137,\n",
" 1138,\n",
" 1139,\n",
" 1140,\n",
" 1141,\n",
" 1142,\n",
" 1145,\n",
" 1146,\n",
" 1147,\n",
" 1148,\n",
" 1149,\n",
" 1150,\n",
" 1151,\n",
" 1152,\n",
" 1153,\n",
" 1154,\n",
" 1155,\n",
" 1156,\n",
" 1157,\n",
" 1158,\n",
" 1159,\n",
" 1160,\n",
" 1161,\n",
" 1162,\n",
" 1163,\n",
" 1164,\n",
" 1166,\n",
" 1167,\n",
" 1168,\n",
" 1169,\n",
" 1170,\n",
" 1172,\n",
" 1173,\n",
" 1174,\n",
" 1175,\n",
" 1176,\n",
" 1177,\n",
" 1178,\n",
" 1179,\n",
" 1181,\n",
" 1182,\n",
" 1183,\n",
" 1184,\n",
" 1185,\n",
" 1187,\n",
" 1188,\n",
" 1189,\n",
" 1191,\n",
" 1192,\n",
" 1194,\n",
" 1195,\n",
" 1196,\n",
" 1198,\n",
" 1199,\n",
" 1201,\n",
" 1202,\n",
" 1204,\n",
" 1205,\n",
" 1206,\n",
" 1207,\n",
" 1208,\n",
" 1209,\n",
" 1212,\n",
" 1213,\n",
" 1214,\n",
" 1215,\n",
" 1216,\n",
" 1217,\n",
" 1219,\n",
" 1220,\n",
" 1221,\n",
" 1223,\n",
" 1224,\n",
" 1225,\n",
" 1226,\n",
" 1227,\n",
" 1229,\n",
" 1230,\n",
" 1232,\n",
" 1233,\n",
" 1234,\n",
" 1236,\n",
" 1237,\n",
" 1238,\n",
" 1239,\n",
" 1242,\n",
" 1243,\n",
" 1244,\n",
" 1245,\n",
" 1247,\n",
" 1248,\n",
" 1250,\n",
" 1252,\n",
" 1253,\n",
" 1254,\n",
" 1255,\n",
" 1256,\n",
" 1257,\n",
" 1258,\n",
" 1259,\n",
" 1260,\n",
" 1261,\n",
" 1263,\n",
" 1264,\n",
" 1266,\n",
" 1267,\n",
" 1268,\n",
" 1270,\n",
" 1271,\n",
" 1272,\n",
" 1273,\n",
" 1274,\n",
" 1275,\n",
" 1276,\n",
" 1278,\n",
" 1280,\n",
" 1281,\n",
" 1283,\n",
" 1285,\n",
" 1286,\n",
" 1287,\n",
" 1288,\n",
" 1289,\n",
" 1290,\n",
" 1291,\n",
" 1292,\n",
" 1293,\n",
" 1294,\n",
" 1295,\n",
" 1296,\n",
" 1297,\n",
" 1299,\n",
" 1300,\n",
" 1302,\n",
" 1304,\n",
" 1305,\n",
" 1306,\n",
" 1307,\n",
" 1308,\n",
" 1309,\n",
" 1310,\n",
" 1312,\n",
" 1313,\n",
" 1314,\n",
" 1315,\n",
" 1316,\n",
" 1317,\n",
" 1318,\n",
" 1320,\n",
" 1322,\n",
" 1323,\n",
" 1324,\n",
" 1325,\n",
" 1326,\n",
" 1327,\n",
" 1328,\n",
" 1329,\n",
" 1330,\n",
" 1331,\n",
" 1332,\n",
" 1333,\n",
" 1335,\n",
" 1337,\n",
" 1338,\n",
" 1339,\n",
" 1340,\n",
" 1341,\n",
" 1342,\n",
" 1343,\n",
" 1345,\n",
" 1346,\n",
" 1347,\n",
" 1348,\n",
" 1349,\n",
" 1350,\n",
" 1351,\n",
" 1353,\n",
" 1354,\n",
" 1355,\n",
" 1357,\n",
" 1358,\n",
" 1359,\n",
" 1360,\n",
" 1361,\n",
" 1362,\n",
" 1363,\n",
" 1364,\n",
" 1365,\n",
" 1366,\n",
" 1367,\n",
" 1368,\n",
" 1369,\n",
" 1370,\n",
" 1371,\n",
" 1372,\n",
" 1373,\n",
" 1374,\n",
" 1375,\n",
" 1376,\n",
" 1377,\n",
" 1378,\n",
" 1381,\n",
" 1385,\n",
" 1387,\n",
" 1389,\n",
" 1390,\n",
" 1391,\n",
" 1392,\n",
" 1394,\n",
" 1395,\n",
" 1397,\n",
" 1398,\n",
" 1399,\n",
" 1400,\n",
" 1401,\n",
" 1402,\n",
" 1404,\n",
" 1405,\n",
" 1406,\n",
" 1407,\n",
" 1408,\n",
" 1409,\n",
" 1410,\n",
" 1413,\n",
" 1414,\n",
" 1417,\n",
" 1418,\n",
" 1419,\n",
" 1421,\n",
" 1422,\n",
" 1423,\n",
" 1424,\n",
" 1425,\n",
" 1426,\n",
" 1428,\n",
" 1429,\n",
" 1430,\n",
" 1431,\n",
" 1432,\n",
" 1433,\n",
" 1434,\n",
" 1435,\n",
" 1438,\n",
" 1439,\n",
" 1440,\n",
" 1441,\n",
" 1443,\n",
" 1445,\n",
" 1446,\n",
" 1447,\n",
" 1448,\n",
" 1449,\n",
" 1451,\n",
" 1452,\n",
" 1454,\n",
" 1457,\n",
" 1458,\n",
" 1459,\n",
" 1460,\n",
" ...]"
]
},
"execution_count": 16,
"metadata": {},
"output_type": "execute_result"
}
],
"source": [
"list(data[data[\"Respuesta\"] == \"Buena\"][\"Encuesta\"].unique())"
]
},
{
"cell_type": "code",
"execution_count": 3,
"metadata": {},
"outputs": [
{
"data": {
"text/plain": [
"array(['¿Cómo fué tu experiencia al realizar este trámite?',\n",
" '¿Te gustaría compartir más de tu experiencia?',\n",
" '¿En qué puede mejorar este trámite?',\n",
" '¿Recomendarías nuestro portal a un amigo o familiar para realizar trámites y servicios?',\n",
" '¿Cuánto esfuerzo has puesto en gestionar tu trámite?'], dtype=object)"
]
},
"execution_count": 3,
"metadata": {},
"output_type": "execute_result"
}
],
"source": [
"data[\"Pregunta\"].unique()"
]
},
{
"cell_type": "code",
"execution_count": 7,
"metadata": {},
"outputs": [
{
"data": {
"text/plain": [
"Homoclave Respuesta\n",
"CFE-00-020 Buena 10274\n",
" Regular 1660\n",
" Mala 1102\n",
"INFONACOT-00-001 Buena 45\n",
" Regular 10\n",
" Mala 8\n",
"INM-03-005-C Buena 1\n",
"INM-03-006-A Mala 2\n",
" Regular 1\n",
"INM-03-006-C Buena 1\n",
"INM-03-009-B Buena 1\n",
"INM-03-010-G Buena 1\n",
"INM-03-013 Buena 2\n",
"SEDESOL-21-013-A Buena 1\n",
"SEDESOL-29-001 Buena 1\n",
"SEP-01-017 Regular 2\n",
" Buena 1\n",
"SEP-01-027 Buena 109\n",
" Mala 52\n",
" Regular 41\n",
"SEP-01-029 Buena 1\n",
"SEP-01-030 Buena 407\n",
" Regular 93\n",
" Mala 46\n",
"SEP-01-031 Buena 101\n",
" Regular 26\n",
" Mala 18\n",
"SEP-01-034 Buena 1\n",
"SGOB-05-002 Buena 39717\n",
" Regular 5507\n",
" Mala 2571\n",
"Name: Respuesta, dtype: int64"
]
},
"execution_count": 7,
"metadata": {},
"output_type": "execute_result"
}
],
"source": [
"data[data[\"Pregunta\"] == \"¿Cómo fué tu experiencia al realizar este trámite?\"].groupby(\"Homoclave\")[\"Respuesta\"].value_counts()"
]
},
{
"cell_type": "code",
"execution_count": 8,
"metadata": {
"scrolled": true
},
"outputs": [
{
"data": {
"text/html": [
"<div>\n",
"<style>\n",
" .dataframe thead tr:only-child th {\n",
" text-align: right;\n",
" }\n",
"\n",
" .dataframe thead th {\n",
" text-align: left;\n",
" }\n",
"\n",
" .dataframe tbody tr th {\n",
" vertical-align: top;\n",
" }\n",
"</style>\n",
"<table border=\"1\" class=\"dataframe\">\n",
" <thead>\n",
" <tr style=\"text-align: right;\">\n",
" <th></th>\n",
" <th>Encuesta</th>\n",
" <th>Homoclave</th>\n",
" <th>Fecha</th>\n",
" <th>Pregunta</th>\n",
" <th>Respuesta</th>\n",
" </tr>\n",
" </thead>\n",
" <tbody>\n",
" <tr>\n",
" <th>0</th>\n",
" <td>166</td>\n",
" <td>SEP-01-030</td>\n",
" <td>2016-07-20</td>\n",
" <td>¿Cómo fué tu experiencia al realizar este trám...</td>\n",
" <td>Buena</td>\n",
" </tr>\n",
" <tr>\n",
" <th>1</th>\n",
" <td>166</td>\n",
" <td>SEP-01-030</td>\n",
" <td>2016-07-20</td>\n",
" <td>¿Te gustaría compartir más de tu experiencia?</td>\n",
" <td>No</td>\n",
" </tr>\n",
" <tr>\n",
" <th>2</th>\n",
" <td>168</td>\n",
" <td>CFE-00-020</td>\n",
" <td>2016-07-20</td>\n",
" <td>¿Cómo fué tu experiencia al realizar este trám...</td>\n",
" <td>Mala</td>\n",
" </tr>\n",
" <tr>\n",
" <th>3</th>\n",
" <td>169</td>\n",
" <td>CFE-00-020</td>\n",
" <td>2016-07-20</td>\n",
" <td>¿Cómo fué tu experiencia al realizar este trám...</td>\n",
" <td>Buena</td>\n",
" </tr>\n",
" <tr>\n",
" <th>4</th>\n",
" <td>169</td>\n",
" <td>CFE-00-020</td>\n",
" <td>2016-07-20</td>\n",
" <td>¿Te gustaría compartir más de tu experiencia?</td>\n",
" <td>No</td>\n",
" </tr>\n",
" <tr>\n",
" <th>5</th>\n",
" <td>170</td>\n",
" <td>CFE-00-020</td>\n",
" <td>2016-07-20</td>\n",
" <td>¿En qué puede mejorar este trámite?</td>\n",
" <td>El formato es muy difícil de llenar</td>\n",
" </tr>\n",
" <tr>\n",
" <th>6</th>\n",
" <td>170</td>\n",
" <td>CFE-00-020</td>\n",
" <td>2016-07-20</td>\n",
" <td>¿En qué puede mejorar este trámite?</td>\n",
" <td>El formulario web es muy difícil de llenar</td>\n",
" </tr>\n",
" <tr>\n",
" <th>7</th>\n",
" <td>170</td>\n",
" <td>CFE-00-020</td>\n",
" <td>2016-07-20</td>\n",
" <td>¿Cómo fué tu experiencia al realizar este trám...</td>\n",
" <td>Mala</td>\n",
" </tr>\n",
" <tr>\n",
" <th>8</th>\n",
" <td>170</td>\n",
" <td>CFE-00-020</td>\n",
" <td>2016-07-20</td>\n",
" <td>¿En qué puede mejorar este trámite?</td>\n",
" <td>Número de requisitos</td>\n",
" </tr>\n",
" <tr>\n",
" <th>9</th>\n",
" <td>170</td>\n",
" <td>CFE-00-020</td>\n",
" <td>2016-07-20</td>\n",
" <td>¿En qué puede mejorar este trámite?</td>\n",
" <td>Que la información proporcionada sea más clara...</td>\n",
" </tr>\n",
" <tr>\n",
" <th>10</th>\n",
" <td>171</td>\n",
" <td>CFE-00-020</td>\n",
" <td>2016-07-20</td>\n",
" <td>¿Cómo fué tu experiencia al realizar este trám...</td>\n",
" <td>Buena</td>\n",
" </tr>\n",
" <tr>\n",
" <th>11</th>\n",
" <td>171</td>\n",
" <td>CFE-00-020</td>\n",
" <td>2016-07-20</td>\n",
" <td>¿Te gustaría compartir más de tu experiencia?</td>\n",
" <td>No</td>\n",
" </tr>\n",
" <tr>\n",
" <th>12</th>\n",
" <td>172</td>\n",
" <td>CFE-00-020</td>\n",
" <td>2016-07-20</td>\n",
" <td>¿Cómo fué tu experiencia al realizar este trám...</td>\n",
" <td>Buena</td>\n",
" </tr>\n",
" <tr>\n",
" <th>13</th>\n",
" <td>172</td>\n",
" <td>CFE-00-020</td>\n",
" <td>2016-07-20</td>\n",
" <td>¿Te gustaría compartir más de tu experiencia?</td>\n",
" <td>No</td>\n",
" </tr>\n",
" <tr>\n",
" <th>14</th>\n",
" <td>173</td>\n",
" <td>CFE-00-020</td>\n",
" <td>2016-07-20</td>\n",
" <td>¿Cómo fué tu experiencia al realizar este trám...</td>\n",
" <td>Buena</td>\n",
" </tr>\n",
" <tr>\n",
" <th>15</th>\n",
" <td>173</td>\n",
" <td>CFE-00-020</td>\n",
" <td>2016-07-20</td>\n",
" <td>¿Te gustaría compartir más de tu experiencia?</td>\n",
" <td>No</td>\n",
" </tr>\n",
" <tr>\n",
" <th>16</th>\n",
" <td>174</td>\n",
" <td>CFE-00-020</td>\n",
" <td>2016-07-20</td>\n",
" <td>¿Cómo fué tu experiencia al realizar este trám...</td>\n",
" <td>Buena</td>\n",
" </tr>\n",
" <tr>\n",
" <th>17</th>\n",
" <td>174</td>\n",
" <td>CFE-00-020</td>\n",
" <td>2016-07-20</td>\n",
" <td>¿Te gustaría compartir más de tu experiencia?</td>\n",
" <td>No</td>\n",
" </tr>\n",
" <tr>\n",
" <th>18</th>\n",
" <td>175</td>\n",
" <td>CFE-00-020</td>\n",
" <td>2016-07-20</td>\n",
" <td>¿Cómo fué tu experiencia al realizar este trám...</td>\n",
" <td>Buena</td>\n",
" </tr>\n",
" <tr>\n",
" <th>19</th>\n",
" <td>175</td>\n",
" <td>CFE-00-020</td>\n",
" <td>2016-07-20</td>\n",
" <td>¿Te gustaría compartir más de tu experiencia?</td>\n",
" <td>Si</td>\n",
" </tr>\n",
" <tr>\n",
" <th>20</th>\n",
" <td>176</td>\n",
" <td>CFE-00-020</td>\n",
" <td>2016-07-20</td>\n",
" <td>¿En qué puede mejorar este trámite?</td>\n",
" <td>Que la información proporcionada sea más clara...</td>\n",
" </tr>\n",
" <tr>\n",
" <th>21</th>\n",
" <td>176</td>\n",
" <td>CFE-00-020</td>\n",
" <td>2016-07-20</td>\n",
" <td>¿Cómo fué tu experiencia al realizar este trám...</td>\n",
" <td>Regular</td>\n",
" </tr>\n",
" <tr>\n",
" <th>22</th>\n",
" <td>177</td>\n",
" <td>CFE-00-020</td>\n",
" <td>2016-07-20</td>\n",
" <td>¿Cómo fué tu experiencia al realizar este trám...</td>\n",
" <td>Regular</td>\n",
" </tr>\n",
" <tr>\n",
" <th>23</th>\n",
" <td>178</td>\n",
" <td>SEP-01-031</td>\n",
" <td>2016-07-20</td>\n",
" <td>¿Cómo fué tu experiencia al realizar este trám...</td>\n",
" <td>Buena</td>\n",
" </tr>\n",
" <tr>\n",
" <th>24</th>\n",
" <td>178</td>\n",
" <td>SEP-01-031</td>\n",
" <td>2016-07-20</td>\n",
" <td>¿Te gustaría compartir más de tu experiencia?</td>\n",
" <td>No</td>\n",
" </tr>\n",
" <tr>\n",
" <th>25</th>\n",
" <td>179</td>\n",
" <td>CFE-00-020</td>\n",
" <td>2016-07-20</td>\n",
" <td>¿Cómo fué tu experiencia al realizar este trám...</td>\n",
" <td>Buena</td>\n",
" </tr>\n",
" <tr>\n",
" <th>26</th>\n",
" <td>179</td>\n",
" <td>CFE-00-020</td>\n",
" <td>2016-07-20</td>\n",
" <td>¿Recomendarías nuestro portal a un amigo o fam...</td>\n",
" <td>Definitivamente lo recomendaría</td>\n",
" </tr>\n",
" <tr>\n",
" <th>27</th>\n",
" <td>179</td>\n",
" <td>CFE-00-020</td>\n",
" <td>2016-07-20</td>\n",
" <td>¿Cuánto esfuerzo has puesto en gestionar tu tr...</td>\n",
" <td>Muy poco esfuerzo</td>\n",
" </tr>\n",
" <tr>\n",
" <th>28</th>\n",
" <td>179</td>\n",
" <td>CFE-00-020</td>\n",
" <td>2016-07-20</td>\n",
" <td>¿Te gustaría compartir más de tu experiencia?</td>\n",
" <td>Si</td>\n",
" </tr>\n",
" <tr>\n",
" <th>29</th>\n",
" <td>180</td>\n",
" <td>CFE-00-020</td>\n",
" <td>2016-07-20</td>\n",
" <td>¿Cómo fué tu experiencia al realizar este trám...</td>\n",
" <td>Buena</td>\n",
" </tr>\n",
" <tr>\n",
" <th>...</th>\n",
" <td>...</td>\n",
" <td>...</td>\n",
" <td>...</td>\n",
" <td>...</td>\n",
" <td>...</td>\n",
" </tr>\n",
" <tr>\n",
" <th>136814</th>\n",
" <td>62572</td>\n",
" <td>SGOB-05-002</td>\n",
" <td>2016-09-20</td>\n",
" <td>¿Te gustaría compartir más de tu experiencia?</td>\n",
" <td>No</td>\n",
" </tr>\n",
" <tr>\n",
" <th>136815</th>\n",
" <td>62573</td>\n",
" <td>SGOB-05-002</td>\n",
" <td>2016-09-20</td>\n",
" <td>¿Cómo fué tu experiencia al realizar este trám...</td>\n",
" <td>Buena</td>\n",
" </tr>\n",
" <tr>\n",
" <th>136816</th>\n",
" <td>62573</td>\n",
" <td>SGOB-05-002</td>\n",
" <td>2016-09-20</td>\n",
" <td>¿Te gustaría compartir más de tu experiencia?</td>\n",
" <td>No</td>\n",
" </tr>\n",
" <tr>\n",
" <th>136817</th>\n",
" <td>62574</td>\n",
" <td>SGOB-05-002</td>\n",
" <td>2016-09-20</td>\n",
" <td>¿Cómo fué tu experiencia al realizar este trám...</td>\n",
" <td>Mala</td>\n",
" </tr>\n",
" <tr>\n",
" <th>136818</th>\n",
" <td>62574</td>\n",
" <td>SGOB-05-002</td>\n",
" <td>2016-09-20</td>\n",
" <td>¿En qué puede mejorar este trámite?</td>\n",
" <td>Tiempo de respuesta</td>\n",
" </tr>\n",
" <tr>\n",
" <th>136819</th>\n",
" <td>62576</td>\n",
" <td>SGOB-05-002</td>\n",
" <td>2016-09-20</td>\n",
" <td>¿Cómo fué tu experiencia al realizar este trám...</td>\n",
" <td>Buena</td>\n",
" </tr>\n",
" <tr>\n",
" <th>136820</th>\n",
" <td>62576</td>\n",
" <td>SGOB-05-002</td>\n",
" <td>2016-09-20</td>\n",
" <td>¿Recomendarías nuestro portal a un amigo o fam...</td>\n",
" <td>Definitivamente lo recomendaría</td>\n",
" </tr>\n",
" <tr>\n",
" <th>136821</th>\n",
" <td>62576</td>\n",
" <td>SGOB-05-002</td>\n",
" <td>2016-09-20</td>\n",
" <td>¿Cuánto esfuerzo has puesto en gestionar tu tr...</td>\n",
" <td>Muy poco esfuerzo</td>\n",
" </tr>\n",
" <tr>\n",
" <th>136822</th>\n",
" <td>62576</td>\n",
" <td>SGOB-05-002</td>\n",
" <td>2016-09-20</td>\n",
" <td>¿Te gustaría compartir más de tu experiencia?</td>\n",
" <td>Si</td>\n",
" </tr>\n",
" <tr>\n",
" <th>136823</th>\n",
" <td>62577</td>\n",
" <td>SGOB-05-002</td>\n",
" <td>2016-09-20</td>\n",
" <td>¿Cómo fué tu experiencia al realizar este trám...</td>\n",
" <td>Buena</td>\n",
" </tr>\n",
" <tr>\n",
" <th>136824</th>\n",
" <td>62577</td>\n",
" <td>SGOB-05-002</td>\n",
" <td>2016-09-20</td>\n",
" <td>¿Te gustaría compartir más de tu experiencia?</td>\n",
" <td>No</td>\n",
" </tr>\n",
" <tr>\n",
" <th>136825</th>\n",
" <td>62578</td>\n",
" <td>SGOB-05-002</td>\n",
" <td>2016-09-20</td>\n",
" <td>¿Cómo fué tu experiencia al realizar este trám...</td>\n",
" <td>Mala</td>\n",
" </tr>\n",
" <tr>\n",
" <th>136826</th>\n",
" <td>62579</td>\n",
" <td>SGOB-05-002</td>\n",
" <td>2016-09-20</td>\n",
" <td>¿Cómo fué tu experiencia al realizar este trám...</td>\n",
" <td>Regular</td>\n",
" </tr>\n",
" <tr>\n",
" <th>136827</th>\n",
" <td>62580</td>\n",
" <td>SGOB-05-002</td>\n",
" <td>2016-09-20</td>\n",
" <td>¿Cómo fué tu experiencia al realizar este trám...</td>\n",
" <td>Buena</td>\n",
" </tr>\n",
" <tr>\n",
" <th>136828</th>\n",
" <td>62580</td>\n",
" <td>SGOB-05-002</td>\n",
" <td>2016-09-20</td>\n",
" <td>¿Te gustaría compartir más de tu experiencia?</td>\n",
" <td>No</td>\n",
" </tr>\n",
" <tr>\n",
" <th>136829</th>\n",
" <td>62581</td>\n",
" <td>SGOB-05-002</td>\n",
" <td>2016-09-20</td>\n",
" <td>¿Cómo fué tu experiencia al realizar este trám...</td>\n",
" <td>Buena</td>\n",
" </tr>\n",
" <tr>\n",
" <th>136830</th>\n",
" <td>62581</td>\n",
" <td>SGOB-05-002</td>\n",
" <td>2016-09-20</td>\n",
" <td>¿Te gustaría compartir más de tu experiencia?</td>\n",
" <td>No</td>\n",
" </tr>\n",
" <tr>\n",
" <th>136831</th>\n",
" <td>62582</td>\n",
" <td>SGOB-05-002</td>\n",
" <td>2016-09-20</td>\n",
" <td>¿Cómo fué tu experiencia al realizar este trám...</td>\n",
" <td>Buena</td>\n",
" </tr>\n",
" <tr>\n",
" <th>136832</th>\n",
" <td>62582</td>\n",
" <td>SGOB-05-002</td>\n",
" <td>2016-09-20</td>\n",
" <td>¿Te gustaría compartir más de tu experiencia?</td>\n",
" <td>No</td>\n",
" </tr>\n",
" <tr>\n",
" <th>136833</th>\n",
" <td>62583</td>\n",
" <td>SGOB-05-002</td>\n",
" <td>2016-09-20</td>\n",
" <td>¿Cómo fué tu experiencia al realizar este trám...</td>\n",
" <td>Buena</td>\n",
" </tr>\n",
" <tr>\n",
" <th>136834</th>\n",
" <td>62583</td>\n",
" <td>SGOB-05-002</td>\n",
" <td>2016-09-20</td>\n",
" <td>¿Te gustaría compartir más de tu experiencia?</td>\n",
" <td>No</td>\n",
" </tr>\n",
" <tr>\n",
" <th>136835</th>\n",
" <td>62584</td>\n",
" <td>SGOB-05-002</td>\n",
" <td>2016-09-20</td>\n",
" <td>¿Cómo fué tu experiencia al realizar este trám...</td>\n",
" <td>Mala</td>\n",
" </tr>\n",
" <tr>\n",
" <th>136836</th>\n",
" <td>62585</td>\n",
" <td>SGOB-05-002</td>\n",
" <td>2016-09-20</td>\n",
" <td>¿Cómo fué tu experiencia al realizar este trám...</td>\n",
" <td>Buena</td>\n",
" </tr>\n",
" <tr>\n",
" <th>136837</th>\n",
" <td>62585</td>\n",
" <td>SGOB-05-002</td>\n",
" <td>2016-09-20</td>\n",
" <td>¿Recomendarías nuestro portal a un amigo o fam...</td>\n",
" <td>Definitivamente lo recomendaría</td>\n",
" </tr>\n",
" <tr>\n",
" <th>136838</th>\n",
" <td>62585</td>\n",
" <td>SGOB-05-002</td>\n",
" <td>2016-09-20</td>\n",
" <td>¿Cuánto esfuerzo has puesto en gestionar tu tr...</td>\n",
" <td>Muy poco esfuerzo</td>\n",
" </tr>\n",
" <tr>\n",
" <th>136839</th>\n",
" <td>62585</td>\n",
" <td>SGOB-05-002</td>\n",
" <td>2016-09-20</td>\n",
" <td>¿Te gustaría compartir más de tu experiencia?</td>\n",
" <td>Si</td>\n",
" </tr>\n",
" <tr>\n",
" <th>136840</th>\n",
" <td>62586</td>\n",
" <td>SGOB-05-002</td>\n",
" <td>2016-09-20</td>\n",
" <td>¿Cómo fué tu experiencia al realizar este trám...</td>\n",
" <td>Buena</td>\n",
" </tr>\n",
" <tr>\n",
" <th>136841</th>\n",
" <td>62586</td>\n",
" <td>SGOB-05-002</td>\n",
" <td>2016-09-20</td>\n",
" <td>¿Te gustaría compartir más de tu experiencia?</td>\n",
" <td>No</td>\n",
" </tr>\n",
" <tr>\n",
" <th>136842</th>\n",
" <td>62587</td>\n",
" <td>SGOB-05-002</td>\n",
" <td>2016-09-20</td>\n",
" <td>¿Cómo fué tu experiencia al realizar este trám...</td>\n",
" <td>Buena</td>\n",
" </tr>\n",
" <tr>\n",
" <th>136843</th>\n",
" <td>62587</td>\n",
" <td>SGOB-05-002</td>\n",
" <td>2016-09-20</td>\n",
" <td>¿Te gustaría compartir más de tu experiencia?</td>\n",
" <td>No</td>\n",
" </tr>\n",
" </tbody>\n",
"</table>\n",
"<p>136844 rows × 5 columns</p>\n",
"</div>"
],
"text/plain": [
" Encuesta Homoclave Fecha \\\n",
"0 166 SEP-01-030 2016-07-20 \n",
"1 166 SEP-01-030 2016-07-20 \n",
"2 168 CFE-00-020 2016-07-20 \n",
"3 169 CFE-00-020 2016-07-20 \n",
"4 169 CFE-00-020 2016-07-20 \n",
"5 170 CFE-00-020 2016-07-20 \n",
"6 170 CFE-00-020 2016-07-20 \n",
"7 170 CFE-00-020 2016-07-20 \n",
"8 170 CFE-00-020 2016-07-20 \n",
"9 170 CFE-00-020 2016-07-20 \n",
"10 171 CFE-00-020 2016-07-20 \n",
"11 171 CFE-00-020 2016-07-20 \n",
"12 172 CFE-00-020 2016-07-20 \n",
"13 172 CFE-00-020 2016-07-20 \n",
"14 173 CFE-00-020 2016-07-20 \n",
"15 173 CFE-00-020 2016-07-20 \n",
"16 174 CFE-00-020 2016-07-20 \n",
"17 174 CFE-00-020 2016-07-20 \n",
"18 175 CFE-00-020 2016-07-20 \n",
"19 175 CFE-00-020 2016-07-20 \n",
"20 176 CFE-00-020 2016-07-20 \n",
"21 176 CFE-00-020 2016-07-20 \n",
"22 177 CFE-00-020 2016-07-20 \n",
"23 178 SEP-01-031 2016-07-20 \n",
"24 178 SEP-01-031 2016-07-20 \n",
"25 179 CFE-00-020 2016-07-20 \n",
"26 179 CFE-00-020 2016-07-20 \n",
"27 179 CFE-00-020 2016-07-20 \n",
"28 179 CFE-00-020 2016-07-20 \n",
"29 180 CFE-00-020 2016-07-20 \n",
"... ... ... ... \n",
"136814 62572 SGOB-05-002 2016-09-20 \n",
"136815 62573 SGOB-05-002 2016-09-20 \n",
"136816 62573 SGOB-05-002 2016-09-20 \n",
"136817 62574 SGOB-05-002 2016-09-20 \n",
"136818 62574 SGOB-05-002 2016-09-20 \n",
"136819 62576 SGOB-05-002 2016-09-20 \n",
"136820 62576 SGOB-05-002 2016-09-20 \n",
"136821 62576 SGOB-05-002 2016-09-20 \n",
"136822 62576 SGOB-05-002 2016-09-20 \n",
"136823 62577 SGOB-05-002 2016-09-20 \n",
"136824 62577 SGOB-05-002 2016-09-20 \n",
"136825 62578 SGOB-05-002 2016-09-20 \n",
"136826 62579 SGOB-05-002 2016-09-20 \n",
"136827 62580 SGOB-05-002 2016-09-20 \n",
"136828 62580 SGOB-05-002 2016-09-20 \n",
"136829 62581 SGOB-05-002 2016-09-20 \n",
"136830 62581 SGOB-05-002 2016-09-20 \n",
"136831 62582 SGOB-05-002 2016-09-20 \n",
"136832 62582 SGOB-05-002 2016-09-20 \n",
"136833 62583 SGOB-05-002 2016-09-20 \n",
"136834 62583 SGOB-05-002 2016-09-20 \n",
"136835 62584 SGOB-05-002 2016-09-20 \n",
"136836 62585 SGOB-05-002 2016-09-20 \n",
"136837 62585 SGOB-05-002 2016-09-20 \n",
"136838 62585 SGOB-05-002 2016-09-20 \n",
"136839 62585 SGOB-05-002 2016-09-20 \n",
"136840 62586 SGOB-05-002 2016-09-20 \n",
"136841 62586 SGOB-05-002 2016-09-20 \n",
"136842 62587 SGOB-05-002 2016-09-20 \n",
"136843 62587 SGOB-05-002 2016-09-20 \n",
"\n",
" Pregunta \\\n",
"0 ¿Cómo fué tu experiencia al realizar este trám... \n",
"1 ¿Te gustaría compartir más de tu experiencia? \n",
"2 ¿Cómo fué tu experiencia al realizar este trám... \n",
"3 ¿Cómo fué tu experiencia al realizar este trám... \n",
"4 ¿Te gustaría compartir más de tu experiencia? \n",
"5 ¿En qué puede mejorar este trámite? \n",
"6 ¿En qué puede mejorar este trámite? \n",
"7 ¿Cómo fué tu experiencia al realizar este trám... \n",
"8 ¿En qué puede mejorar este trámite? \n",
"9 ¿En qué puede mejorar este trámite? \n",
"10 ¿Cómo fué tu experiencia al realizar este trám... \n",
"11 ¿Te gustaría compartir más de tu experiencia? \n",
"12 ¿Cómo fué tu experiencia al realizar este trám... \n",
"13 ¿Te gustaría compartir más de tu experiencia? \n",
"14 ¿Cómo fué tu experiencia al realizar este trám... \n",
"15 ¿Te gustaría compartir más de tu experiencia? \n",
"16 ¿Cómo fué tu experiencia al realizar este trám... \n",
"17 ¿Te gustaría compartir más de tu experiencia? \n",
"18 ¿Cómo fué tu experiencia al realizar este trám... \n",
"19 ¿Te gustaría compartir más de tu experiencia? \n",
"20 ¿En qué puede mejorar este trámite? \n",
"21 ¿Cómo fué tu experiencia al realizar este trám... \n",
"22 ¿Cómo fué tu experiencia al realizar este trám... \n",
"23 ¿Cómo fué tu experiencia al realizar este trám... \n",
"24 ¿Te gustaría compartir más de tu experiencia? \n",
"25 ¿Cómo fué tu experiencia al realizar este trám... \n",
"26 ¿Recomendarías nuestro portal a un amigo o fam... \n",
"27 ¿Cuánto esfuerzo has puesto en gestionar tu tr... \n",
"28 ¿Te gustaría compartir más de tu experiencia? \n",
"29 ¿Cómo fué tu experiencia al realizar este trám... \n",
"... ... \n",
"136814 ¿Te gustaría compartir más de tu experiencia? \n",
"136815 ¿Cómo fué tu experiencia al realizar este trám... \n",
"136816 ¿Te gustaría compartir más de tu experiencia? \n",
"136817 ¿Cómo fué tu experiencia al realizar este trám... \n",
"136818 ¿En qué puede mejorar este trámite? \n",
"136819 ¿Cómo fué tu experiencia al realizar este trám... \n",
"136820 ¿Recomendarías nuestro portal a un amigo o fam... \n",
"136821 ¿Cuánto esfuerzo has puesto en gestionar tu tr... \n",
"136822 ¿Te gustaría compartir más de tu experiencia? \n",
"136823 ¿Cómo fué tu experiencia al realizar este trám... \n",
"136824 ¿Te gustaría compartir más de tu experiencia? \n",
"136825 ¿Cómo fué tu experiencia al realizar este trám... \n",
"136826 ¿Cómo fué tu experiencia al realizar este trám... \n",
"136827 ¿Cómo fué tu experiencia al realizar este trám... \n",
"136828 ¿Te gustaría compartir más de tu experiencia? \n",
"136829 ¿Cómo fué tu experiencia al realizar este trám... \n",
"136830 ¿Te gustaría compartir más de tu experiencia? \n",
"136831 ¿Cómo fué tu experiencia al realizar este trám... \n",
"136832 ¿Te gustaría compartir más de tu experiencia? \n",
"136833 ¿Cómo fué tu experiencia al realizar este trám... \n",
"136834 ¿Te gustaría compartir más de tu experiencia? \n",
"136835 ¿Cómo fué tu experiencia al realizar este trám... \n",
"136836 ¿Cómo fué tu experiencia al realizar este trám... \n",
"136837 ¿Recomendarías nuestro portal a un amigo o fam... \n",
"136838 ¿Cuánto esfuerzo has puesto en gestionar tu tr... \n",
"136839 ¿Te gustaría compartir más de tu experiencia? \n",
"136840 ¿Cómo fué tu experiencia al realizar este trám... \n",
"136841 ¿Te gustaría compartir más de tu experiencia? \n",
"136842 ¿Cómo fué tu experiencia al realizar este trám... \n",
"136843 ¿Te gustaría compartir más de tu experiencia? \n",
"\n",
" Respuesta \n",
"0 Buena \n",
"1 No \n",
"2 Mala \n",
"3 Buena \n",
"4 No \n",
"5 El formato es muy difícil de llenar \n",
"6 El formulario web es muy difícil de llenar \n",
"7 Mala \n",
"8 Número de requisitos \n",
"9 Que la información proporcionada sea más clara... \n",
"10 Buena \n",
"11 No \n",
"12 Buena \n",
"13 No \n",
"14 Buena \n",
"15 No \n",
"16 Buena \n",
"17 No \n",
"18 Buena \n",
"19 Si \n",
"20 Que la información proporcionada sea más clara... \n",
"21 Regular \n",
"22 Regular \n",
"23 Buena \n",
"24 No \n",
"25 Buena \n",
"26 Definitivamente lo recomendaría \n",
"27 Muy poco esfuerzo \n",
"28 Si \n",
"29 Buena \n",
"... ... \n",
"136814 No \n",
"136815 Buena \n",
"136816 No \n",
"136817 Mala \n",
"136818 Tiempo de respuesta \n",
"136819 Buena \n",
"136820 Definitivamente lo recomendaría \n",
"136821 Muy poco esfuerzo \n",
"136822 Si \n",
"136823 Buena \n",
"136824 No \n",
"136825 Mala \n",
"136826 Regular \n",
"136827 Buena \n",
"136828 No \n",
"136829 Buena \n",
"136830 No \n",
"136831 Buena \n",
"136832 No \n",
"136833 Buena \n",
"136834 No \n",
"136835 Mala \n",
"136836 Buena \n",
"136837 Definitivamente lo recomendaría \n",
"136838 Muy poco esfuerzo \n",
"136839 Si \n",
"136840 Buena \n",
"136841 No \n",
"136842 Buena \n",
"136843 No \n",
"\n",
"[136844 rows x 5 columns]"
]
},
"execution_count": 8,
"metadata": {},
"output_type": "execute_result"
}
],
"source": [
"data"
]
},
{
"cell_type": "code",
"execution_count": 9,
"metadata": {},
"outputs": [
{
"name": "stderr",
"output_type": "stream",
"text": [
"/usr/local/lib/python3.6/site-packages/ipykernel_launcher.py:1: DeprecationWarning: \n",
".ix is deprecated. Please use\n",
".loc for label based indexing or\n",
".iloc for positional indexing\n",
"\n",
"See the documentation here:\n",
"http://pandas.pydata.org/pandas-docs/stable/indexing.html#ix-indexer-is-deprecated\n",
" \"\"\"Entry point for launching an IPython kernel.\n"
]
},
{
"data": {
"text/plain": [
"'¿Cómo fué tu experiencia al realizar este trámite?'"
]
},
"execution_count": 9,
"metadata": {},
"output_type": "execute_result"
}
],
"source": [
"data.ix[0][\"Pregunta\"]"
]
},
{
"cell_type": "code",
"execution_count": 10,
"metadata": {
"collapsed": true
},
"outputs": [],
"source": [
"data_satisfacción = data[data[\"Pregunta\"]== '¿Cómo fué tu experiencia al realizar este trámite?' ]"
]
},
{
"cell_type": "code",
"execution_count": 11,
"metadata": {
"collapsed": true
},
"outputs": [],
"source": [
"counts = data_satisfacción[\"Respuesta\"].value_counts()"
]
},
{
"cell_type": "code",
"execution_count": 12,
"metadata": {},
"outputs": [
{
"data": {
"text/plain": [
"Buena 50664\n",
"Regular 7340\n",
"Mala 3799\n",
"Name: Respuesta, dtype: int64"
]
},
"execution_count": 12,
"metadata": {},
"output_type": "execute_result"
}
],
"source": [
"counts"
]
},
{
"cell_type": "code",
"execution_count": 13,
"metadata": {
"collapsed": true
},
"outputs": [],
"source": [
"output = {}\n",
"for key in counts.keys():\n",
" output[key] = list(data_satisfacción[\"Encuesta\"][data_satisfacción[\"Respuesta\"]==key].unique())"
]
},
{
"cell_type": "code",
"execution_count": 14,
"metadata": {},
"outputs": [
{
"data": {
"text/plain": [
"50664"
]
},
"execution_count": 14,
"metadata": {},
"output_type": "execute_result"
}
],
"source": [
"len(output[\"Buena\"])"
]
},
{
"cell_type": "code",
"execution_count": 15,
"metadata": {},
"outputs": [
{
"data": {
"text/plain": [
"¿Cómo fué tu experiencia al realizar este trámite? 50664\n",
"¿Te gustaría compartir más de tu experiencia? 43759\n",
"¿Recomendarías nuestro portal a un amigo o familiar para realizar trámites y servicios? 11235\n",
"¿Cuánto esfuerzo has puesto en gestionar tu trámite? 10862\n",
"Name: Pregunta, dtype: int64"
]
},
"execution_count": 15,
"metadata": {},
"output_type": "execute_result"
}
],
"source": [
"data[data[\"Encuesta\"].isin(output[\"Buena\"])][\"Pregunta\"].value_counts()"
]
},
{
"cell_type": "code",
"execution_count": 16,
"metadata": {},
"outputs": [
{
"data": {
"text/plain": [
"¿Cómo fué tu experiencia al realizar este trámite? 7340\n",
"¿En qué puede mejorar este trámite? 5694\n",
"Name: Pregunta, dtype: int64"
]
},
"execution_count": 16,
"metadata": {},
"output_type": "execute_result"
}
],
"source": [
"data[data[\"Encuesta\"].isin(output[\"Regular\"])][\"Pregunta\"].value_counts()"
]
},
{
"cell_type": "code",
"execution_count": 17,
"metadata": {},
"outputs": [
{
"data": {
"text/plain": [
"¿Cómo fué tu experiencia al realizar este trámite? 3799\n",
"¿En qué puede mejorar este trámite? 3491\n",
"Name: Pregunta, dtype: int64"
]
},
"execution_count": 17,
"metadata": {},
"output_type": "execute_result"
}
],
"source": [
"data[data[\"Encuesta\"].isin(output[\"Mala\"])][\"Pregunta\"].value_counts()"
]
},
{
"cell_type": "code",
"execution_count": 18,
"metadata": {
"collapsed": true
},
"outputs": [],
"source": [
"data_buena = data[data[\"Encuesta\"].isin(output[\"Buena\"])]\n",
"data_regular = data[data[\"Encuesta\"].isin(output[\"Regular\"])]\n",
"data_mala = data[data[\"Encuesta\"].isin(output[\"Mala\"])]"
]
},
{
"cell_type": "code",
"execution_count": 23,
"metadata": {},
"outputs": [
{
"data": {
"text/plain": [
"array(['¿Cómo fué tu experiencia al realizar este trámite?',\n",
" '¿Te gustaría compartir más de tu experiencia?',\n",
" '¿Recomendarías nuestro portal a un amigo o familiar para realizar trámites y servicios?',\n",
" '¿Cuánto esfuerzo has puesto en gestionar tu trámite?'], dtype=object)"
]
},
"execution_count": 23,
"metadata": {},
"output_type": "execute_result"
}
],
"source": [
"data_buena[\"Pregunta\"].unique()"
]
},
{
"cell_type": "code",
"execution_count": 19,
"metadata": {},
"outputs": [
{
"data": {
"text/plain": [
"Que la información proporcionada sea más clara y completa 2649\n",
"Tiempo de respuesta 1043\n",
"Número de requisitos 518\n",
"El formulario web es muy difícil de llenar 367\n",
"NoQue se pueda realizar 100% por InternetNo 365\n",
"El formato es muy difícil de llenar 355\n",
"Que se pueda realizar por Internet 232\n",
"Costo elevado 165\n",
"Name: Respuesta, dtype: int64"
]
},
"execution_count": 19,
"metadata": {},
"output_type": "execute_result"
}
],
"source": [
"data_regular[data_regular[\"Pregunta\"]==\"¿En qué puede mejorar este trámite?\"][\"Respuesta\"].value_counts()"
]
},
{
"cell_type": "code",
"execution_count": 20,
"metadata": {},
"outputs": [
{
"data": {
"text/plain": [
"Que la información proporcionada sea más clara y completa 1243\n",
"Tiempo de respuesta 574\n",
"El formulario web es muy difícil de llenar 406\n",
"El formato es muy difícil de llenar 343\n",
"Número de requisitos 321\n",
"Que se pueda realizar por Internet 243\n",
"NoQue se pueda realizar 100% por InternetNo 223\n",
"Costo elevado 138\n",
"Name: Respuesta, dtype: int64"
]
},
"execution_count": 20,
"metadata": {},
"output_type": "execute_result"
}
],
"source": [
"data_mala[data_mala[\"Pregunta\"]==\"¿En qué puede mejorar este trámite?\"][\"Respuesta\"].value_counts()"
]
},
{
"cell_type": "code",
"execution_count": null,
"metadata": {
"collapsed": true
},
"outputs": [],
"source": []
},
{
"cell_type": "code",
"execution_count": null,
"metadata": {
"collapsed": true
},
"outputs": [],
"source": []
},
{
"cell_type": "code",
"execution_count": null,
"metadata": {
"collapsed": true
},
"outputs": [],
"source": []
},
{
"cell_type": "code",
"execution_count": null,
"metadata": {
"collapsed": true
},
"outputs": [],
"source": []
},
{
"cell_type": "code",
"execution_count": null,
"metadata": {
"collapsed": true
},
"outputs": [],
"source": []
},
{
"cell_type": "code",
"execution_count": null,
"metadata": {
"collapsed": true
},
"outputs": [],
"source": []
}
],
"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.6.1"
}
},
"nbformat": 4,
"nbformat_minor": 2
}
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment