PinnedSQL Brain Teasers: Can You Solve These Complex QueriesGiven a table Sales with columns Region, Country, Product, and Amount, write a query that returns the total amount of sales by region, country, and product, as well as the grand total for all sales. …Google7 min readGoogle7 min read
PinnedHeroku — Schedule Python with Mongo DBI create my own python scripts to scrape data from website and push into database.But i need to refresh the data on regular basis without spending any money on resources . I tried out multiple ways to trigger the job for data refresh .I …2 min read2 min read
1 day agoGuide to Containerizing ApplicationsContainerization has revolutionized the way we develop, deploy, and manage applications, providing a consistent environment across different stages of the software development life cycle. In this article, we will delve into the process of containerizing applications, breaking down the steps to help you seamlessly adopt this transformative technology. ### Step…Kubernetes2 min readKubernetes2 min read
1 day agoTo convert your existing EC2 instances into an Amazon EKS (Elastic Kubernetes Service) cluster, you can follow these general steps:**Evaluate Your Applications:** . Identify the applications running on your EC2 instances and determine which ones are suitable for containerization with Kubernetes. 2. **Containerize Applications:** . Modify or create Docker containers for your applications. Ensure that they are well-packaged, considering dependencies and configurations. 3. **Install and Configure kubectl:** . Install…Kubernetes2 min readKubernetes2 min read
3 days agoDomain centric architectureDomain-centric architecture is an approach that emphasizes structuring software systems based on specific business domains. In the finance domain, the architecture would be designed to address the unique challenges, requirements, and functionalities relevant to financial services. Let’s consider an example and a simplified diagram: **Example: Finance Domain – Online Banking System** **Components:**2 min read2 min read
6 days agoPower of DBSCAN: A Density-Based Clustering AlgorithmPower of DBSCAN: A Density-Based Clustering Algorithm Clustering, an essential task in machine learning, facilitates the organization of data into meaningful groups. …Machine Learning2 min readMachine Learning2 min read
Oct 30Data Cleaning in Machine Learning: A Step-By-Step Guide with Code ExamplesData Cleaning in Machine Learning: A Step-By-Step Guide with Code Examples Introduction Data is the lifeblood of machine learning. However, raw data often contains imperfections, inaccuracies, and inconsistencies that can significantly impact the performance of machine learning models. Data cleaning, also known as data preprocessing, is a crucial step to…Data Science4 min readData Science4 min read
Oct 30Exploring Python’s Special Functions: A Dive into Magic MethodsPython is renowned for its simplicity, readability, and versatility. One of its most distinctive features is the extensive use of special functions, often referred to as “magic methods.” These methods provide a way to customize how objects of user-defined classes behave in response to built-in operations. …Python2 min readPython2 min read
Aug 25Understanding Pearson and Cosine SimilarityWhen it comes to measuring relationships within data, two important metrics come into play: Pearson correlation and Cosine similarity. Each of these metrics has distinct properties and is suited for different scenarios. Let’s delve into these concepts with the help of an example. Consider two sets of data, represented as…Machine Learning2 min readMachine Learning2 min read
Jun 19Software on an additional volume in an EC2 instanceLaunch an EC2 instance: Start by launching a new EC2 instance or use an existing one. 2. Attach an additional volume: In the EC2 console, navigate to the “Volumes” section and create a new Amazon EBS volume. Choose the desired size, availability zone, and other configurations. Once the volume is…2 min read2 min read
