Published inTowards Data Science·PinnedMember-onlyFinding the Best Classification Threshold for Imbalanced Classifications with the Interactive Confusion Matrix and Line ChartsTake your analysis of binary classification problems to the next level using the binclass-tools amazing Python package — Data Scientists who are about to train classification models often find themselves analyzing the resulting confusion matrix to see if the model’s performance is satisfactory. Let’s take a closer look at what this is all about. Introducing the Confusion Matrix The term “confusion” refers to the fact that an observation can be correctly or…Binary Classification16 min readBinary Classification16 min read
Published inTowards Data Science·Mar 15Member-onlyRevolutionize Your Binary Classification Analysis with New Graphic Tools in This Release of binclass-toolsDiscover the power of Calibration Curves, Gain and Lift Plots, and more in the latest version of binclass-tools —your ultimate solution for binary classification problems! — The binclass-tools package reached major version 1.* a few days ago and celebrates 13K downloads from PyPI! The new version contains many new features, including: Calibration Plot Cumulative Gain Plot Cumulative Lift Plot Response PlotClassification9 min readClassification9 min read
Published inTowards Data Science·Jan 5Member-onlyExtracting Data from (Azure) SQL Server Huge Tables in RFC 4180-Compliant CSV FilesThe nightmare of extracting data containing strings with special characters from (Azure) SQL Server huge tables into CSV files — When a team of Data Scientists from outside your company is hired to implement Machine Learning models, you somehow have to share with them the data to be used for model training. If the aforementioned team cannot directly access the data persisted in a database, the first option is to…Sql Server21 min readSql Server21 min read
Published inTowards Data Science·Nov 16, 2022Member-onlyBetween R and Python, Which Language Would I Suggest to an Aspiring Data Analytics Expert?In recent years I’ve seen the evolution of the use of both of these languages in the world of Data Analytics. Here are my thoughts. — Until now I have always avoided entering the tussle of those interested in the R vs Python battle. But recently, my peer data geek Brian Julius asked my opinion on the Python vs R debate in his LinkedIn post here: Brian Julius on LinkedIn: #r #python #datascience #dataanalysis | 37 comments I've long been a conscientious objector in the R vs. Python wars, taking the view what's "best" depends on your…www.linkedin.comPython5 min readPython5 min read
Published inTowards Data Science·Sep 16, 2022Member-onlyROC and Precision-Recall Curves, Probabilities Distribution, and Density Plots in the binclass-tools Python PackageStandard plots for binary classifications are now available in the binclass-tools package — I recently announced the release of a Python package useful for the analysis of binary classifications. In particular, the need to develop this package arose from the difficulty of analyzing imbalanced binary classifications. …Binary Classification6 min readBinary Classification6 min read
Published inMicrosoft Azure·Mar 7, 2022Member-onlyFixing ADO.NET error trying to run Python Script in Power BIWhile trying to use a Python script in Power BI Desktop, I ran into a strange error that made me lose a whole day trying to solve it. I wanted to share with you the solution I found, thus avoiding wasting your time as well. How I came across this error I was recently trying to…Power Bi6 min readPower Bi6 min read
Published inTowards Data Science·Jan 11, 2022Member-onlyPrice Elasticity: Modeling in Azure ML Designer After the Exploration Data AnalysisFind out the benefits of EDA for the performance of your Machine Learning model — In my previous post about Price Elasticity I shown how important is to analyze your dataset using Exploration Data Analysis before creating a Machine Learning model in order to better understand your data strengths and weaknesses: Price Elasticity: Data Understanding and Data Exploration First Of All! Tools in R for a better data exploration will be shown in this post.towardsdatascience.comAzure Machine Learning10 min readAzure Machine Learning10 min read
Published inWandering in Advanced Analytics·Oct 21, 2021Member-onlyPresentation of Chapter 7, Logging Data From Power BI to External Sources, from my book “Extending Power BI with Python and R”Given the interest shown by the community about my book “Extending Power BI with Python and R”, I decided to share with them a slightly more accurate description of the contents of each chapter. In a previous blog post, I presented the content of Chapter 6, Anonymizing and Pseudonymizing your…Power Bi4 min readPower Bi4 min read
Published inWandering in Advanced Analytics·Oct 18, 2021Member-onlyPresentation of Chapter 6, Anonymizing and Pseudonymizing your Data in Power BI, from my book “Extending Power BI with Python and R”Given the interest shown by the community about my book “Extending Power BI with Python and R”, I decided to share with them a slightly more accurate description of the contents of each chapter. In a previous blog post, I presented the content of Chapter 5, Using Regular Expressions in…Power Bi4 min readPower Bi4 min read
Published inWandering in Advanced Analytics·Oct 13, 2021Member-onlyPresentation of Chapter 5, Using Regular Expressions in Power BI, from my book “Extending Power BI with Python and R”Given the interest shown by the community about my book “Extending Power BI with Python and R”, I decided to share with them a slightly more accurate description of the contents of each chapter. In a previous blog post, I presented the content of Chapter 4, Importing Unhandled Data Objects…Power Bi6 min readPower Bi6 min read
