#datacleaning — Public Fediverse posts

🐘 Αποκωδικοποιώντας τα #NULL!, #VALUE! και #REF! στο @ONLYOFFICE

Στο νέο post:

🔹 Γιατί η =SUM(A1:A5 C1:C5) επιστρέφει #NULL!
🔹 Το #VALUE! από αόρατα spaces ή αριθμούς ως κείμενο (και πώς τα φτιάχνει η VALUE() & TRIM() )
🔹 Το #REF! – ο "δολοφόνος" όταν διαγράφετε γραμμές

👉 Όλα αυτά, με παραδείγματα, στο άρθρο του ONLYOFFICE (Open Source, δωρεάν, συμβατό με .xlsx)

https://www.onlyoffice.com/blog/el/2026/05/most-frequent-errors-in-spreadsheet-tables

#OnlyOffice #OpenSource #Spreadsheets #FOSS #Excel #DataCleaning #Tech #TechWriting

Missing [Survey, etc] Data Can Be A Geographic Phenomenon
--
https://doi.org/10.1080/24694452.2026.2640220 <-- shared paper
--
#GIS #mapping #spatial #DataScience #missing #data #spatial #AAG #autocorrelation #geographicallyweightedregression #GWR #imputation #missingdata #survey #surveynonresponse #incomplete #surveyquestions #ethnicity #income #spatialdata #alldataisspatial #UK #FinancialLives #geography #spatialanalysis #geostatistics #location #imputing #statistics #dataset #DataImputation #MissingData #DataCleaning #DataPreprocessing #DataWrangling #DataQuality #DataEngineering #FinancialData #FinancialAnalytics #FinincialModeling #FinDataScience

Missing [Survey, etc] Data Can Be A Geographic Phenomenon
--
https://doi.org/10.1080/24694452.2026.2640220 <-- shared paper
--
#GIS #mapping #spatial #DataScience #missing #data #spatial #AAG #autocorrelation #geographicallyweightedregression #GWR #imputation #missingdata #survey #surveynonresponse #incomplete #surveyquestions #ethnicity #income #spatialdata #alldataisspatial #UK #FinancialLives #geography #spatialanalysis #geostatistics #location #imputing #statistics #dataset #DataImputation #MissingData #DataCleaning #DataPreprocessing #DataWrangling #DataQuality #DataEngineering #FinancialData #FinancialAnalytics #FinincialModeling #FinDataScience

Missing [Survey, etc] Data Can Be A Geographic Phenomenon
--
https://doi.org/10.1080/24694452.2026.2640220 <-- shared paper
--
#GIS #mapping #spatial #DataScience #missing #data #spatial #AAG #autocorrelation #geographicallyweightedregression #GWR #imputation #missingdata #survey #surveynonresponse #incomplete #surveyquestions #ethnicity #income #spatialdata #alldataisspatial #UK #FinancialLives #geography #spatialanalysis #geostatistics #location #imputing #statistics #dataset #DataImputation #MissingData #DataCleaning #DataPreprocessing #DataWrangling #DataQuality #DataEngineering #FinancialData #FinancialAnalytics #FinincialModeling #FinDataScience

Missing [Survey, etc] Data Can Be A Geographic Phenomenon
--
https://doi.org/10.1080/24694452.2026.2640220 <-- shared paper
--
#GIS #mapping #spatial #DataScience #missing #data #spatial #AAG #autocorrelation #geographicallyweightedregression #GWR #imputation #missingdata #survey #surveynonresponse #incomplete #surveyquestions #ethnicity #income #spatialdata #alldataisspatial #UK #FinancialLives #geography #spatialanalysis #geostatistics #location #imputing #statistics #dataset #DataImputation #MissingData #DataCleaning #DataPreprocessing #DataWrangling #DataQuality #DataEngineering #FinancialData #FinancialAnalytics #FinincialModeling #FinDataScience

Missing [Survey, etc] Data Can Be A Geographic Phenomenon
--
https://doi.org/10.1080/24694452.2026.2640220 <-- shared paper
--
#GIS #mapping #spatial #DataScience #missing #data #spatial #AAG #autocorrelation #geographicallyweightedregression #GWR #imputation #missingdata #survey #surveynonresponse #incomplete #surveyquestions #ethnicity #income #spatialdata #alldataisspatial #UK #FinancialLives #geography #spatialanalysis #geostatistics #location #imputing #statistics #dataset #DataImputation #MissingData #DataCleaning #DataPreprocessing #DataWrangling #DataQuality #DataEngineering #FinancialData #FinancialAnalytics #FinincialModeling #FinDataScience

🌐Christof Schöch, University of Trier, details how the #DOAJ journal #dataset is used to teach #Python programming for the Machine Learning in a Digital Humanities Master's program @christof

#PythonProgramming #APCs #DataClassiication #DataCleaning #MachineLearning
🔗 https://blog.doaj.org/2026/03/30/teaching-python-programming-with-doajs-journal-dataset/

Free parking is rare, but QDeFuZZiner Lite is always free! 🅿️🆓 #DataManagement #FreeTools #DataAccuracy #FuzzyMatch #DataScience #DataAnalytics #EntityResolution #MasterData #MDM #DataCleaning #DataCleansing #RecordLinkage #ETL
https://matasoft.hr/qtrendcontrol/index.php/qdefuzziner-fuzzy-data-matching-software/various-articles/121-qdefuzziner-lite-free

#MachineLearning #DataScience #PythonProgramming #Sklearn #TensorFlow #AI #DeepLearning #DataPreprocessing #FeatureEngineering #MLJourney #LearnML #TechSkills #DataCleaning #MLModels

https://teguhteja.id/machine-learning-sklearn-and-tensorflow-course-path/

Clean missing data in the Titanic dataset using Python and Pandas! Learn effective data imputation and handling techniques. Perfect for data scientists and analysts. #Python #DataScience #Pandas #MissingData #TitanicDataset #DataCleaning #DataImputation

https://teguhteja.id/clean-missing-data/

Learn to handle missing data in Python using Pandas with the Titanic dataset! Discover effective data cleaning and imputation techniques. Perfect for data scientists and analysts. #Python #DataScience #Pandas #MissingData #DataCleaning #TitanicDataset

https://teguhteja.id/handle-missing-data-in-python/