Follow

Keep Up to Date with the Most Important News

By pressing the Subscribe button, you confirm that you have read and are agreeing to our Privacy Policy and Terms of Use
Contact

Error ' not supported between instances of float and str ' when I try to use .sort() on a Python list

The error is occurring when I try to sort this data list:

    para_planilha = [['2022-04-01T17:00:00Z', '2022/04/01 00:58:25', '-', 'ATSV Erlangen', 'FC Eintracht Bamberg', '-', '-', '-', '-', '-'], ['2022-04-02T03:05:00Z', '2022/04/01 00:58:27', '-', 'Western United', 'Central Coast Mariners', 2.08, 3.75, 3.7, 2.06, 1.78], ['2022-04-01T18:45:00Z', '2022/04/01 00:58:28', '-', 'Kfco Beerschot Wilrijk', 'Club Brugge', 11.0, 1.33, 6.4, 2.5, 1.58], ['2022-04-01T18:30:00Z', '2022/04/01 00:58:29', '-', 'CA Fenix', 'Deportivo Merlo', 3.4, 2.32, 3.85, '-', '-'], ['2022-04-01T23:30:00Z', '2022/04/01 00:58:30', '-', 'CA Ituzaingo', 'CA Colegiales', '-', '-', '-', '-', 3.4], ['2022-04-01T18:45:00Z', '2022/04/01 00:58:31', '-', 'Edinburgh City', 'Kelty Hearts', 4.6, 1.72, 5.5, 2.02, '-'], ['2022-04-01T11:00:00Z', '2022/04/01 00:58:32', '-', 'Navy FC', 'Khonkaen', 4.3, 2.02, 3.7, 1.85, 1.82], ['2022-04-01T16:00:00Z', '2022/04/01 00:58:33', '-', 'Samger FC', 'Banjul United', '-', '-', '-', '-', '-'], ['2022-04-01T18:45:00Z', '2022/04/01 00:58:34', '-', 'Connahs Quay', 'Aberystwyth', '-', '-', '-', '-', '-'], ['2022-04-01T18:45:00Z', '2022/04/01 00:58:35', '-', 'Caernarfon Town', 'The New Saints', '-', '-', '-', '-', '-'], ['2022-04-01T17:00:00Z', '2022/04/01 00:58:36', '-', 'Tuzlaspor', 'Umraniyespor', 4.3, 1.96, 3.85, 1.78, 2.26], ['2022-04-01T17:30:00Z', '2022/04/01 00:58:37', '-', 'Yverdon Sport', 'FC Vaduz', 2.22, 3.45, 3.8, 2.06, 1.95], ['2022-04-01T17:30:00Z', '2022/04/01 00:58:38', '-', 'Rot-Weiss Essen', 'FC Koln II', '-', '-', '-', 4.3, 1.3], ['2022-04-01T15:45:00Z', '2022/04/01 00:58:38', '-', 'Herstedoester IC', 'Avarta', '-', '-', '-', '-', '-'], ['2022-04-01T17:00:00Z', '2022/04/01 00:58:39', '-', 'SV Tasmania Berlin', 'Berliner AK', '-', 1.57, 4.8, 2.1, 1.86], ['2022-04-01T16:00:00Z', '2022/04/01 00:58:40', '-', 'Tallinna Kalev', 'Paide Linnameeskond', 80.0, '-', '-', 3.35, 1.33], ['2022-04-01T12:00:00Z', '2022/04/01 00:58:41', '-', 'Millwall U23', 'Peterborough United U23', 2.18, 2.96, 3.5, 2.56, 1.48], ['2022-04-01T18:45:00Z', '2022/04/01 00:58:42', '-', 'Hull', 'Huddersfield', 2.88, 2.84, 3.35, 1.74, 2.34], ['2022-04-01T23:00:00Z', '2022/04/01 00:58:43', '-', 'Palmeiras (W)', 'CR Flamengo (W)', 1.56, 6.0, 4.1, '-', 1.88], ['2022-04-01T16:00:00Z', '2022/04/01 00:58:44', '-', 'SFC Opava', 'Vysocina Jihlava', 1.71, 4.6, '-', '-', 1.75], ['2022-04-02T00:10:00Z', '2022/04/01 00:58:45', '-', 'Belgrano', 'All Boys', '-', '-', 3.75, '-', '-'], ['2022-04-01T16:00:00Z', '2022/04/01 00:58:46', '-', 'FC Zbrojovka Brno', 'Pribram', 1.45, 10.5, 4.3, '-', 1.64], ['2022-04-01T14:30:00Z', '2022/04/01 00:58:47', '-', 'FK Nevezis', 'BFA Vilnius', '-', '-', '-', 4.5, '-'], ['2022-04-02T00:15:00Z', '2022/04/01 00:58:48', '-', 'Resistencia SC', 'Olimpia', '-', 1.84, '-', '-', 1.78], ['2022-04-01T14:00:00Z', '2022/04/01 00:58:49', '-', 'FCV Farul Constanta II', 'CS Gloria Albesti', '-', '-', '-', '-', '-'], ['2022-04-01T14:00:00Z', '2022/04/01 00:58:51', '-', 'CSM Deva', 'Vointa Lupac', '-', '-', '-', 2.14, '-'], ['2022-04-01T22:00:00Z', '2022/04/01 00:58:52', '-', 'Cerro Porteno', '12 de Octubre de Itaugua', 1.42, '-', '-', '-', 1.7], ['2022-04-01T14:00:00Z', '2022/04/01 00:58:53', '-', 'Csm Slatina', 'ACS Vedita Colonesti MS', '-', '-', '-', '-', '-'], ['2022-04-01T14:00:00Z', '2022/04/01 00:58:53', '-', 'CSM Flacara Moreni', 'ACS FC Academica Clinceni 2', '-', '-', '-', '-', '-'], [2.36, '-'], ['2022-04-01T14:00:00Z', '2022/04/01 00:58:55', '-', 'Dinamo Bucuresti II', 'CS Real Bradu', 1.93, '-', '-', '-', '-'], ['2022-04-01T14:00:00Z', '2022/04/01 00:58:56', '-', 'FCSB II', 'FC Arges II', '-', '-', '-', '-', '-'], ['2022-04-01T18:00:00Z', '2022/04/01 00:58:57', '-', 'Mezokovesd-Zsory', 'Gyirmot', 2.16, 4.6, 3.35, 1.78, 2.26], ['2022-04-01T14:00:00Z', '2022/04/01 00:58:58', '-', 'CFR Cluj SA II', 'CSM Satu Mare', '-', '-', '-', 2.12, '-'], ['2022-04-02T00:00:00Z', '2022/04/01 00:58:59', '-', 'Estudiantes Rio Cuarto', 'Atletico Rafaela', 2.34, '-', 3.0, '-', '-'], ['2022-04-02T00:30:00Z', '2022/04/01 00:59:00', '-', 'Gimnasia Jujuy', 'Chaco For Ever', '-', 2.96, 2.8, '-', '-'], ['2022-04-01T18:00:00Z', '2022/04/01 00:59:01', '-', 'Fulham U23', 'Birmingham U23', 1.41, '-', '-', 2.8, '-'], ['2022-04-01T19:00:00Z', '2022/04/01 00:59:02', '-', 'Girona', 'Malaga', 1.58, 7.4, 4.5, 1.76, '-'], ['2022-04-01T18:00:00Z', '2022/04/01 00:59:04', '-', 'Boca Juniors (W)', 'Gimnasia de La Plata (W)', '-', '-', '-', '-', '-'], ['2022-04-01T22:00:00Z', '2022/04/01 00:59:05', '-', 'Patronato', 'Union Santa Fe', 3.95, 2.28, 3.4, '-', '-'], ['2022-04-01T17:30:00Z', '2022/04/01 00:59:06', '-', 'Schaffhausen', 'Neuchatel Xamax', 1.86, 4.6, 3.75, 2.12, '-'], ['2022-04-01T17:00:00Z', '2022/04/01 00:59:07', '-', 'Krka', 'Krsko', '-', '-', '-', '-', '-'], ['2022-04-01T18:15:00Z', '2022/04/01 00:59:08', '-', 'FC Wil', 'Aarau', 3.75, 1.96, 4.5, 2.74, 1.57], ['2022-04-01T17:00:00Z', '2022/04/01 00:59:09', '-', 'BK Hacken (W)', 'Hammarby (W)', 1.41, 8.6, 5.6, 2.48, '-'], ['2022-04-01T15:00:00Z', '2022/04/01 00:59:10', '-', 'FK Spartaks', 'Liepajas Metalurgs', '-', '-', '-', '-', '-'], ['2022-04-01T16:30:00Z', '2022/04/01 00:59:11', '-', 'Triglav', 'Drava (Slovenia)', '-', 24.0, '-', 3.2, 1.49], ['2022-04-01T17:00:00Z', '2022/04/01 00:59:12', '-', 'Assyriska BK', 'Varbergs GIF', 2.34, '-', '-', '-', '-'], ['2022-04-02T01:00:00Z', '2022/04/01 00:59:13', '-', 'San Francisco FC', 'Plaza Amador', '-', '-', 2.86, '-', '-'], ['2022-04-01T14:15:00Z', '2022/04/01 00:59:14', '-', 'Khaitan', 'Al Yarmouk', 2.16, '-', 3.65, '-', '-'], ['2022-04-01T10:45:00Z', '2022/04/01 00:59:15', '-', 'Maccabi Kabilio Jaffa', 'AS Nordia Jerusalem', '-', 15.0, 6.2, 1.89, 1.93], ['2022-04-01T15:00:00Z', '2022/04/01 00:59:16', '-', 'FC Viktoria Otrokovice', 'H Slavia Kromeriz', '-', '-', '-', '-', '-'], ['2022-04-01T10:45:00Z', '2022/04/01 00:59:17', '-', 'Hapoel Azor', 'Ironi Kuseife', 1.9, 3.55, 3.25, 1.78, '-'], ['2022-04-01T14:30:00Z', '2022/04/01 00:59:18', '-', 'FC U Craiova 1948', 'CS Mioveni', 2.06, 4.8, 3.2, 1.45, '-'], ['2022-04-01T09:00:00Z', '2022/04/01 00:59:19', '-', 'Hapoel Bikat Hayarden', 'Hapoel Bnei Lod', '-', 7.0, 5.1, 1.97, '-'], ['2022-04-01T17:00:00Z', '2022/04/01 00:59:20', '-', 'Toolon Taisto', 'Sexy Poxyt', '-', '-', '-', '-', '-'], ['2022-04-01T17:30:00Z', '2022/04/01 00:59:21', '-', 'Chindia Targoviste', 'Dinamo Bucharest', 2.04, 5.3, 3.35, '-', 2.8], ['2022-04-01T17:00:00Z', '2022/04/01 00:59:22', '-', 'PuiU Helsinki', 'HIFK 2', '-', '-', '-', '-', '-'], ['2022-04-01T18:15:00Z', '2022/04/01 00:59:22', '-', 'Sporting Cristal', 'Uni San Martin', '-', 9.8, 6.2, 2.5, 1.57], ['2022-04-01T18:00:00Z', '2022/04/01 00:59:23', '-', 'Siegburger SV\xa004', 'Borussia Freialdenhoven', '-', '-', '-', '-', '-'], ['2022-04-01T16:00:00Z', '2022/04/01 00:59:25', '-', 'Markez Tulkrem', 'Hilal Al Quds', 7.8, 1.55, 4.7, 2.5, 1.5], ['2022-04-01T16:30:00Z', '2022/04/01 00:59:25', '-', 'Kolubara Lazarevac', 'Mladost Lucani', '-', '-', '-', 1.89, 1.96], ['2022-04-01T16:30:00Z', '2022/04/01 00:59:27', '-', 'Fredericia', 'Hvidovre', 2.26, 3.3, 3.8, '-', 1.84], ['2022-04-01T16:00:00Z', '2022/04/01 00:59:27', '-', 'Thisted (W)', 'Fortuna Hjorring (W)', '-', '-', '-', '-', '-'], ['2022-04-01T17:00:00Z', '2022/04/01 00:59:29', '-', 'Fremad Amager', 'Jammerbught FC', 1.57, 7.0, 4.5, 2.1, 1.9], ['2022-04-01T13:00:00Z', '2022/04/01 00:59:30', '-', 'Maccabi Ahi Nazareth', 'Beitar Tel Aviv Ramla', 2.56, 3.55, 3.1, '-', '-'], ['2022-04-02T00:40:00Z', '2022/04/01 00:59:31', '-', 'La Equidad', 'Deportivo Cali', '-', 3.8, 2.94, 1.54, '-'], ['2022-04-01T17:00:00Z', '2022/04/01 00:59:31', '-', 'Viborg', 'SonderjyskE', 1.78, 5.5, 3.85, 1.99, 2.0], ['2022-04-01T18:30:00Z', '2022/04/01 00:59:32', '-', 'Podbeskidzie B-B', 'LKS Lodz', 2.32, 3.85, 3.3, '-', '-'], ['2022-04-01T18:45:00Z', '2022/04/01 00:59:34', '-', 'Sligo Rovers', 'Shelbourne', 1.82, 5.6, 3.7, '-', '-'], ['2022-04-01T17:30:00Z', '2022/04/01 00:59:34', '-', 'ASV Drassburg', 'SC Mannsdorf', '-', '-', '-', '-', '-'], ['2022-04-01T19:00:00Z', '2022/04/01 00:59:35', '-', 'Alafoss', 'UMF Tindstoll', '-', '-', '-', '-', '-'], ['2022-04-01T19:15:00Z', '2022/04/01 00:59:36', '-', 'IR Reykjavik', 'Throttur', '-', '-', '-', '-', '-'], ['2022-04-01T16:00:00Z', '2022/04/01 00:59:37', '-', 'Gambia Ports Authority', 'Banjul Hawks FC', '-', '-', '-', '-', '-'], ['2022-04-01T17:00:00Z', '2022/04/01 00:59:38', '-', 'Red Star', 'Creteil', 1.63, '-', '-', '-', 2.2], ['2022-04-01T17:00:00Z', '2022/04/01 00:59:39', '-', 'FC Bastia-Borgo', 'Stade Briochin', '-', 2.72, 3.05, 1.62, 1.45], ['2022-04-01T15:30:00Z', '2022/04/01 00:59:40', '-', 'Moghreb Tetouan', 'Raja Beni Mellal', '-', '-', '-', '-', '-'], ['2022-04-01T17:00:00Z', '2022/04/01 00:59:41', '-', 'Orleans', 'Le Mans', 2.42, '-', 3.25, 1.78, 2.28], ['2022-04-01T19:15:00Z', '2022/04/01 00:59:42', '-', 'Braga', 'Benfica', 3.4, 2.24, 3.6, 2.06, 1.84], ['2022-04-01T17:00:00Z', '2022/04/01 00:59:43', '-', 'Annecy', 'Avranches', 1.58, 7.4, 3.75, 1.71, 2.26], ['2022-04-01T18:00:00Z', '2022/04/01 00:59:44', '-', 'Lierse', 'Waasland-Beveren', 3.2, 2.28, 3.8, '-', 1.75], ['2022-04-01T15:30:00Z', '2022/04/01 00:59:45', '-', 'Stade Marocain du Rabat', 'Waf Widad Fes', '-', 5.6, 3.2, '-', '-'], ['2022-04-01T17:00:00Z', '2022/04/01 00:59:45', '-', 'Boulogne', 'Sete', 2.46, 3.8, 2.94, 1.56, 2.56], ['2022-04-01T17:00:00Z', '2022/04/01 00:59:46', '-', 'Chambly Oise', 'Chateauroux', 4.3, 2.2, 3.3, 1.63, 2.36], ['2022-04-01T17:00:00Z', '2022/04/01 00:59:47', '-', 'Concarneau', 'Bourg-en-Bresse', '-', '-', 3.1, 1.55, '-'], ['2022-04-01T17:00:00Z', '2022/04/01 00:59:48', '-', 'Villefranche Beaujolais', 'Cholet SO', 1.63, 7.0, '-', 1.92, 2.02], ['2022-04-01T16:00:00Z', '2022/04/01 00:59:49', '-', 'Sandecja Nowy Sacz', 'Korona Kielce', '-', '-', 3.05, 1.68, '-'], ['2022-04-01T17:30:00Z', '2022/04/01 00:59:50', '-', 'Alkmaar (W)', 'Feyenoord (W)', '-', '-', '-', 2.9, 1.55], ['2022-04-01T17:30:00Z', '2022/04/01 00:59:51', '-', 'ADO Den Haag (W)', 'FC Zwolle (W)', 1.74, '-', '-', '-', '-'], ['2022-04-01T18:45:00Z', '2022/04/01 00:59:52', '-', 'Wexford F.C', 'Cork City', '-', 1.89, '-', '-', '-'], ['2022-04-01T17:30:00Z', '2022/04/01 00:59:53', '-', 'PSV Eindhoven (W)', 'Heerenveen (W)', 1.32, '-', '-', 3.5, '-'], ['2022-04-01T18:45:00Z', '2022/04/01 00:59:54', '-', 'Waterford', 'Longford', 1.59, 5.9, 4.4, '-', 1.9], ['2022-04-01T17:30:00Z', '2022/04/01 00:59:55', '-', 'Excelsior (W)', 'Twente (W)', '-', 1.13, '-', '-', 1.17], ['2022-04-02T00:00:00Z', '2022/04/01 00:59:56', '-', 'Univ Catolica (Ecu)', 'Barcelona (Ecu)', 2.54, 3.0, 3.3, '-', '-'], ['2022-04-02T02:00:00Z', '2022/04/01 00:59:57', '-', 'Emelec', 'LDU', '-', 3.65, '-', 2.34, '-'], ['2022-04-01T18:45:00Z', '2022/04/01 00:59:58', '-', 'St Patricks', 'Drogheda', 1.46, 9.0, 4.8, '-', '-'], ['2022-04-01T18:45:00Z', '2022/04/01 00:59:59', '-', 'Ayr', 'Hamilton', 2.78, 2.94, 3.25, '-', '-'], ['2022-04-01T12:15:00Z', '2022/04/01 01:00:00', '-', 'Shimshon Tel Aviv', 'Maccabi Ashdod B.C.', '-', '-', 3.2, 1.8, '-'], ['2022-04-01T14:00:00Z', '2022/04/01 01:00:01', '-', 'Shabab Al Khaleel', 'Shabab Al Dharia', 1.5, '-', '-', 1.99, '-'], ['2022-04-01T17:00:00Z', '2022/04/01 01:00:02', '-', 'SV Meppen', 'Wehen Wiesbaden', 3.9, 2.04, 3.9, 2.08, 1.94], ['2022-04-01T18:30:00Z', '2022/04/01 01:00:03', '-', 'Union Berlin', 'FC Koln', 2.44, 3.35, 3.5, 1.92, 2.04], ['2022-04-01T18:45:00Z', '2022/04/01 01:00:04', '-', 'Morton', 'Kilmarnock', 4.4, 2.0, 3.4, '-', '-'], ['2022-04-02T00:00:00Z', '2022/04/01 01:00:05', '-', 'Universidad Guadalajara', 'Tampico Madero', 1.9, 5.0, 3.45, 1.77, 2.14], ['2022-04-01T14:00:00Z', '2022/04/01 01:00:06', '-', 'CS Constantine', 'Paradou', 1.86, 4.4, '-', '-', 2.62], ['2022-04-01T17:30:00Z', '2022/04/01 01:00:07', '-', 'FCM TQS Traiskirchen', 'SC Wiener Neustadt', '-', '-', '-', '-', '-'], ['2022-04-01T17:00:00Z', '2022/04/01 01:00:08', '-', 'SC Kalsdorf', 'SC Weiz', 2.12, '-', '-', '-', '-'], ['2022-04-01T17:30:00Z', '2022/04/01 01:00:09', '-', 'Wiener SK', 'Ask-Bsc Bruck/Leitha', 1.64, '-', '-', '-', '-'], ['2022-04-01T10:30:00Z', '2022/04/01 01:00:10', '-', 'Hapoel Marmorek', 'Bnei Eilat', 1.57, 5.6, '-', 2.06, 1.85], ['2022-04-01T18:45:00Z', '2022/04/01 01:00:11', '-', 'Dundalk', 'UCD', 1.43, 9.0, '-', 2.02, 1.76], ['2022-04-01T19:00:00Z', '2022/04/01 01:00:12', '-', 'Finn Harps', 'Shamrock Rovers', 6.0, 1.66, '-', 1.75, 2.34], ['2022-04-01T20:00:00Z', '2022/04/01 01:00:13', '-', 'Deportivo Santani', 'Club F de la Mora', '-', '-', '-', '-', '-'], ['2022-04-01T18:45:00Z', '2022/04/01 01:00:14', '-', 'Bohemians', 'Derry City', 2.8, 2.88, 3.35, '-', '-'], ['2022-04-01T17:00:00Z', '2022/04/01 01:00:15', '-', 'FC Gleisdorf 09', 'RZ Pellets WAC (Am)', '-', '-', '-', '-', '-'], ['2022-04-01T16:00:00Z', '2022/04/01 01:00:16', '-', 'FK Velez Mostar', 'Siroki Brijeg', 2.24, 4.3, '-', 1.72, '-'], ['2022-04-01T14:00:00Z', '2022/04/01 01:00:16', '-', 'ASO Chlef', 'US Biskra', 1.8, 7.2, 3.15, '-', 2.86], ['2022-04-01T16:30:00Z', '2022/04/01 01:00:17', '-', 'FC Wacker Innsbruck', 'Floridsdorfer Ac', 2.34, 3.25, 3.8, '-', 1.95], ['2022-04-01T16:30:00Z', '2022/04/01 01:00:18', '-', 'SK Vorwarts Steyr', 'Austria Wien (A)', 2.48, 2.82, 3.9, '-', 1.88], ['2022-04-01T14:30:00Z', '2022/04/01 01:00:19', '-', 'MC Alger', 'Medea', 1.46, '-', '-', 1.72, 2.3], ['2022-04-01T16:30:00Z', '2022/04/01 01:00:20', '-', 'FC Juniors OO', 'SV Horn', 2.76, 2.58, 3.55, 2.1, 1.79], ['2022-04-01T17:30:00Z', '2022/04/01 01:00:21', '-', 'SV Worgl', 'SV Telfs I', '-', '-', '-', '-', '-'], ['2022-04-01T18:25:00Z', '2022/04/01 01:00:22', '-', 'Grazer AK', 'FC Blau Weiss Linz', '-', 2.1, 3.7, 1.99, '-'], ['2022-04-02T02:00:00Z', '2022/04/01 01:00:23', '-', 'San Luis', 'Mazatlan FC', 1.9, 5.3, 3.55, 1.6, 2.42], ['2022-04-01T14:30:00Z', '2022/04/01 01:00:24', '-', 'NC Magra', 'NA Hussein Dey', 2.3, '-', 2.72, 1.48, '-'], ['2022-04-01T16:30:00Z', '2022/04/01 01:00:25', '-', 'SKU Amstetten', 'SC AUSTRIA LUSTENAU', 3.45, 2.08, 4.1, '-', 1.63], ['2022-04-01T18:30:00Z', '2022/04/01 01:00:26', '-', 'Gent (W)', 'Femina WS (W)', '-', '-', '-', 3.9, '-'], ['2022-04-01T16:30:00Z', '2022/04/01 01:00:27', '-', 'SV Lafnitz', 'Ksv 1919', 1.53, 9.2, 4.9, '-', 1.76], ['2022-04-01T17:00:00Z', '2022/04/01 01:00:28', '-', 'Kabylie', 'USM Alger', 1.86, 7.4, 3.25, 1.48, 2.62], ['2022-04-01T18:00:00Z', '2022/04/01 01:00:29', '-', 'FC Dordrecht', 'FC Eindhoven', 5.5, 1.72, 4.3, 2.42, 1.69], ['2022-04-01T18:00:00Z', '2022/04/01 01:00:30', '-', 'Helmond Sport', 'MVV Maastricht', 2.06, 3.55, 4.1, 2.5, 1.59], ['2022-04-01T18:00:00Z', '2022/04/01 01:00:31', '-', 'FC Volendam', 'FC Oss', 1.54, 6.8, 4.8, 2.68, 1.52], ['2022-04-01T18:00:00Z', '2022/04/01 01:00:32', '-', 'Roda JC', 'Jong FC Utrecht', 1.31, 13.5, 6.6, 2.94, '-'], ['2022-04-01T14:15:00Z', '2022/04/01 01:00:33', '-', 'Fk Novi Pazar', 'FK Napredak', 2.68, 2.9, 3.3, 1.92, 2.16], ['2022-04-01T18:00:00Z', '2022/04/01 01:00:34', '-', 'Jong AZ Alkmaar', 'Jong PSV Eindhoven', 3.65, 2.18, 3.9, 2.48, 1.67], ['2022-04-01T18:00:00Z', '2022/04/01 01:00:35', '-', 'Almere City', 'Excelsior', 2.56, 2.72, 4.2, 2.62, 1.57], ['2022-04-01T18:00:00Z', '2022/04/01 01:00:36', '-', 'NAC Breda', 'Jong Ajax Amsterdam', 2.42, 2.78, 4.5, 3.0, 1.44], ['2022-04-01T13:00:00Z', '2022/04/01 01:00:38', '-', 'Agudat Sport Ashdod', 'Bnei Yehuda', 2.58, 3.65, 3.0, '-', '-'], ['2022-04-01T18:00:00Z', '2022/04/01 01:00:39', '-', 'De Graafschap', 'Emmen', 2.86, 2.8, 3.4, 1.79, 2.14], ['2022-04-01T18:00:00Z', '2022/04/01 01:00:40', '-', 'VVV Venlo', 'ADO Den Haag', 2.9, 2.42, 4.0, 2.32, 1.76], ['2022-04-01T13:00:00Z', '2022/04/01 01:00:41', '-', 'Hapoel Akko', 'Hapoel Afula', '-', 3.45, 3.25, '-', '-'], ['2022-04-01T15:00:00Z', '2022/04/01 01:00:43', '-', 'Wolkite Ketema', 'Adama City FC', '-', 2.24, 3.0, '-', '-'], ['2022-04-01T12:00:00Z', '2022/04/01 01:00:44', '-', 'Defence Force SC', 'Arba Minch', '-', '-', 2.86, 1.46, '-'], ['2022-04-01T22:00:00Z', '2022/04/01 01:00:44', '-', 'Nacional Potosi', 'Aurora', 1.53, 9.2, 4.7, '-', 1.67], ['2022-04-02T00:30:00Z', '2022/04/01 01:00:46', '-', 'Blooming Santa Cruz', 'Always Ready', 2.24, 3.25, 3.75, 2.34, '-'], ['2022-04-01T18:45:00Z', '2022/04/01 01:00:47', '-', 'Galway Utd', 'Cobh Ramblers', 1.61, 8.0, '-', 2.12, 1.75], ['2022-04-01T18:45:00Z', '2022/04/01 01:00:48', '-', 'Athlone Town', 'Bray Wanderers', '-', 1.82, '-', 2.54, 1.64], ['2022-04-01T23:00:00Z', '2022/04/01 01:00:49', '-', 'CA Rentistas', 'Penarol', '-', 1.55, '-', 1.95, '-'], ['2022-04-01T18:00:00Z', '2022/04/01 01:00:50', '-', 'Middlesbrough U23', 'Newcastle U23', '-', '-', '-', '-', '-'], ['2022-04-01T18:00:00Z', '2022/04/01 01:00:51', '-', 'Nottm Forest U23', 'Wolves U23', 2.2, 3.6, 4.3, 2.66, '-'], ['2022-04-01T18:00:00Z', '2022/04/01 01:00:52', '-', 'Reading U23', 'West Brom U23', '-', 1.91, '-', '-', '-'], ['2022-04-01T18:00:00Z', '2022/04/01 01:00:53', '-', 'Norwich U23', 'Sunderland U23', 1.74, '-', '-', 2.88, '-'], ['2022-04-01T13:00:00Z', '2022/04/01 01:00:54', '-', 'Hapoel Umm AL Fahm', 'Sektzia Nes Tziona', '-', 2.56, 3.4, '-', '-'], ['2022-04-01T13:00:00Z', '2022/04/01 01:00:55', '-', 'Hapoel Rishon Lezion', 'Ironi Ramat HaSharon', 2.38, '-', 2.9, '-', '-'], ['2022-04-01T18:00:00Z', '2022/04/01 01:00:56', '-', 'Aston Villa U23', 'Stoke U23', '-', 2.46, 3.55, '-', '-'], ['2022-04-01T14:30:00Z', '2022/04/01 01:00:57', '-', 'NK Sesvete', 'Kustosija', 1.89, 4.7, '-', 1.79, '-'], ['2022-04-01T18:15:00Z', '2022/04/01 01:00:58', '-', 'Swieqi United FC', 'Marsa FC', '-', 1.9, 4.4, 2.2, 1.75], ['2022-04-01T17:00:00Z', '2022/04/01 01:00:59', '-', 'Leixoes', 'Penafiel', 2.06, 4.2, 3.4, '-', 2.22], ['2022-04-01T18:45:00Z', '2022/04/01 01:01:00', '-', 'Cliftonville', 'Crusaders', 2.32, '-', '-', '-', 1.98], ['2022-04-01T23:30:00Z', '2022/04/01 01:01:01', '-', 'OHiggins', 'Coquimbo Unido', 2.16, 4.1, '-', 1.77, '-'], ['2022-04-01T15:00:00Z', '2022/04/01 01:01:02', '-', 'San Gwann', 'Pembroke Athleta', '-', 1.75, 3.8, '-', '-'], ['2022-04-01T20:30:00Z', '2022/04/01 01:01:03', '-', 'La Serena', 'Everton De Vina', 3.4, 2.54, 3.2, 1.66, 2.26], ['2022-04-01T18:00:00Z', '2022/04/01 01:01:04', '-', 'SC Telstar', 'Den Bosch', 1.88, '-', '-', '-', 1.68], ['2022-04-01T12:00:00Z', '2022/04/01 01:01:05', '-', 'NK Dubrava Zagreb', 'Cibalia Vinkovci', 1.88, 5.2, '-', 1.78, '-'], ['2022-04-01T16:00:00Z', '2022/04/01 01:01:06', '-', 'Zamalek', 'G.D. Sagrada Esperanca', '-', '-', '-', 1.94, '-'], ['2022-04-01T19:00:00Z', '2022/04/01 01:01:07', '-', 'SS Reyes', 'Racing Santander', 4.2, 2.28, '-', 1.57, '-'], ['2022-04-01T16:00:00Z', '2022/04/01 01:01:08', '-', 'FC Kosice', 'Samorin', 1.6, '-', '-', 2.34, '-'], ['2022-04-01T18:00:00Z', '2022/04/01 01:01:09', '-', 'Anderlecht (W)', 'Club Brugge (W)', 1.26, '-', '-', '-', '-'], ['2022-04-01T15:00:00Z', '2022/04/01 01:01:10', '-', 'Podbrezova', 'FK Puchov', 1.41, 8.6, 5.6, 2.38, 1.6], ['2022-04-01T21:15:00Z', '2022/04/01 01:01:11', '-', 'Zamora FC', 'Mineros Guayana', 1.99, '-', 3.5, 1.73, '-'], ['2022-04-01T21:45:00Z', '2022/04/01 01:01:12', '-', 'CF America (W)', 'FC Juarez (W)', '-', '-', '-', '-', '-'], ['2022-04-01T23:30:00Z', '2022/04/01 01:01:13', '-', 'Deportivo La Guaira', 'Estudiantes de Merida', 2.18, 4.4, 3.25, '-', '-'], ['2022-04-01T19:00:00Z', '2022/04/01 01:01:14', '-', 'CD Castellon', 'Alcoyano', 2.16, '-', 3.15, '-', '-'], ['2022-04-01T19:00:00Z', '2022/04/01 01:01:15', '-', 'Metropolitanos', 'Carabobo FC', 2.3, 4.1, 3.0, 1.68, 2.56], ['2022-04-01T23:00:00Z', '2022/04/01 01:01:16', '-', 'Queretaro (W)', 'Club Tijuana (W)', '-', '-', '-', '-', 1.65], ['2022-04-02T02:30:00Z', '2022/04/01 01:01:17', '-', 'Deportivo Saprissa', 'Municipal Grecia', 1.63, '-', '-', 1.97, 1.92], ['2022-04-01T17:00:00Z', '2022/04/01 01:01:18', '-', 'Roskilde', 'Vanlose IF', 1.39, 9.0, 6.0, 2.92, 1.53], ['2022-04-01T17:00:00Z', '2022/04/01 01:01:19', '-', 'Hellerup IK', 'Akademisk Boldklub', '-', '-', '-', '-', '-'], ['2022-04-01T22:30:00Z', '2022/04/01 01:01:20', '-', 'Real Cartagena', 'Llaneros FC', 2.26, 3.7, 3.3, 1.72, 2.38], ['2022-04-01T12:30:00Z', '2022/04/01 01:01:21', '-', 'NK Orijent U19', 'NK Istra 1961 U19', '-', '-', '-', 2.2, '-'], ['2022-04-01T16:00:00Z', '2022/04/01 01:01:22', '-', 'Stal Mielec', 'Cracovia Krakow', 3.65, 2.36, 3.4, 1.68, '-'], ['2022-04-01T13:00:00Z', '2022/04/01 01:01:23', '-', 'Etoile Sportive Sahel', 'Jwaneng Galaxy FC', 1.11, 19.0, '-', 2.34, 1.68], ['2022-04-01T13:30:00Z', '2022/04/01 01:01:24', '-', 'HNK Sibenik U19', 'NK Varazdin U19', '-', '-', '-', 2.7, '-'], ['2022-04-01T16:00:00Z', '2022/04/01 01:01:25', '-', 'Horoya AC', 'AmaZulu', '-', '-', '-', 1.66, '-'], ['2022-04-01T18:30:00Z', '2022/04/01 01:01:26', '-', 'Slask Wroclaw', 'Lech Poznan', 6.2, 1.66, 3.85, 1.79, '-'], ['2022-04-01T16:30:00Z', '2022/04/01 01:01:27', '-', 'Riteriai', 'FK Jonava', '-', 36.0, 8.6, 2.4, 1.63], ['2022-04-01T11:45:00Z', '2022/04/01 01:01:28', '-', 'Hougang Utd', 'Albirex Niigata (SIN)', 8.2, 1.4, 7.6, 3.35, 1.36], ['2022-04-01T19:30:00Z', '2022/04/01 01:01:29', '-', 'Gimnasia La Plata', 'Talleres', 2.68, 3.0, 3.1, '-', 2.26], ['2022-04-01T17:00:00Z', '2022/04/01 01:01:30', '-', 'Babelsberg', 'Union Furstenwalde', 1.44, '-', '-', 2.44, '-'], ['2022-04-01T17:00:00Z', '2022/04/01 01:01:31', '-', 'VfB Homberg', 'Schalke 04 II', 4.9, 1.82, 3.9, 2.02, 1.88], ['2022-04-01T17:00:00Z', '2022/04/01 01:01:32', '-', 'Hertha Berlin II', 'VfB Auerbach', 1.49, '-', '-', 2.66, 1.58], ['2022-04-01T16:00:00Z', '2022/04/01 01:01:33', '-', 'FK Babrungas', 'FK Banga II', 1.75, '-', '-', 3.15, 1.47], ['2022-04-01T11:45:00Z', '2022/04/01 01:01:34', '-', 'Home Utd', 'Balestier Khalsa', 1.18, 23.0, 9.8, 2.2, 1.26], ['2022-04-01T10:00:00Z', '2022/04/01 01:01:35', '-', 'Fukuoka', 'Tosu', 2.62, 3.4, 3.0, 1.52, 2.92], ['2022-04-01T17:30:00Z', '2022/04/01 01:01:37', '-', 'Havnar Boltfelag II', 'Klaksvikar Itrottarfelag II', '-', 2.02, '-', '-', '-'], ['2022-04-01T19:15:00Z', '2022/04/01 01:01:38', '-', 'Stjarnan (W)', 'Breidablik (W)', '-', 1.92, '-', '-', '-'], ['2022-04-01T17:30:00Z', '2022/04/01 01:01:38', '-', 'Barmbek-Uhlenhorst', 'FC Suderelbe', '-', 1.95, '-', '-', 1.34], ['2022-04-01T22:00:00Z', '2022/04/01 01:01:39', '-', 'Central Cordoba (SdE)', 'Huracan', '-', '-', 3.15, 1.62, '-'], ['2022-04-02T00:30:00Z', '2022/04/01 01:01:41', '-', 'Banfield', 'Argentinos Juniors', 2.56, '-', '-', '-', '-'], ['2022-04-01T16:30:00Z', '2022/04/01 01:01:42', '-', 'Ingolstadt', 'Erzgebirge', 2.52, 2.94, 3.6, 2.1, 1.87], ['2022-04-02T00:00:00Z', '2022/04/01 01:01:43', '-', 'LD Alajuelense', 'Santos de Guapiles', 1.42, '-', '-', 2.2, '-'], ['2022-04-01T20:00:00Z', '2022/04/01 01:01:43', '-', 'CF Union Viera', 'Las Palmas C', 4.3, 2.48, 3.35, 1.78, '-'], ['2022-04-01T20:30:00Z', '2022/04/01 01:01:44', '-', 'Ayacucho Futbol Club', 'UTC Cajamarca', 2.08, 3.9, 3.8, 1.99, '-'], ['2022-04-01T03:01:19Z', '2022/04/01 01:01:45', '-', 'Santos Laguna (W)', 'Puebla FC (W)', 2.88, 4.5, 2.26, 1.12, 8.8], ['2022-04-01T18:00:00Z', '2022/04/01 01:01:46', '-', 'CD Pamplona', 'CD Huarte', 2.94, 2.64, 3.6, '-', '-'], ['2022-04-01T03:01:51Z', '2022/04/01 01:01:47', '-', 'Club Leon FC (W)', 'Cruz Azul (W)', 4.2, 3.15, 2.3, 3.2, 1.42], ['2022-04-01T02:33:13Z', '2022/04/01 01:01:48', '-', 'CS Cartagines', 'ADR Jicaral', 2.1, 11.5, 2.24, 1.07, 17.0], ['2022-04-01T18:00:00Z', '2022/04/01 01:01:49', '-', 'Birmingham (W)', 'Everton (W)', 5.3, 1.7, 3.95, '-', '-'], ['2022-04-01T17:00:00Z', '2022/04/01 01:01:50', '-', 'Illertissen', 'Unterhaching', 2.56, 2.84, 3.45, '-', '-'], ['2022-04-01T21:00:00Z', '2022/04/01 01:01:51', '-', 'AD Guanacasteca', 'Guadalupe F.C', '-', '-', '-', '-', '-'], ['2022-04-01T17:00:00Z', '2022/04/01 01:01:52', '-', 'SC Eltersdorf', 'TSV Rain/Lech', 2.32, 3.25, 4.0, 2.7, '-'], ['2022-04-01T17:30:00Z', '2022/04/01 01:01:53', '-', 'FC Memmingen', 'Viktoria Aschaffenburg', 2.84, 2.6, '-', 2.24, '-'], ['2022-04-01T18:00:00Z', '2022/04/01 01:01:54', '-', 'CD Gares', 'UDC Txantrea', '-', 1.46, '-', 2.42, '-'], ['2022-04-01T15:00:00Z', '2022/04/01 01:01:55', '-', 'Zilina', 'Ruzomberok', 2.48, 3.3, 3.75, 2.08, 1.83], ['2022-04-01T16:30:00Z', '2022/04/01 01:01:56', '-', 'Dynamo Dresden', 'Schalke 04', 4.9, 1.86, 3.85, 2.06, 1.82]]

    para_planilha.sort()

