Showing posts with the label models

Featured Post

SQL Query: 3 Methods for Calculating Cumulative SUM

SQL provides various constructs for calculating cumulative sums, offering flexibility and efficiency in data analysis. In this article, we explore three distinct SQL queries that facilitate the computation of cumulative sums. Each query leverages different SQL constructs to achieve the desired outcome, catering to diverse analytical needs and preferences. Using Window Functions (e.g., PostgreSQL, SQL Server, Oracle) SELECT id, value, SUM(value) OVER (ORDER BY id) AS cumulative_sum  FROM your_table; This query uses the SUM() window function with the OVER clause to calculate the cumulative sum of the value column ordered by the id column. Using Subqueries (e.g., MySQL, SQLite): SELECT, t1.value, SUM(t2.value) AS cumulative_sum FROM your_table t1 JOIN your_table t2 ON >= GROUP BY, t1.value ORDER BY; This query uses a self-join to calculate the cumulative sum. It joins the table with itself, matching rows where the id in the first table is greater than or

2 Top Python Libraries to Create ML model

To Create a Model of Machine Learning in Python, you need TWO libraries. One is 'NUMPY' and the other one is 'PANDAS'. 2 Top Libraries You Need To Build a model of Machine learning you need the right kind of data. So, use the data for your project should be refined. Else, it will not produce correct results. The prime steps are Data Analysis and Data Preprocessing. NUMPY - It has the capabilities of Calculations. PANDAS- It has the capabilities of Data processing. How Install Python Machine Learning Libraries  import  NumPy as np # linear algebra import pandas as PD # data processing, CSV file I/O (e.g. PD.read_csv) How to Check NumPy/Pandas installed After '.' you need to give double underscore on both sides of the version.  How Many Types of Data You Need You need two types of data. One is data to build a model and the other one is data you need to test the model. Raw data Evaluate-data How to Build a Model Flowchart I have given a f

Real thoughts on IBM power8 servers to use on analytics

IBM Servers International Business Machines Corp, in its latest attempt at reviving demand for its hardware products, is launching high-end system servers that it says are 50 times faster than its closest competitor at analysing data.  The POWER8 servers , the product of a $2.4 billion, three-year investment, are part of the company's decade-long shift to higher-value hardware technology.    IBM  said the machines are 50 times faster than the low-end x86-based servers it sold to Chinese PC maker  Lenovo  Group Ltd in January.  The technology services provider said on Wednesday it hopes the servers, designed for large-scale computing, will appeal to clients looking to manage new types of social and mobile computing and mass amounts of data. Last week, the company reported its lowest quarterly revenue in five years, weighed down by falling demand for its storage and server products. IBM dominates the higher-end server market with 57 percent market share, according to res