Comments (4)
Similar issue with unnecessary space symbol.
Following players in the overall list have to undergo name trimming - they have extra blank space in the end that forces negative results during string comparisons:
Player id,Name
200707,Max Colorado
209984,Milos Karol
209404,Marc Othman Ktiri
210017,Daniel Merida Aguilar
209890,Mili Poljicak
209865,Peter Benjamin Privara
from tennis_atp.
I forgot to tag this issue -- I ran my own query to check for these, but I think I got all of the players you listed:
583aad6
from tennis_atp.
There is more of this in new added players. Probably you shall run your query before committing new players
player_id,name
210058,Marko Stakusic
210074,Dusan Trunic
210076,Ioannis Kountourakis
210078,Berk Bugarikj
210107,Bor Artnak
210124,Mehdi Sadaoui
210174,Matic Dimic
210177,Gustavo Tedesco
210183,Marcel Kamrowski
210195,Nicolo Pozzani
210208,Luka Kalenic
210222,Adrian Contreras
210232,Illya Maksymchuk
210251,Dean Cooper Kirby
210253,Ivan Bas Mengual
210313,Maxime Dubouch
210314,Artur Khairutdinov
210330,Evangelos Kypriotis
210347,Egor Tsarapkin
210359,Frazier Rengifo
210364,Mateo Castañeda
210367,Xavi Calduch
210402,Ivan La Cava
210429,Pietro Romeo Scomparin
210443,Sandro Cottino
210458,Bernardo Munk Mesa
210480,Alberto Puello
210482,Anargha Ganguly
210485,Togan Tokac
210488,Roger Pascual Ferra
210542,Marco Franzini
210546,Jan Kobierski
210555,Andrej Djokic
210574,Jeiden Saidizand
210589,Stepan Mruzek
210594,Ivan Kremenchutskyi
210603,Anthony Turchi
210604,Loann Massard
210605,Liam Branger
210615,Egor Khotchenkov
210629,Alejandro Juan Mano
210633,Sergi Mico Fenollar
210641,Diego Marin
210645,Ofek Shimanov
210660,Luis Francisco
210715,Yaroslav Demin
210725,Mathis Debru
210726,Cesar Bouchelaghem
210747,Lui Maxted
210752,Max Cunat
211319,Daniel Zimmermann
211335,Jaka Protic Zakelj
211341,Tommy Czaplinski
211360,Filipe Grebentsov
211405,Daniil Piatrouski
211409,Guillaume Dalmasso
211460,Yuki Mochizuki
211470,Christian Teszari
211474,Pablo Trochu
211476,Milan Gonela
211486,Haesun Lee
211505,Denis Constantin Spiridon
211533,Gianluca Cadenasso
211536,Patrik Meszaros
211543,Lorenzo Sciahbasi
211565,Ricardo Villacorta
211576,Marc Antoine Gaillard
211590,Dimitrije Zubac
211593,Romeo Hadzimehmedovic
211619,Bruno Sanchez Sanchez
211621,Arthur Nagel
211679,Alex Andre Ojassalu
211697,Matias Cortes
211710,Niccolo Festini Mira
211719,Carles Cordoba
211764,Eskander Guryev
211769,Irakli Tsurtsumia
212024,Alejandro Melero Kretzer
212051,Joaquin Aguilar Cardozo
212073,Amirali Ghavam
212097,Alexander Pundel
from tennis_atp.
Additional double spaces:
player_id,name
210082,Nicoas Acevedo Olmos
210352,Santiago Lora
210359,Frazier Rengifo
210369,Constantin Frantzen
210372,Reece Yakubov
210376,Max Sheldon
210379,Mateo Labuckas
210432,Felix Einig
210628,Luca Julian Hotze
210636,Camden Camacho
211502,Hank Trondson
211510,Rodrigo Izquierdo Casal
211616,Juan Diego Alzate Perilla
211655,Julian Alonso
211671,Jerry Roddick
211696,Santiago Russo
211697,Matias Cortes
211712,Phil Exner
211748,Enzo Fortes
211788,Enrico Giacomini
212048,Eber Amaury Molina Hurtado
212050,Junior Tavarez
212051,Joaquin Aguilar Cardozo
The first on the list looks suspect: "Nicoas" is probably "Nicolas"
from tennis_atp.
Related Issues (20)
- Wrong Daniel Vallejo HOT 1
- Score discrepancies between ATP and ITF. HOT 99
- ATP Ranking is not correct
- Questionable reliability of ATP data on handedness. HOT 1
- Wrong DOB for Andrei Dirzu
- Indoor/Outdoor distinction
- missing some 2016 Davis Cup results
- Double Martin,Landaluce
- Missing minutes values for Roland Garros 2022 HOT 5
- Murcia 1977
- Duplicate player IDs in the last drop HOT 1
- Incorrect wikidata ID for Alexander Zverev HOT 1
- one player HOT 2
- DIfferent delimiter than in other files HOT 1
- February update HOT 4
- 2024 stats HOT 1
- Incorrect ATP Players DOB formats
- Incorrect DOB
- matches_2024 june data HOT 1
- Fixing 'tourney_name' columns for US open. Will recommend changing it to 'US Open' from 'Us Open' for 2023, 2022, 2021 and 2020 ATP file.
Recommend Projects
-
React
A declarative, efficient, and flexible JavaScript library for building user interfaces.
-
Vue.js
🖖 Vue.js is a progressive, incrementally-adoptable JavaScript framework for building UI on the web.
-
Typescript
TypeScript is a superset of JavaScript that compiles to clean JavaScript output.
-
TensorFlow
An Open Source Machine Learning Framework for Everyone
-
Django
The Web framework for perfectionists with deadlines.
-
Laravel
A PHP framework for web artisans
-
D3
Bring data to life with SVG, Canvas and HTML. 📊📈🎉
-
Recommend Topics
-
javascript
JavaScript (JS) is a lightweight interpreted programming language with first-class functions.
-
web
Some thing interesting about web. New door for the world.
-
server
A server is a program made to process requests and deliver data to clients.
-
Machine learning
Machine learning is a way of modeling and interpreting data that allows a piece of software to respond intelligently.
-
Visualization
Some thing interesting about visualization, use data art
-
Game
Some thing interesting about game, make everyone happy.
Recommend Org
-
Facebook
We are working to build community through open source technology. NB: members must have two-factor auth.
-
Microsoft
Open source projects and samples from Microsoft.
-
Google
Google ❤️ Open Source for everyone.
-
Alibaba
Alibaba Open Source for everyone
-
D3
Data-Driven Documents codes.
-
Tencent
China tencent open source team.
from tennis_atp.