#datacleaning — Public Fediverse posts
Live and recent posts from across the Fediverse tagged #datacleaning, aggregated by home.social.
-
🐘 Αποκωδικοποιώντας τα #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
-
🐘 Αποκωδικοποιώντας τα #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
-
🐘 Αποκωδικοποιώντας τα #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
-
🐘 Αποκωδικοποιώντας τα #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
-
🐘 Αποκωδικοποιώντας τα #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
-
Data engineering = 80% nettoyage, 20% glamour. Exemple : 3 semaines pour corriger doublons. Solution : automatisation, documentation. #DataEngineering #Tech #Humeur #DataCleaning #Réalité ... https://www.linkedin.com/posts/gabriel-chandesris_dataengineering-tech-humeur-share-7455896944264081408-Ln7L
-
Data engineering = 80% nettoyage, 20% glamour. Exemple : 3 semaines pour corriger doublons. Solution : automatisation, documentation. #DataEngineering #Tech #Humeur #DataCleaning #Réalité ... https://www.linkedin.com/posts/gabriel-chandesris_dataengineering-tech-humeur-share-7455896944264081408-Ln7L
-
Data engineering = 80% nettoyage, 20% glamour. Exemple : 3 semaines pour corriger doublons. Solution : automatisation, documentation. #DataEngineering #Tech #Humeur #DataCleaning #Réalité ... https://www.linkedin.com/posts/gabriel-chandesris_dataengineering-tech-humeur-share-7455896944264081408-Ln7L
-
Data engineering = 80% nettoyage, 20% glamour. Exemple : 3 semaines pour corriger doublons. Solution : automatisation, documentation. #DataEngineering #Tech #Humeur #DataCleaning #Réalité ... https://www.linkedin.com/posts/gabriel-chandesris_dataengineering-tech-humeur-share-7455896944264081408-Ln7L
-
Data engineering = 80% nettoyage, 20% glamour. Exemple : 3 semaines pour corriger doublons. Solution : automatisation, documentation. #DataEngineering #Tech #Humeur #DataCleaning #Réalité ... https://www.linkedin.com/posts/gabriel-chandesris_dataengineering-tech-humeur-share-7455896944264081408-Ln7L
-
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/ -
🌐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/ -
🌐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/ -
🌐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/ -
🌐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/ -
Customer Data Enrichment vs Data Cleaning: Understanding the Real Differences
Explore how customer data enrichment differs from regular data cleaning. Learn how enrichment adds valuable insights like demographics and behavior, while data cleansing services remove errors to improve data quality and smarter decision-making.
Know More: https://froodl.com/what-makes-customer-data-enrichment-different-from-regular-data-cleaning
#CustomerData #DataEnrichment #DataCleaning #DataQuality #MarketingAnalytics #CRMData
-
Just wrapped up cleaning TheLook's eCommerce data — so satisfying when your dataset plays nice! 🧹✅
Only 2 missing product names in 29k rows & no dupes. Solid foundation for KPIs!
But… how do you handle messy data? Any go-to SQL tricks for spotting hidden issues?👇 Let’s swap stories — and if you want the full deep dive, check out the blog:
https://manueltechlabs.com/posts/data-cleaning-and-preparation-setting-the-fundation-for-reliable-insights/ -
Just wrapped up cleaning TheLook's eCommerce data — so satisfying when your dataset plays nice! 🧹✅
Only 2 missing product names in 29k rows & no dupes. Solid foundation for KPIs!
But… how do you handle messy data? Any go-to SQL tricks for spotting hidden issues?👇 Let’s swap stories — and if you want the full deep dive, check out the blog:
https://manueltechlabs.com/posts/data-cleaning-and-preparation-setting-the-fundation-for-reliable-insights/ -
Just wrapped up cleaning TheLook's eCommerce data — so satisfying when your dataset plays nice! 🧹✅
Only 2 missing product names in 29k rows & no dupes. Solid foundation for KPIs!
But… how do you handle messy data? Any go-to SQL tricks for spotting hidden issues?👇 Let’s swap stories — and if you want the full deep dive, check out the blog:
https://manueltechlabs.com/posts/data-cleaning-and-preparation-setting-the-fundation-for-reliable-insights/ -
Just wrapped up cleaning TheLook's eCommerce data — so satisfying when your dataset plays nice! 🧹✅
Only 2 missing product names in 29k rows & no dupes. Solid foundation for KPIs!
But… how do you handle messy data? Any go-to SQL tricks for spotting hidden issues?👇 Let’s swap stories — and if you want the full deep dive, check out the blog:
https://manueltechlabs.com/posts/data-cleaning-and-preparation-setting-the-fundation-for-reliable-insights/ -
Just wrapped up cleaning TheLook's eCommerce data — so satisfying when your dataset plays nice! 🧹✅
Only 2 missing product names in 29k rows & no dupes. Solid foundation for KPIs!
But… how do you handle messy data? Any go-to SQL tricks for spotting hidden issues?👇 Let’s swap stories — and if you want the full deep dive, check out the blog:
https://manueltechlabs.com/posts/data-cleaning-and-preparation-setting-the-fundation-for-reliable-insights/ -
🚀 giới thiệu công cụ repairmycsv giúp sửa tệp CSV lỗi nhanh, tự động. Phát hiện dấu phân cách, sửa lỗi cột, xử lý dấu ngoặc, loại bỏ khoảng trắng, ký tự ẩn. Dành cho sinh viên, data analysts, lập trình viên và doanh nghiệp. #CSVTool #TiệnIchCSV #DataCleaning #XửLýDữLiệu #WebTool
https://www.reddit.com/r/SaaS/comments/1pj3wza/built_a_simple_tool_for_repairing_messy_csv_files/
-
What is lable and Text box in Tool box in VBA Excel - S1 EP19 P9 #ExcelTips #ExcelTutorial #ExcelVBA #VBATutorial #ExcelFilter #ClearFilters #DataFiltering #ExcelAutomation #ExcelSkills #TechTutorials #HowToExcel #ExcelSeries #ExcelForBeginners #excelcourse #exceltips #excelcourseuae #powerqueryeditor #excelformula #exceltutorial #datacleaning
-
What is lable and Text box in Tool box in VBA Excel - S1 EP19 P9 #ExcelTips #ExcelTutorial #ExcelVBA #VBATutorial #ExcelFilter #ClearFilters #DataFiltering #ExcelAutomation #ExcelSkills #TechTutorials #HowToExcel #ExcelSeries #ExcelForBeginners #excelcourse #exceltips #excelcourseuae #powerqueryeditor #excelformula #exceltutorial #datacleaning
-
What is lable and Text box in Tool box in VBA Excel - S1 EP19 P9 #ExcelTips #ExcelTutorial #ExcelVBA #VBATutorial #ExcelFilter #ClearFilters #DataFiltering #ExcelAutomation #ExcelSkills #TechTutorials #HowToExcel #ExcelSeries #ExcelForBeginners #excelcourse #exceltips #excelcourseuae #powerqueryeditor #excelformula #exceltutorial #datacleaning
-
How insert simple user Form in excel using VBA Excel- S1 EP19 P8 #ExcelTips #ExcelTutorial #ExcelVBA #VBATutorial #ExcelFilter #ClearFilters #DataFiltering #ExcelAutomation #ExcelSkills #TechTutorials #HowToExcel #ExcelSeries #ExcelForBeginners #excelcourse #exceltips #excelcourseuae #powerqueryeditor #excelformula #exceltutorial #datacleaning
-
How insert simple user Form in excel using VBA Excel- S1 EP19 P8 #ExcelTips #ExcelTutorial #ExcelVBA #VBATutorial #ExcelFilter #ClearFilters #DataFiltering #ExcelAutomation #ExcelSkills #TechTutorials #HowToExcel #ExcelSeries #ExcelForBeginners #excelcourse #exceltips #excelcourseuae #powerqueryeditor #excelformula #exceltutorial #datacleaning
-
How insert simple user Form in excel using VBA Excel- S1 EP19 P8 #ExcelTips #ExcelTutorial #ExcelVBA #VBATutorial #ExcelFilter #ClearFilters #DataFiltering #ExcelAutomation #ExcelSkills #TechTutorials #HowToExcel #ExcelSeries #ExcelForBeginners #excelcourse #exceltips #excelcourseuae #powerqueryeditor #excelformula #exceltutorial #datacleaning
-
Write a Universal code to delete empty rows in VBA Excel - S1 EP19 P7 #ExcelTips #ExcelTutorial #ExcelVBA #VBATutorial #ExcelFilter #ClearFilters #DataFiltering #ExcelAutomation #ExcelSkills #TechTutorials #HowToExcel #ExcelSeries #ExcelForBeginners #excelcourse #exceltips #excelcourseuae #powerqueryeditor #excelformula #exceltutorial #datacleaning
-
Write a Universal code to delete empty rows in VBA Excel - S1 EP19 P7 #ExcelTips #ExcelTutorial #ExcelVBA #VBATutorial #ExcelFilter #ClearFilters #DataFiltering #ExcelAutomation #ExcelSkills #TechTutorials #HowToExcel #ExcelSeries #ExcelForBeginners #excelcourse #exceltips #excelcourseuae #powerqueryeditor #excelformula #exceltutorial #datacleaning
-
Write a Universal code to delete empty rows in VBA Excel - S1 EP19 P7 #ExcelTips #ExcelTutorial #ExcelVBA #VBATutorial #ExcelFilter #ClearFilters #DataFiltering #ExcelAutomation #ExcelSkills #TechTutorials #HowToExcel #ExcelSeries #ExcelForBeginners #excelcourse #exceltips #excelcourseuae #powerqueryeditor #excelformula #exceltutorial #datacleaning
-
Write a Universal code to Fix Cases in Data in VBA Excel - S1 EP19 P6 #ExcelTips #ExcelTutorial #ExcelVBA #VBATutorial #ExcelFilter #ClearFilters #DataFiltering #ExcelAutomation #ExcelSkills #TechTutorials #HowToExcel #ExcelSeries #ExcelForBeginners #excelcourse #exceltips #excelcourseuae #powerqueryeditor #excelformula #exceltutorial #datacleaning
-
Write a Universal code to Fix Cases in Data in VBA Excel - S1 EP19 P6 #ExcelTips #ExcelTutorial #ExcelVBA #VBATutorial #ExcelFilter #ClearFilters #DataFiltering #ExcelAutomation #ExcelSkills #TechTutorials #HowToExcel #ExcelSeries #ExcelForBeginners #excelcourse #exceltips #excelcourseuae #powerqueryeditor #excelformula #exceltutorial #datacleaning
-
Write a Universal code to Fix Cases in Data in VBA Excel - S1 EP19 P6 #ExcelTips #ExcelTutorial #ExcelVBA #VBATutorial #ExcelFilter #ClearFilters #DataFiltering #ExcelAutomation #ExcelSkills #TechTutorials #HowToExcel #ExcelSeries #ExcelForBeginners #excelcourse #exceltips #excelcourseuae #powerqueryeditor #excelformula #exceltutorial #datacleaning
-
Remove double spaces within text with code in VBA Excel - S1 EP19 P5 #ExcelTips #ExcelTutorial #ExcelVBA #VBATutorial #ExcelFilter #ClearFilters #DataFiltering #ExcelAutomation #ExcelSkills #TechTutorials #HowToExcel #ExcelSeries #ExcelForBeginners #excelcourse #exceltips #excelcourseuae #powerqueryeditor #excelformula #exceltutorial #datacleaning
-
Remove double spaces within text with code in VBA Excel - S1 EP19 P5 #ExcelTips #ExcelTutorial #ExcelVBA #VBATutorial #ExcelFilter #ClearFilters #DataFiltering #ExcelAutomation #ExcelSkills #TechTutorials #HowToExcel #ExcelSeries #ExcelForBeginners #excelcourse #exceltips #excelcourseuae #powerqueryeditor #excelformula #exceltutorial #datacleaning
-
Remove double spaces within text with code in VBA Excel - S1 EP19 P5 #ExcelTips #ExcelTutorial #ExcelVBA #VBATutorial #ExcelFilter #ClearFilters #DataFiltering #ExcelAutomation #ExcelSkills #TechTutorials #HowToExcel #ExcelSeries #ExcelForBeginners #excelcourse #exceltips #excelcourseuae #powerqueryeditor #excelformula #exceltutorial #datacleaning
-
How to add buttons to run Macros in VBA Excel - S1 EP19 P3 #ExcelTips #ExcelTutorial #ExcelVBA #VBATutorial #ExcelFilter #ClearFilters #DataFiltering #ExcelAutomation #ExcelSkills #TechTutorials #HowToExcel #ExcelSeries #ExcelForBeginners #excelcourse #exceltips #excelcourseuae #powerqueryeditor #excelformula #exceltutorial #datacleaning
-
How to add buttons to run Macros in VBA Excel - S1 EP19 P3 #ExcelTips #ExcelTutorial #ExcelVBA #VBATutorial #ExcelFilter #ClearFilters #DataFiltering #ExcelAutomation #ExcelSkills #TechTutorials #HowToExcel #ExcelSeries #ExcelForBeginners #excelcourse #exceltips #excelcourseuae #powerqueryeditor #excelformula #exceltutorial #datacleaning
-
How to add buttons to run Macros in VBA Excel - S1 EP19 P3 #ExcelTips #ExcelTutorial #ExcelVBA #VBATutorial #ExcelFilter #ClearFilters #DataFiltering #ExcelAutomation #ExcelSkills #TechTutorials #HowToExcel #ExcelSeries #ExcelForBeginners #excelcourse #exceltips #excelcourseuae #powerqueryeditor #excelformula #exceltutorial #datacleaning
-
How to Filter and Clear Filters in VBA Excel - S1 EP19 P2 #ExcelTips #ExcelTutorial #ExcelVBA #VBATutorial #ExcelFilter #ClearFilters #DataFiltering #ExcelAutomation #ExcelSkills #TechTutorials #HowToExcel #ExcelSeries #ExcelForBeginners #excelcourse #exceltips #excelcourseuae #powerqueryeditor #excelformula #exceltutorial #datacleaning
-
How to Filter and Clear Filters in VBA Excel - S1 EP19 P2 #ExcelTips #ExcelTutorial #ExcelVBA #VBATutorial #ExcelFilter #ClearFilters #DataFiltering #ExcelAutomation #ExcelSkills #TechTutorials #HowToExcel #ExcelSeries #ExcelForBeginners #excelcourse #exceltips #excelcourseuae #powerqueryeditor #excelformula #exceltutorial #datacleaning
-
How to Filter and Clear Filters in VBA Excel - S1 EP19 P2 #ExcelTips #ExcelTutorial #ExcelVBA #VBATutorial #ExcelFilter #ClearFilters #DataFiltering #ExcelAutomation #ExcelSkills #TechTutorials #HowToExcel #ExcelSeries #ExcelForBeginners #excelcourse #exceltips #excelcourseuae #powerqueryeditor #excelformula #exceltutorial #datacleaning
-
How to sort data with code in VBA - S1 EP19 P1 #excelcourse #exceltips #excelcourseuae #powerqueryeditor #excelformula #exceltutorial #datacleaning #exceltip #datamagic #productivity #exceltutoriales #dataextractor #powerbi #excelshortcuts #ConditionalColumn #excelshortcutss #QuickFill #DateSeries #microsoftexcel #excel
-
How to sort data with code in VBA - S1 EP19 P1 #excelcourse #exceltips #excelcourseuae #powerqueryeditor #excelformula #exceltutorial #datacleaning #exceltip #datamagic #productivity #exceltutoriales #dataextractor #powerbi #excelshortcuts #ConditionalColumn #excelshortcutss #QuickFill #DateSeries #microsoftexcel #excel