esProc Desktopesproc-desktop.hashnode.dev·18 hours ago#120 — Group by SegmentProblem description & analysis: Here below is a data table: Task: We want to count the number of people in each of the following score segments respectively: below 50, 50–60, 60–70, 70–80, 80–90, and above 90. Solution: Use SPL XLL and enter the fol...10 likesexcel
Bhoomika Lohanainsightsalgorithms.hashnode.dev·Dec 22, 2024Fraud Detection using Machine LearningThe banking industry processes billions of transactions daily, making it a major target for fraudulent activities. Traditional fraud detection methods—rule-based systems, manual reviews by fraud analysts, or static thresholds with fixed limits—often ...1 likeData Science
esProc Desktopesproc-desktop.hashnode.dev·Dec 20, 2024#119 — Group by the ExpressionProblem description & analysis: Here below is a data table: Task: We want to group and aggregate by the first two digits of ID, and calculate the total sales of each group. Solution: Use SPL XLL and enter the following code: =spl("=E(?1).groups(left...10 likesexcel
BladePipebladepipe.hashnode.dev·Dec 19, 2024How to Prevent Duplication in Data Aggregation with BladePipeData aggregation is to combine data from multiple sources into a single body, and present the data in a summarized format. In the data movement process, there is great possibility that tables from different sources have the same table name or primary...1 likeData Science
Nasaka Watitwaeconomics-meets-data-analytics.hashnode.dev·Dec 18, 2024Cost-Benefit Analysis of Battery Storage for Sustainable Energy ManagementIn this project, I analyse the potential savings from installing a battery to store excess solar electricity and compare it with purchasing electricity from the grid. The model, created in R, simulates the impact of using a battery to store and disch...financial forecasting
vinitha burgutipsfordataanalysis.hashnode.dev·Dec 16, 20245 Tips for Effective Data Analysis Using PythonData analysis helps you make sense of information and find insights. Python is a great tool for this because it has powerful libraries that make the process easier. Here are 5 simple tips to improve your data analysis skills: 1. Get to Know Your Data...tips for data analysis
Rahul Kumardata-science-notes.hashnode.dev·Dec 16, 2024Iterative Imputer V/S KNN Imputer1. Iterative Imputer How it works: Imputes missing values by modeling each feature with missing values as a function of the other features. Uses regression (e.g., linear, decision trees) to predict missing values iteratively. Repeats the process ...tabular data
esProc Desktopesproc-desktop.hashnode.dev·Dec 16, 2024#118 — Group by the Combination of Multiple ColumnsProblem description & analysis: Here below is a data table: Task: We want to group the data by Year and Quarter, and count the total sales of each quarter. Solution: Use SPL XLL and enter the following code: =spl("=E(?1).groups(Year,Quarter;sum(Sale...10 likesexcel
Rahul Kumardata-science-notes.hashnode.dev·Dec 15, 2024Performance Metrics For Regression Task1. Mean Squared Error (MSE) Explanation Mean Squared Error (MSE) measures the average squared difference between estimated and actual values. It gives higher weight to larger errors due to squaring. Mathematical Formula MSE = (1/n) * ∑[(y_i - ŷ_i)^2]...Data Science
Niels Humbeckbuilding-data-products.com·Dec 13, 2024Streamlining the Data Product Development with DataOpsThe development of data products is an intricate process, blending the complexities of data and code. Unlike traditional software development, the data dimension addiing additional unique challenges. Data must be available, understood, and accurate—k...Building Data Products with DataOps Methodologydataops
