Useful tips for everyday
How big is the InnoDB buffer pool in MariaDB? Description: If innodb_buffer_pool_size is set to more than 1GB, innodb_buffer_pool_instances divides the InnoDB buffer pool into…
Can SQL functions have optional parameters? Functions do not accept optional parameters. Even if a parameter has a default values, you have to specify something…
What is the difference between inequality and equality? As nouns the difference between inequality and equality is that inequality is an unfair, not equal, state…
Which Python library would you prefer to use for data wrangling? The best library in Python for data munging is Pandas. What is the most…
How are predictive models used in your programming? In R programming, predictive models are extremely useful for forecasting future outcomes and estimating metrics that are…
Can we use linear regression in non linearly separable data? No, it is not possible to imagine a linear hyperplane (a line in 2D) that…
What is a three variable equation? If a, b, c and r are real numbers (and if a, b, and c are not all equal…
What are the applications of machine learning in civil engineering? Complex civil engineering problems such as drought forecasting, river flow forecasting, modeling evaporation, estimation of…
Why SVM is good for classification? SVM or Support Vector Machine is a linear model for classification and regression problems. It can solve linear and…
When should I use MinMaxScaler? MinMaxScaler may be used when the upper and lower boundaries are well known from domain knowledge (e.g. pixel intensities that…