I’ve seen some people indicating something like:

para_planilha = para_planilha.astype('str')
para_planilha.sort()

But this error appears:

MEDevel.com: Open-source for Healthcare and Education

Collecting and validating open-source software for healthcare, education, enterprise, development, medical imaging, medical records, and digital pathology.

Visit Medevel

AttributeError: 'list' object has no attribute 'astype'

How should I proceed to solve this problem and get sort this list?

>Solution :

There is an error in your list data. I replaced the string "]," with the string "],\n" so I could see the structure. The 30th entry is wrong:

...
['2022-04-01T14:00:00Z', '2022/04/01 00:58:53', '-', 'Csm Slatina', 'ACS Vedita Colonesti MS', '-', '-', '-', '-', '-'],
['2022-04-01T14:00:00Z', '2022/04/01 00:58:53', '-', 'CSM Flacara Moreni', 'ACS FC Academica Clinceni 2', '-', '-', '-', '-', '-'],
[2.36, '-'],
['2022-04-01T14:00:00Z', '2022/04/01 00:58:55', '-', 'Dinamo Bucuresti II', 'CS Real Bradu', 1.93, '-', '-', '-', '-'],
['2022-04-01T14:00:00Z', '2022/04/01 00:58:56', '-', 'FCSB II', 'FC Arges II', '-', '-', '-', '-', '-'],
...

If you fix the data, it will sort just fine.

Followup

You can fix the data via

para_planiha = [k for k in para_planiha if len(k) > 2]
Add a comment

Leave a Reply

Keep Up to Date with the Most Important News

By pressing the Subscribe button, you confirm that you have read and are agreeing to our Privacy Policy and Terms of Use

Discover more from Dev solutions

Subscribe now to keep reading and get access to the full archive.

Continue reading