<?xml version="1.0" encoding="UTF-8"?><rss xmlns:dc="http://purl.org/dc/elements/1.1/" xmlns:content="http://purl.org/rss/1.0/modules/content/" xmlns:atom="http://www.w3.org/2005/Atom" version="2.0" xmlns:cc="http://cyber.law.harvard.edu/rss/creativeCommonsRssModule.html">
    <channel>
        <title><![CDATA[Stories by Darshana Singh on Medium]]></title>
        <description><![CDATA[Stories by Darshana Singh on Medium]]></description>
        <link>https://medium.com/@darshanasingh?source=rss-312d19560ceb------2</link>
        <image>
            <url>https://cdn-images-1.medium.com/fit/c/150/150/0*8Gud7zfpTKgR6vu0</url>
            <title>Stories by Darshana Singh on Medium</title>
            <link>https://medium.com/@darshanasingh?source=rss-312d19560ceb------2</link>
        </image>
        <generator>Medium</generator>
        <lastBuildDate>Tue, 17 Nov 2026 15:07:49 GMT</lastBuildDate>
        <atom:link href="https://medium.com/@darshanasingh/feed" rel="self" type="application/rss+xml"/>
        <webMaster><![CDATA[yourfriends@medium.com]]></webMaster>
        <atom:link href="http://medium.superfeedr.com/" rel="hub"/>
        <item>
            <title><![CDATA[Multiple Linear Regression — A Step forward to Predictive Analysis]]></title>
            <link>https://medium.com/swlh/multiple-linear-regression-a-step-forward-to-predictive-analysis-9ee8b9ea2330?source=rss-312d19560ceb------2</link>
            <guid isPermaLink="false">https://medium.com/p/9ee8b9ea2330</guid>
            <category><![CDATA[data-modeling]]></category>
            <category><![CDATA[multiple-linearregression]]></category>
            <category><![CDATA[data-science]]></category>
            <category><![CDATA[data-analysis]]></category>
            <category><![CDATA[predictive-analytics]]></category>
            <dc:creator><![CDATA[Darshana Singh]]></dc:creator>
            <pubDate>Fri, 24 Apr 2020 12:30:17 GMT</pubDate>
            <atom:updated>2020-05-11T16:27:05.383Z</atom:updated>
            <content:encoded><![CDATA[<h3>Multiple Linear Regression — A Step forward to Predictive Analysis</h3><blockquote><em>Multiple Linear Regression, an extension of Simple Linear Regression, illustrates the correlation between the independent and dependent variables and helps us to understand how much will the dependent variable change when we change the independent variables.</em></blockquote><figure><img alt="" src="https://cdn-images-1.medium.com/max/1024/1*u8DQbUYuMbMes9ZqLC55mA.jpeg" /><figcaption>image source: LinkedIn</figcaption></figure><p>Learning is beautiful — it enriches your knowledge and empowers your soul. The willingness to learn gives you the courage to carve your own path. The best part is, the habit of learning is not just limited to a subject or a genre rather it becomes a part of your lifestyle. It can be anything from making your own bed to your breakfast or to learn a new language. And for a Data Science enthusiast, what can be more amusing than deep diving into the ocean of algorithms.</p><p>So, keeping the legacy of learning alive, we will today take a tour to Multiple Linear Regression.</p><p>To understand we will pick a sample example from Codebasics. Here, we will try to predict the price of the house based on various factors.</p><p>Now, we have a <a href="https://docs.google.com/spreadsheets/d/1MN2kBR9xI-K0jv469vRYM_ZqkUv5ROCWCBylEP0-h1U/edit#gid=720260406"><em>CSV file</em></a> that has columns Area, Bedroom, Age (age of the house), Price.</p><p>From the previous, we are in a better position to quickly differentiate between independent &amp; dependent variables.</p><p>So, in this case, Area, Bedroom &amp; Age will be the independent variable, and the Price of the house will be the dependent variable. Because the price of the house depends upon the independent factors.</p><p>Here, we will quickly import the libraries and CSV files.</p><figure><img alt="" src="https://cdn-images-1.medium.com/max/1024/1*0syG4UshBo-YV59vObFerg.png" /></figure><p>Now, we can see a missing value(NaN) value in our dataset. We will handle this using one of the fillna methods. As we already know about these methods, for this dataset we will use the median value to fill the missing one.</p><p>We have used a math function “floor” to take the lower round off the value of the median.</p><figure><img alt="" src="https://cdn-images-1.medium.com/max/1024/1*9Kc-WbyuKAq8d4mfFLEUuw.png" /></figure><p>Once we get the value, let’s fill it in the dataset, and just like our previous exercise, we will calculate the coefficient &amp; intercept respectively.</p><p>The equation of Multiple Linear regression or Multivariate Regression is:<br><strong>Y(Price) = M1X1 + M2X2 + M3X3 + b<br></strong>Where,<br>M1, M2, M3 = Coefficients<br>X1, X2, X3 = Independent Variables<br>b = Intercept</p><figure><img alt="" src="https://cdn-images-1.medium.com/max/1024/1*P_EOmYR5SXOXuSfMOsLbsA.png" /></figure><p>Now, our algorithm is trained and ready for prediction.</p><p>In the above prediction, you will notice how our third factor i.e. age of the house is impacting the price. In our trained dataset for the same values i.e. Area &amp; Bedroom, the price is higher. In our test data, the house is older, hence the price is lower as compared to the previous one.</p><p>Similarly, you can add a CSV file with multiple variables and predict the prices. As a Data Analyst/Scientist you are also supposed to find our meaningful insight from your test &amp; trained dataset similar to the above example.</p><p>I hope this article will help you to get a much clearer picture of Multiple Linear Regression.</p><p>As a learner, it’s very critical for us to understand the <em>fundamentals</em> of whatever we are seeking knowledge in. The main motive of these articles is to help you to strengthen the basics of statistics &amp; data analysis. These small examples may appear to differ from most of the other code laden heavy examples, but trust me every small step counts when you dream to achieve big.</p><p>So, my suggestion would be to pick a dataset and try your hands on it. We will discuss another algorithm in the next post. Till then, yes, of course, EAT, SLEEP &amp; PRACTICE!!</p><p><em>P.S. If you have any doubts, feel free to contact, I am just a comment away :)</em></p><img src="https://medium.com/_/stat?event=post.clientViewed&referrerSource=full_rss&postId=9ee8b9ea2330" width="1" height="1" alt=""><hr><p><a href="https://medium.com/swlh/multiple-linear-regression-a-step-forward-to-predictive-analysis-9ee8b9ea2330">Multiple Linear Regression — A Step forward to Predictive Analysis</a> was originally published in <a href="https://medium.com/swlh">The Startup</a> on Medium, where people are continuing the conversation by highlighting and responding to this story.</p>]]></content:encoded>
        </item>
        <item>
            <title><![CDATA[Linear Regression – A Step Towards Predictive Analytics]]></title>
            <link>https://medium.com/swlh/linear-regression-a-step-towards-predictive-analytics-16dcecf3c0db?source=rss-312d19560ceb------2</link>
            <guid isPermaLink="false">https://medium.com/p/16dcecf3c0db</guid>
            <category><![CDATA[data-modeling]]></category>
            <category><![CDATA[data-science]]></category>
            <category><![CDATA[predictive-analytics]]></category>
            <category><![CDATA[linear-regression]]></category>
            <category><![CDATA[exploratory-data-analysis]]></category>
            <dc:creator><![CDATA[Darshana Singh]]></dc:creator>
            <pubDate>Mon, 20 Apr 2020 07:45:53 GMT</pubDate>
            <atom:updated>2020-04-24T12:42:09.998Z</atom:updated>
            <content:encoded><![CDATA[<blockquote><em>Linear Regression, a poster child of predictive modeling, helps a statistician to unwind the black box of machine learning while solidifying the understanding of the applied statistics.</em></blockquote><figure><img alt="" src="https://cdn-images-1.medium.com/max/1024/1*awKLaCoRRcfrL1tQ5SeW_w.jpeg" /><figcaption>image source: LinkedIn</figcaption></figure><p>If you are reading this article, I hope you are familiar with this big universe of Data Science. Just like our universe contains galaxies, stars, and planets as its integral part, this aesthetic universe of Data Science has different algorithms. Today onwards, we will discuss one Data Science algorithm in each post.</p><p>As a data science aspirant, it’s very important to understand a few algorithms. This post is entirely dedicated to one of the most popular &amp; well-understood algorithms, Linear Regression. Now before jumping on anything, it is very crucial to understand <strong>3 W’s</strong> What? Why? &amp; How?</p><p>These three questions will give you an overall picture of the algorithm and help you develop a sense of understanding how it works &amp; how you can best use it for your problem statement.</p><p><strong>What is a Linear Regression?</strong></p><p>Linear regression falls under the category of supervised learning. The overall idea of this regression is to examine or predict the relationship between two variables or factors. The variable which is being predicted is called a<strong> </strong><em>dependent variable</em>. The factors that are used to predict the value of the dependent variable are called the <em>independent variables</em>.</p><p>There are two types of Linear Regression:</p><p>1. Simple Linear Regression (one dependent variable and one independent variable)</p><p>2. Multiple Linear Regression(One dependent variable and multiple independent variables)</p><p><strong>Why should we use it?</strong></p><p>If our problem statement demands <em>predictive analysis</em>, we should use linear regression. After a quick walkthrough to the dataset will help us to decide whether it fits for Simple Linear Regression or Multiple Linear Regression.</p><p><strong>How should we use it?</strong></p><p>Let’s try to understand Simple Linear Regression first, there are ample data sets available publicly you can go through them. I have found this brilliant example on a website where we will take a simple case of prediction of prices of houses based on the area. So we have two columns i.e. Area &amp; Price.</p><p>Now, this CSV file will act as our training data. Do not forget to upload your CSV file in your Jupyter notebook.</p><p>Since we are now implementing ML Algorithms. We are supposed to be well versed in the libraries &amp; Exploratory data analysis of python.</p><p>In case you have missed out on these, you can go through my <a href="https://blog.usejournal.com/sneak-peek-into-data-science-libraries-57b513d4f9e7">previous article </a>to get a fair sense.</p><figure><img alt="" src="https://cdn-images-1.medium.com/max/1024/1*6Q_5Ht8NRsEMdwHU5kd_jw.png" /></figure><p>After reading the file, we will analyze the data set. There are multiple ways to analyze the data, this again depends on your data set and how much of data cleaning does it require.</p><p>Here, we have a very small dataset hence we will do some basic Exploratory Data Analysis.</p><p>This step will help us understand how suitable is the data distribution for Linear Regression.</p><figure><img alt="" src="https://cdn-images-1.medium.com/max/1024/1*8sv4RNaqbqIE1tCwR-3gaQ.png" /></figure><p>After getting this heads-up we will now <a href="https://docs.google.com/spreadsheets/d/1YHAq2C_RhWBQkj16nEr6cJhBKR1JDz7rG-vQ3xz556k/edit?usp=sharing"><strong><em>train the dataset</em></strong></a>. Once your model is trained you are good to go for the prediction. A good statistician is the one who can visualize conceptual knowledge with a real-time problem. Following the lead, we will try to visualize what a linear equation looks like.</p><p>As we know the every linear regression fits in the equation Y=mx+b<br>Where,<br>m = intercept<br>b = coefficient constant</p><p>Now, let’s see how we can get this in our programming environment</p><figure><img alt="" src="https://cdn-images-1.medium.com/max/1024/1*gunG4sayVNRoUGvXdWftLQ.png" /></figure><figure><img alt="" src="https://cdn-images-1.medium.com/max/1024/1*lrSPk-WZkUgef6uoJXE59A.png" /></figure><p>Our model is ready now. Now we can use this model to <a href="https://docs.google.com/spreadsheets/d/1RtBNbGOpAR86wBRdUD39glIXGn4vq_t4bnK2oDp5ksY/edit?usp=sharing"><strong><em>predict huge datasets</em></strong></a>. Let’s give a shot.</p><figure><img alt="" src="https://cdn-images-1.medium.com/max/1024/1*1rlcC8F9zbTV4fSCVf_f8g.png" /></figure><p>There are various ways to test &amp; train the data. In Some cases, we divide the existing dataset in different proportions as training &amp; testing data, whereas in the above scenario our training &amp; test data are in different files.</p><p>Python also gives us the leverage to export the data into a CSV or excel file.</p><figure><img alt="" src="https://cdn-images-1.medium.com/max/1024/1*wSZlMGgC62slnDWxW-62_Q.png" /></figure><p>So, this was a run-through of Simple Linear Regression. This will help you understand the concept as well as to brush up the basics. I hope this will motivate you to explore more of this beautiful world of statistics. We will unfold the other chapter of regression in the next article. Till then stay tuned &amp; <strong><em>EAT, SLEEP &amp; PRACTICE!</em></strong></p><p><em>P.S. Please feel free to contact in case of any queries. I will be more than happy to help :)</em></p><img src="https://medium.com/_/stat?event=post.clientViewed&referrerSource=full_rss&postId=16dcecf3c0db" width="1" height="1" alt=""><hr><p><a href="https://medium.com/swlh/linear-regression-a-step-towards-predictive-analytics-16dcecf3c0db">Linear Regression – A Step Towards Predictive Analytics</a> was originally published in <a href="https://medium.com/swlh">The Startup</a> on Medium, where people are continuing the conversation by highlighting and responding to this story.</p>]]></content:encoded>
        </item>
        <item>
            <title><![CDATA[Sneak Peek into Data Science Libraries]]></title>
            <link>https://medium.com/@darshanasingh/sneak-peek-into-data-science-libraries-57b513d4f9e7?source=rss-312d19560ceb------2</link>
            <guid isPermaLink="false">https://medium.com/p/57b513d4f9e7</guid>
            <category><![CDATA[pandas]]></category>
            <category><![CDATA[data-science]]></category>
            <category><![CDATA[numpy]]></category>
            <category><![CDATA[data-manipulation]]></category>
            <category><![CDATA[matplotlib]]></category>
            <dc:creator><![CDATA[Darshana Singh]]></dc:creator>
            <pubDate>Wed, 31 Jul 2019 18:25:08 GMT</pubDate>
            <atom:updated>2019-08-07T02:33:10.228Z</atom:updated>
            <content:encoded><![CDATA[<blockquote><strong>The acceptance of python language in Data Science has been phenomenal and the Pandas library has emerged into a powerhouse of data manipulation tasks in python since it was developed.</strong></blockquote><figure><img alt="" src="https://cdn-images-1.medium.com/max/1024/1*9xHXuaMOR9fwPMbqmg60hQ.png" /></figure><p>In the <a href="https://medium.com/@darshanasingh/how-to-conquer-the-territory-of-data-science-9c077ebba41a">previous article</a>, we dove into the details and prerequisite of Data preparation and analysis. In this article, we will go over the essential bits of information about Data manipulation, where we will explore one of the most popular Python library, Pandas. Now, the question may arise that if we have SQL then why Pandas. This is because Pandas allows us to analyze and interpret data to the wider spectrum i.e. it works well with data from different varieties such as excel sheet, csv file, sql file or even a webpage.</p><p>Here, we will build on this knowledge by looking in detail at the data structures provided by the Pandas library. But before jumping into the details we will learn to set up an editor for our learning.</p><p><strong>Installing Pandas</strong></p><p>For installing Pandas, we need to download <a href="https://www.anaconda.com/">Anaconda</a> and follow the instructions. At the final step, choose Jupyter notebook. Jupyter notebook will be your reliable companion in this roller coaster ride of Data Scientist. Jupyter notebook has all the necessary libraries in it. All you need to do is import them. If you get stuck at any step, don’t worry as Google &amp; Youtube will help you get through it.</p><p>Once the setup is done, you can easily import Pandas using the command:</p><pre><strong><em>import pandas as pd </em></strong><em>( this command will be same for other libraries)</em></pre><p><strong>Data Structures</strong></p><p>In general, Pandas supports two data structures:</p><p>· Series — For One-Dimensional array</p><p>· DataFrames — For Two-Dimensional array</p><p>Most of our data will be available in tabular form; thus, we will be using Dataframes to learn the basic commands.</p><p><strong>Different ways of creating Data frames :</strong></p><pre>Import pandas as pd</pre><pre><em>#From CSV</em></pre><pre>df = pd.read_csv(“file location”)</pre><pre>df #to print</pre><pre><em>#From excel</em></pre><pre>df = pd.read_excel(“file location”)</pre><pre>df</pre><pre><em>#create your own DataFrame</em></pre><pre>Name_of_the_desired_dataframe = {‘val 1’, ‘val 2’, ‘val 3’}</pre><pre>df = pd.dataframe(name of the dataframe)</pre><pre>df</pre><p><strong>NOTE</strong>: We can create our own dictionary, list, array in the dataframe.</p><p><strong>Examine dimensions of the data frame :</strong></p><pre><em>#represents no. of rows &amp; Columns</em></pre><pre>df.shape</pre><pre><em>#print first n columns</em></pre><pre>df.head (n)</pre><pre><em>#print specific columns</em></pre><pre>df[‘column name’]</pre><pre><em>#print last n columns</em></pre><pre>df.tail(n)</pre><p><strong>Examine the basic Statistics of Data:</strong></p><pre><em># calculate mean, min, max, std deviation</em></pre><pre>df[‘column name’].mean/min/max/std() OR df.describe()</pre><pre><em>#For Slicing</em></pre><pre>df [n1 : n3], where n1 &amp; n3 are row no.s. This command includes row no. n1 but excludes n3.</pre><pre><strong>Note</strong>: del df.[‘column name’] never forget to release the memory.</pre><p>Above discussed commands will enable you (hopefully) to make a strong grip on some of the essential commands of Pandas.</p><p>Although, Pandas is the best data munging tool it has certain limitations as it doesn’t allow query optimization.</p><p><strong>Other important libraries:</strong></p><p><strong>Numpy (Numerical Python): </strong>It is an extensive library for data storage and calculations. This library contains data structures, algorithms, and other things that are used to handle numerical data in Python. Furthermore, it also includes methods for arrays (lists) that are more efficient than Python’s built-in methods.</p><p><strong>Matplotlib: </strong>This library is used to visualize the data. Although, it is pretty easy to use and gives us control over the plots, I would recommend and will be using Seaborn.</p><p><strong>SciPy (Scientific Python</strong>): SciPy includes features for advanced calculations.</p><p><strong>Scikit-learn: </strong>It is a huge library of data analysis features. It has ample of classification models (e.g., support vector machines, random forest), regression analysis (linear regression, ridge regression), cluster analysis ( k-means clustering), data reduction methods (Principal Component Analysis, feature selection) which will be used for analyzing different data sets.</p><p><strong>So, this was an introduction with the essential libraries of python for Data Science. In the next article, we will take you through some real-time examples for better understanding. Till then EAT, SLEEP &amp; PRACTICE!</strong></p><figure><a href="https://usejournal.com/?utm_source=medium.com&amp;utm_medium=noteworthy_blog&amp;utm_campaign=tech&amp;utm_content=guest_post_image"><img alt="" src="https://cdn-images-1.medium.com/max/1024/1*PYxBP_WV7LI6zc-zdUkNqQ.png" /></a></figure><p>📝 Read this story later in <a href="https://usejournal.com/?utm_source=medium.com&amp;utm_medium=noteworthy_blog&amp;utm_campaign=tech&amp;utm_content=guest_post_read_later_text">Journal</a>.</p><p>👩‍💻 Wake up every Sunday morning to the week’s most noteworthy stories in Tech waiting in your inbox. <a href="https://usejournal.com/newsletter/noteworthy-in-tech/?utm_source=medium.com&amp;utm_medium=noteworthy_blog&amp;utm_campaign=tech&amp;utm_content=guest_post_text">Read the Noteworthy in Tech newsletter</a>.</p><img src="https://medium.com/_/stat?event=post.clientViewed&referrerSource=full_rss&postId=57b513d4f9e7" width="1" height="1" alt="">]]></content:encoded>
        </item>
        <item>
            <title><![CDATA[How to Conquer the Territory of Data Science]]></title>
            <link>https://medium.com/@darshanasingh/how-to-conquer-the-territory-of-data-science-9c077ebba41a?source=rss-312d19560ceb------2</link>
            <guid isPermaLink="false">https://medium.com/p/9c077ebba41a</guid>
            <category><![CDATA[sql]]></category>
            <category><![CDATA[python]]></category>
            <category><![CDATA[pandas]]></category>
            <category><![CDATA[data-science]]></category>
            <category><![CDATA[anaconda-python]]></category>
            <dc:creator><![CDATA[Darshana Singh]]></dc:creator>
            <pubDate>Sun, 30 Jun 2019 16:45:45 GMT</pubDate>
            <atom:updated>2019-08-09T23:53:38.340Z</atom:updated>
            <content:encoded><![CDATA[<blockquote>It is extremely important for a data scientist to reshape and refine the datasets into usable datasets, which can be leveraged for analytics. In this article we will look at the important aspect of data preparation and analysis</blockquote><figure><img alt="" src="https://cdn-images-1.medium.com/max/1024/1*oRmbYpHm5-Ofgus6i0Etvg.jpeg" /><figcaption>Wikimedia Commons image</figcaption></figure><p>In the field of data science, handling of data is one of the crucial tasks. Data handling is the driving factor for the data science process and clean data is important to build successful machine learning models as it enhances the performance and accuracy of the model. Data handling has three important measures pre-processing, analyzing and interpreting into meaningful insights. Right pre-processing methods with proper analyzing tools always results in meaningful insights.</p><p>As a data expert, it’s very important to understand the problem statement and relate its relevancy with the available dataset. Understanding of the problem statement and apt knowledge of differentiating between various definitions lays a strong foundation for Data Scientists.</p><p><strong><em>Why every Data Scientist should know SQL?</em></strong></p><p>SQL is the first and most reliable weapon of a Data Expert. As we have already discussed the basics of SQL in the <a href="https://medium.com/@darshanasingh/hows-whats-whys-of-sql-in-data-science-e20b01bafe17">previous article</a>, here we will take it one step forward.</p><p>There are some key concepts one needs to master to unfold the other mysteries of data science. We’ll discuss them right here -</p><p><strong>SQL commands: </strong>All the commands used in SQL to perform various operation fall into a separate category. The categories are as follows:</p><ul><li><strong>Data Definition Language (DDL): </strong>The DDL commands such as create, drop, alter and truncate is used for creating, dropping, altering and modifying the structure of database objects.</li><li><strong>Data Manipulation Language (DML):</strong> The DML commands such as insert, update and delete are used for inserting, updating and deleting the structure of database objects.</li><li><strong>Data Control Language (DCL): </strong>The DCL commands such as grant and revoke are used for providing security to database objects.</li><li><strong>Data Query Language (DQL):</strong> The DQL command such as select is used for retrieving data from the database.</li><li><strong>Transaction Control Language (TCL): </strong>TCL commands such as commit, rollback and savepoint are used for managing transactions in the database.</li></ul><p><strong>Understanding of Advanced SQL: </strong>After gaining insights on the basics of SQL, it is time to dive deeper into another concept which is Advanced SQL. In this part, we will learn about various other keywords and concepts such as</p><ul><li>UNION (combine the results of two or more SELECT statements without returning any duplicate rows)</li><li>UNION ALL(combine the results of two SELECT statements including duplicate rows.),</li><li>INTERSECT(returns only common rows returned by the two SELECT statements),</li><li>MINUS(displays the rows which are present in the first query but absent in the second query, with no duplicates and data arranged in ascending order by default)</li><li>LIMIT(fetch the limited number of records)</li><li>TOP(fetch a TOP N number or X percent records from a table)</li><li>CASE(selects one sequence of statements to execute)</li><li>DECODE(compares expression against each search value in order)</li><li>AUTO-INCREMENT(used for auto-incrementing a value of a field in the table)</li></ul><p>etc. in order to create advanced reports and perform complex pattern matching.</p><p><strong>Knowledge of Joins: </strong>The different types of Joins are -</p><ul><li><strong>INNER Join:</strong> This join selects all the records with matching values in both the tables.</li><li><strong>FULL Join:</strong> This join selects all the records either from the right table or left.</li><li><strong>LEFT Join:</strong> This join selects records left-most table along with the matching records from the right table.</li><li><strong>RIGHT Join:</strong> This join selects records from the right-most table along with the matching records from the left table.</li></ul><p>As we discussed that data pre-processing precedes with Data Analysis. SQL helps to clean the data and get the desired data frame from a given dataset and also allows us to analyze the data at a certain extent. However, for getting a better picture of a dataset we need to opt for Pandas.</p><p><strong>Pandas:</strong> <a href="https://pandas.pydata.org/">Pandas library</a> is one the most useful data munging tool, but before jumping directly into Pandas it’s a pre-requisite to learning coding conventions of Python and have some familiarity with SQL concepts.</p><p>One could start off by installing “Anaconda Python” and Jupyter notebook. There are ample of tutorials available on the Internet for Pandas.</p><p>One important thing to note, especially for the beginners, always try to go for video tutorials. It helps to create a better understanding of the topic.</p><p>So, here we discussed a short and simple roadmap for data analysis. In the next article, we will learn the next steps of data analysis and data interpretation.</p><p>Data Science as a career is a great option that is enticing as well as rewarding. However, it’s a challenging role too — no wonder it requires attention and patience to learn. For long-term success, you need to really build a strong foundation in this domain. <em>All the best!</em></p><figure><a href="https://usejournal.com/?utm_source=medium.com&amp;utm_medium=noteworthy_blog&amp;utm_campaign=tech&amp;utm_content=guest_post_image"><img alt="" src="https://cdn-images-1.medium.com/max/1024/1*PYxBP_WV7LI6zc-zdUkNqQ.png" /></a></figure><p>📝 Read this story later in <a href="https://usejournal.com/?utm_source=medium.com&amp;utm_medium=noteworthy_blog&amp;utm_campaign=tech&amp;utm_content=guest_post_read_later_text">Journal</a>.</p><p>👩‍💻 Wake up every Sunday morning to the week’s most noteworthy stories in Tech waiting in your inbox. <a href="https://usejournal.com/newsletter/noteworthy-in-tech/?utm_source=medium.com&amp;utm_medium=noteworthy_blog&amp;utm_campaign=tech&amp;utm_content=guest_post_text">Read the Noteworthy in Tech newsletter</a>.</p><img src="https://medium.com/_/stat?event=post.clientViewed&referrerSource=full_rss&postId=9c077ebba41a" width="1" height="1" alt="">]]></content:encoded>
        </item>
        <item>
            <title><![CDATA[Hows Whats & Whys of SQL in Data Science]]></title>
            <link>https://medium.com/@darshanasingh/hows-whats-whys-of-sql-in-data-science-e20b01bafe17?source=rss-312d19560ceb------2</link>
            <guid isPermaLink="false">https://medium.com/p/e20b01bafe17</guid>
            <category><![CDATA[sql-beginner]]></category>
            <category><![CDATA[database]]></category>
            <category><![CDATA[data-science]]></category>
            <category><![CDATA[rdms]]></category>
            <category><![CDATA[sql]]></category>
            <dc:creator><![CDATA[Darshana Singh]]></dc:creator>
            <pubDate>Mon, 03 Jun 2019 17:10:11 GMT</pubDate>
            <atom:updated>2019-06-03T17:10:11.256Z</atom:updated>
            <content:encoded><![CDATA[<h4>Data science is a mixture of multidisciplinary skills ranging from an intersection of mathematics, statistics, computer science, Communication &amp; business. SQL is one of the key ingredient of this.</h4><figure><img alt="" src="https://cdn-images-1.medium.com/max/947/1*hmnsJ5Z42WGoTfe_jBifSg.png" /></figure><p>Data Science is a vast sector; it is not just a standalone topic but a combination of many. SQL is an integral part of data science and learning SQL is the first step towards the path of becoming Data Scientist.</p><p>In the 21st century, data has become one of the most vital resources and handling of the humongous pile of data is the most tedious job. Data available can be incredibly noisy at times. The very first responsibility of a Data Scientist is to make sense of noisy data and here SQL comes into the picture.</p><p>SQL is database query language which is used for retrieving, manipulating &amp; managing the data by the Data Scientists. The type of database used is called <strong>Relational Database</strong>. The word relational defines that the data is structured &amp; organised in rows &amp; columns of the table.</p><p>So here we will go with a stepwise approach to conquer the territory of SQL.</p><p>There are various “flavours” of SQL that work with different database engines. PostgreSQL, MicrosoftSQL are some of the variants of SQL, just like dialects in a spoken language. Here we will be discussing MicrosoftSQL server’s Microsoft SQL Server Management Studio for Windows.</p><p>Now, why are we talking about the database engines instead of discussing how to write queries? This is because writing simple queries in an editor and executing same query in a database engine with all exception handlings are two entirely different things. As we know that knowledge applied in right direction manifest the best results.</p><p>Following are the steps to be taken for operating MSSQL Server Management Studio:</p><p><strong>Step 1:</strong> Download <a href="https://docs.microsoft.com/en-us/sql/ssms/download-sql-server-management-studio-ssms?view=sql-server-2017">Microsoft SQL Server Management Studio </a>as per your machine’s specifications. This db engine is quite heavy and requires a lot of space, so check your configuration and make sure you have enough space.</p><p><strong>Step 2:</strong> Once you have the tool, you need to have a proper database schema with you. As we discussed above, there are a lot of public repositories we can easily download.</p><p><strong>Step 3:</strong> Now we have all essential things, after which comes the most important task of attaching the db. Database engines have their own constraints. Hence, it is very important to paste your db to the right destination folder. Make sure when you download the database it must have 2 files with extension .mdf &amp; .ldf.</p><p><strong><em>Note:</em></strong><em> .mdf basically contains the data saved and .ldf has all the logs.</em></p><p>In case you miss anyone of them, try to re-download the db. Once you have db with these two files, follow the given steps.</p><p>Go to Program files <strong>→ </strong>Open MSSQL studio <strong>→ </strong>Open DATA folder <strong>→ </strong>Paste the db in DATA folder.</p><p><strong>Step 4:</strong> All the pre-requisites are done. Now open the MSSQL Studio and attach the database as mentioned here:</p><p>Click on Database folder given in the object explorer window <strong>→ </strong>Click on attach <strong>→ </strong>Click ‘Add’ <strong>→ </strong>Select db location i.e. DATA folder of MSSQL <strong>→ </strong>Select your db and click OK.</p><p>MSSQL allows access to limited folders. Hence, it is important to paste the db to the right folder.</p><p><strong>Step 5:</strong> If you can see your db in the explorer window, your db has been successfully attached.</p><p>Last but not the least before, moving on to the queries, try to understand the schema of the given db. I personally have faced this issue where I was unable to figure out which table to look first. So, for every schema there must be a ‘<strong>Root table’</strong>, mostly it is the user table. Once you successfully figure out the schema, you are half way done.</p><p>Try to write as many queries as you can. Explore &amp; experiment as much as you can &amp; never forget <strong><em>slow &amp; steady wins the race!</em></strong></p><img src="https://medium.com/_/stat?event=post.clientViewed&referrerSource=full_rss&postId=e20b01bafe17" width="1" height="1" alt="">]]></content:encoded>
        </item>
        <item>
            <title><![CDATA[Roadblocks in Indian Start-up Ecosystem]]></title>
            <link>https://medium.com/@darshanasingh/roadblocks-in-indian-start-up-ecosystem-7d219f2614cd?source=rss-312d19560ceb------2</link>
            <guid isPermaLink="false">https://medium.com/p/7d219f2614cd</guid>
            <category><![CDATA[indian-startup-ecosystem]]></category>
            <category><![CDATA[growth-hacking]]></category>
            <category><![CDATA[opportunity]]></category>
            <category><![CDATA[startup-india]]></category>
            <category><![CDATA[startup]]></category>
            <dc:creator><![CDATA[Darshana Singh]]></dc:creator>
            <pubDate>Wed, 08 May 2019 18:33:13 GMT</pubDate>
            <atom:updated>2019-05-08T18:48:01.849Z</atom:updated>
            <content:encoded><![CDATA[<blockquote>In a country that has 22 formal languages and only 10% of the population speaks English it’s not about the complicated business model, it’s simply trying to think like the common person in order to provide users with a product that “speaks” their language.</blockquote><figure><img alt="" src="https://cdn-images-1.medium.com/max/1024/1*UzdtlYIboCbKAroV5qaf2w.png" /></figure><p><strong>Survival of the fittest</strong>, a phrase originated from Darwinian evolutionary theory, aptly compliments the new era of the fast-paced and ultra-competitive startup ecosystem. In today’s era, especially for a developing country like India, growth is no longer just about thriving; it’s about surviving.</p><p>Most of the times the growth just fails to materialise and the company seems to be trapped in an endless cycle. Every job has its own set of challenges in terms of government policies, permissions, raising capital, competition, unforeseen challenges, etc.</p><p><strong><em>Following is a lowdown on some of the challenges faced by startups in India and their relevant solutions.</em></strong></p><h3><strong>Lack of innovation</strong></h3><ul><li>Replication of western business model, the lack of vision and innovative streak in startup community is limiting success in India.</li><li>Initiatives like<em> </em><strong><em>Make in India</em></strong> and <strong><em>Start-up India</em> </strong>have stimulated growth of start-ups with a range of initiatives like setting up of research parks and providing grants.</li></ul><h3><strong>Staffing Issues</strong></h3><ul><li>Startups working on limited budgets are unable to bridge the divide in salary and perks paid by MNCs.</li><li>Hiring fresher candidates on the internship basis can resolve the issue to a certain extent. The year 2018 has seen several fresh graduates who would be willing to work for a startup, at least for training and some experience.</li></ul><h3><strong>Digital Marketing</strong></h3><ul><li>Advertising in print, radio, and TV costs a fortune that is sometimes beyond the reach of startups.</li><li>Utilization of social media platforms including Facebook Business, LinkedIn, and Twitter to rapidly get across messages related to product and services launches and innovations made by the start-up.</li></ul><h3><strong>Tax liabilities</strong></h3><ul><li>A startup cannot raise an invoice until the time it doesn’t have an active GST number.</li><li>With the Government’s <strong><em>‘Digital India’ initiative</em></strong>, the process of registration under the GST regime has been simplified, which is a step in the right direction.</li></ul><h3><strong>Mentorship Crisis</strong></h3><ul><li>Most of startups have brilliant ideas , but have little or no industry, business and market experience to get the products to the market.</li><li>Founders of fledgling<em> </em>startups are seeing virtue in having multiple mentors, who come for free and have no strings attached in terms of equity or investments to the ventures.</li></ul><h3><strong>Decelerators</strong></h3><ul><li>Influence of incubators &amp; similar organizations which try to control, manage and be the daddies of the start-ups in the name of funding &amp; mentoring.</li><li>In an attempt to boost entrepreneurship, the <strong><em>Department of Industrial Policy and Promotion</em></strong> (DIPP) has already disbursed a decent amount under its Fund of Funds for Startups (FFS) initiative to more than 100 startups of India.</li></ul><p>Focus &amp; conviction on substances and not mere superlatives are the imperative rules for a long term success of an enterprise. Once the roadblocks we discussed here are unblocked, there’s room for steady growth.</p><img src="https://medium.com/_/stat?event=post.clientViewed&referrerSource=full_rss&postId=7d219f2614cd" width="1" height="1" alt="">]]></content:encoded>
        </item>
        <item>
            <title><![CDATA[What to Know About Acqui-hiring]]></title>
            <link>https://medium.com/@darshanasingh/what-to-know-about-acqui-hiring-5e77d777744e?source=rss-312d19560ceb------2</link>
            <guid isPermaLink="false">https://medium.com/p/5e77d777744e</guid>
            <category><![CDATA[startup]]></category>
            <category><![CDATA[acquihire]]></category>
            <category><![CDATA[startup-ecosystem]]></category>
            <category><![CDATA[acquisition]]></category>
            <category><![CDATA[talent-acquisition]]></category>
            <dc:creator><![CDATA[Darshana Singh]]></dc:creator>
            <pubDate>Wed, 01 May 2019 18:29:27 GMT</pubDate>
            <atom:updated>2019-08-09T23:53:12.044Z</atom:updated>
            <content:encoded><![CDATA[<blockquote>Acqui-hire allows big corporates to shore up on the high-quality talent available in the ecosystem to build new services &amp; products.</blockquote><figure><img alt="" src="https://cdn-images-1.medium.com/max/696/1*SDv6oqOGuKnwD6WIg2-efA.png" /></figure><p>One of the recent trends that has gained ground in the Indian tech landscape is acqui-hiring. It is always a lucrative option for companies to have engineers who have had good working exposure in both tech and the business side of it.</p><p><strong>Acqui-hiring</strong>, the practice of leveraging talent to build new capabilities, is the rage in ecosystem thanks to intense competition of top engineers. Several of the most voracious acqui-hirers drew an overflow crowd of about 200 entrepreneurs and a few investors to a panel today.</p><p>The easiest acquisitions happen with startups that haven’t raised a lot of money and its growth is being stagnant.</p><h3><strong>Identify</strong>:</h3><p>In acqui-hire process, it’s very important to find a perfect set of startups who are fit for it. It can be based on the founding year, funding stages, and the solution/product.</p><h3><strong>Define Parameters:</strong></h3><p>Ideally, in an acqui-hire process where talent pool has the highest weightage, the list goes as follows:</p><figure><img alt="" src="https://cdn-images-1.medium.com/max/672/1*3ld098cG9FsuBoVCEB0a8w.png" /><figcaption><strong>Strategic Perspective</strong></figcaption></figure><p>Having this points in mind makes data curation pretty understandable.</p><h3><strong>Legalities of the process :</strong></h3><p>There are various modes employed by acquirers while acqui-hiring –Asset Purchase being the most common and convenient. Its better to consult a lawyer who can suggest the nuts &amp; bolts of the process. There are ample of legal things one needs to keep in consideration like employee compensation, asset ownership, share ownership &amp; Legal + financial DD (Due diligence).</p><p>Many acquisitions generally end up not working because of fragile communication bridge between the allies. A strong signal of a match is when a product or technology colleague sends a note to corp-dev saying they think a startup is a strong fit. Though, the final result depends on the discussions between the two parties. All you can do is to make sure you have clarity over roadmaps that doesn’t conflict with an internal team’s plans.</p><figure><a href="https://usejournal.com/?utm_source=medium.com&amp;utm_medium=noteworthy_blog&amp;utm_campaign=tech&amp;utm_content=guest_post_image"><img alt="" src="https://cdn-images-1.medium.com/max/1024/1*PYxBP_WV7LI6zc-zdUkNqQ.png" /></a></figure><p>📝 Read this story later in <a href="https://usejournal.com/?utm_source=medium.com&amp;utm_medium=noteworthy_blog&amp;utm_campaign=tech&amp;utm_content=guest_post_read_later_text">Journal</a>.</p><p>👩‍💻 Wake up every Sunday morning to the week’s most noteworthy stories in Tech waiting in your inbox. <a href="https://usejournal.com/newsletter/noteworthy-in-tech/?utm_source=medium.com&amp;utm_medium=noteworthy_blog&amp;utm_campaign=tech&amp;utm_content=guest_post_text">Read the Noteworthy in Tech newsletter</a>.</p><img src="https://medium.com/_/stat?event=post.clientViewed&referrerSource=full_rss&postId=5e77d777744e" width="1" height="1" alt="">]]></content:encoded>
        </item>
    </channel>
</rss>