<center>
<a target=“_blank” href="https://www.datacamp.com/learn/python/"><img src="https://res.cloudinary.com/dyd911kmh/image/upload/f_auto,q_auto:best/v1582839819/python_4_t5pp5t.png" /></a>
</center> 

<h2 id="virtual-environment-in-python">Virtual Environment in Python</h2>
Learn about the Virtual Environment and two different ways for creating it: Pipenv is mostly used by web developers and Anaconda distributions for data scientists where Virtual Environment is created from &#39;conda&#39; through &#39;Anaconda Prompt&#39;. It also has an alternative option to create from Anaconda Navigator.
Virtual Environment is used to create a container or isolated environment where the Python-related dependencies are installed for a specific project. One can work with many different versions of Python with its various packages. Data scientists tend to use Anaconda distribution, which comes with many useful pre-installed packages, which are easy to install and manage. A web developer who uses Django, Flask, and other Python-related frameworks can use Pipenv as their Virtual Environment.
<h2 id="pipenv">Pipenv</h2>
Pipenv is a new and popular way of automatically creating a &#39;virtualenv&#39; for the project. It creates a Pipfile, which helps to manage the package and can be installed or removed easily.
Through Pipenv, &#39;pip&#39; and &#39;virtualenv&#39; can be used together to create a Virtual Environment, Pipfile works as the replacement of the &#39;requirement.txt.&#39; which tracks the package version according to the given project.
This tutorial uses Git Bash as the terminal in the Windows Operating System. However, for Mac users, Homebrew could be used, which is the package management tool, and similarly, LinuxBrew could be used for Linux users.
Let&#39;s create a project using the &#39;mkdir project-name&#39; command, which stands for making a directory with the project name as &#39;new-project&#39; and move to the newly created directory by using &#39;cd&#39; command. 
<img src="https://i.imgur.com/5qySqkp.png">
Windows users can use the following command to install &#39;pipenv&#39;.
<code>pip install pipenv</code>
Linux/Mac Users can use the following command to install &#39;pipenv&#39; after installing LinuxBrew.
<code>brew install pipenv</code>
<h3 id="creating-a-virtualenv-for-the-project">Creating a virtualenv for the project</h3>
For creating the &#39;virtualenv&#39; for the project, use the following command. 
<code>pipenv shell</code>
The command &#39;pipenv&#39; creates a new &#39;virtualenv&#39; for the project along with Pipfile side by side.
<img src="https://i.imgur.com/Nx0xcLT.png">
<h3 id="installing-uninstalling-required-packages-for-the-project">Installing/UnInstalling required packages for the project</h3>
You&#39;ll install the two package named &#39;requests&#39; and &#39;flask&#39; in your Virtual Environment using the following command. 
<code>pipenv install requests</code> 
<code>pipenv install flask</code> 
The following changes are seen after the installation of the two packages.
<img src="https://i.imgur.com/C0ctmre.png">
For the uninstallation of the package, use the following command. 
<code>pipenv uninstall flask</code>
<h3 id="exiting-from-the-virtual-environment">Exiting from the Virtual Environment</h3>
You can use the following command to deactivate form the current environment.
<code>exit</code>
<h2 id="anaconda">Anaconda</h2>
Anaconda is the most popular platform used by data scientists and machine learning engineers. It consists of &#39;Conda&#39;, which helps in managing the environment, libraries, and dependencies.
<h2 id="installing-anaconda-for-python-virtual-environment-manager">Installing Anaconda for Python Virtual Environment Manager</h2>
<ul>
<li>Windows users can head over to the following tutorial to set up the Anaconda distribution. </li>
<a href="https://medium.com/@GalarnykMichael/install-python-on-windows-anaconda-c63c7c3d1444">Install Anaconda Windows</a> 
<li>Linux/Mac Users then head over to the following tutorial to set up the Anaconda distribution. </li>
<a href="https://www.datacamp.com/community/tutorials/installing-anaconda-mac-os-x">Install Anaconda Mac/Linux</a> 
</ul>
Use the Anaconda version of 4.6 or newer. There are slight changes in the command for the previous version. If you are running older versions, use the following command for an update. 
<code>conda update conda</code>
One of two ways can be used in the creation of the Virtual Environment, which is shown below.
<ul>
 <li>Anaconda Prompt-It is a command-line tool that comes after the installation of Anaconda distribution.</li>
 <li>Anaconda Navigator-It is a Graphical User Interface that serves as an alternative tool to launch and manage packages in Anaconda.</li>

This tutorial uses Windows Operating System but works with any Operating System. There might be some minor changes in the Anaconda command, but the overall creation process for Virtual Environment is the same.
You can open &quot;Terminal&quot; in Mac/Linux to achieve the following result.
According to the requirements needed for the projects, the following guides serve more detail in the creation of a Virtual Environment. 
<a href="https://docs.conda.io/projects/conda/en/latest/user-guide/tasks/manage-environments.html">Managing environments</a>
<h2 id="anaconda-prompt">Anaconda Prompt</h2>
Press the &quot;Windows&quot; icon in the lower corner of the screen to open the &quot;Search&quot; box. Type &quot;Anaconda Prompt&quot; and then hit &quot;Enter&quot; to open it. Use <code>conda</code> to check Anaconda has been successfully installed in your system; the following changes could be seen.
<img src="https://i.imgur.com/hyDvwZM.png" /> 
<ol>
<li>Creating a new Virtual Environment. 
The following command takes &#39;-n&#39; as a flag, which is for creating a new environment with its name as &#39;env&#39; and the specific Python version of &#39;3.7&#39;.
<code>conda create -n env python = 3.7</code> 
</li>
<li>Activating the Virtual Environment. 
The command below activates the Virtual Environment, which changes the prompt where the &#39;env&#39; is shown in parenthesis.
<code>conda activate env</code>
<img src = "https://i.imgur.com/rhGNPIY.png"> 
</li>
<li>Install the required package. 
For example, the &#39;numpy&#39; package is installed where &#39;env&#39; is the specific Virtual Environment. 
<code>conda install -n env numpy</code> 
OR 
Also, Python Package manager could be used to install &#39;numpy&#39;.
<code>pip install numpy</code> 
<img src="https://i.imgur.com/uE2pSHM.png"> 
</li>
<li>Listing all of the installed packages inside a Virtual Environment. 
The following command can list the package specific to the Virtual Environment.
<code>conda list</code> <img src="https://i.imgur.com/KhJqbDu.png"> 
</li>
<li>Listing out all of the created Virtual Environment. 
All of the environments created will be listed by the following command.
<code>conda env list</code>
<img src="https://i.imgur.com/rA7t3Av.png"> 
</li>
<li>Deactivating the Virtual Environment. 
The following command will deactivate the current environment &#39;env&#39; and will change to &#39;base&#39;.
<code>conda deactivate</code> 
</li>
</ol>
<ol>
<li>Removing the Virtual Environment. 
The following command removes the &#39;myenv&#39; Virtual Environment with all its packages at the same time.
<code>conda env remove -n myenv</code>
<img src="https://i.imgur.com/fxqSU5N.png">
As you can see after listing with <code>&#39;conda env list&#39;</code>, only two Virtual Environments are shown.
<img src="https://i.imgur.com/5t6HSFx.png"></li>
</ol>
<h2 id="anaconda-navigator">Anaconda Navigator</h2>
<ol>
<li>Press the &quot;Windows&quot; icon in the lower corner of the screen to open the &quot;Search&quot; box. Type &quot;Anaconda Navigator&quot; and then hit &quot;Enter&quot; to open it.</li>
<li>Move to &quot;Environments,&quot; where two virtual environments are shown.&#39; base&#39; is the default, whereas &#39;env&#39; is the previously created Virtual Environment.
<img src="https://i.imgur.com/PIJCvqP.png"> 
</li>
<li>Click &quot;Create&quot; and Fill up the required information, as shown below, to create a new Virtual Environment called &quot;new-env.&quot;
<img src="https://i.imgur.com/sHUpjDk.png"> 
</li>
<li>Move to the &quot;new-env&quot; and select &quot;All&quot; to install the required package, i.e., numpy in our case.
<img src="https://i.imgur.com/wRwduLg.png"> </li>
<li>Select &#39;new-env&#39; at the home directory so that launching an application will be specific to that particular virtual environment.
<img src="https://i.imgur.com/jHGp0Jq.png"> </li>
</ol>
<h2 id="conclusion">Conclusion</h2>
Congratulations on finishing the tutorial! 
You&#39;ve successfully learned about the Virtual Environment and creation through Pipenv and Anaconda. 
You can look over to the following courses created by Anaconda in DataCamp platform to learn more: 
<ul>
<li><a href="https://www.datacamp.com/courses/building-and-distributing-packages-with-conda">Conda for Building &amp; Distributing Packages</a></li> 
<li><a href="https://www.datacamp.com/courses/conda-essentials">Conda Essentials</a></li></ul> 
References: 
<a href="https://pipenv-fork.readthedocs.io/en/latest/install.html#installing-pipenv">Installing pipenv</a>

https://www.datacamp.com/community/tutorials/virtual-environment-in-python

In this tutorial, you'll learn about the Virtual Environment and two different ways of creating it.

(Tutorial) Virtual Environment in Python

Virtual Environment in Python

If you are just getting started in Python and would like to learn more, take DataCamp&#39;s <a target=“_blank” href="https://learn.datacamp.com/courses/introduction-to-data-science-in-python">Introduction to Data Science in Python</a> course.
<center>
<a target=“_blank” href="https://www.datacamp.com/learn/python/"><img src="https://res.cloudinary.com/dyd911kmh/image/upload/f_auto,q_auto:best/v1582839819/python_4_t5pp5t.png" /></a>
</center> 

A lot of you, while reading this tutorial, might think that there is nothing undiscovered about a simple <a target=“_blank” href="https://www.datacamp.com/learn/python/">Python</a> Print function since you all would have started learning Python with the evergreen example of printing <code>Hello, World!</code>. It&#39;s also true that Python or, for that matter, any programming language, the Print function is the most basic and the baby step that you take while learning a particular language. However, while learning a programming language, you sometimes tend to focus on more advanced topics and many times forget the intricacies or capabilities of a simple function that you might almost always use.
The focus of today&#39;s tutorial will be entirely on Python&#39;s Print function; you will learn about the most underestimated function.
Let&#39;s begin this tutorial by printing the <code>Hello, World!</code> example.
<pre><code class="lang-python">print(&quot;Hello, World!&quot;)
</code></pre>
<pre><code>Hello, World!
</code></pre>Unlike <code>Python2</code>, which did not require you to put a parenthesis, in <code>Python3</code>, parenthesis is a must else it will raise a syntax error as shown below.
<pre><code class="lang-python">print &quot;Hello, World!&quot;
</code></pre>
<pre><code> File &quot;&lt;ipython-input-6-a1fcabcd869c&gt;&quot;, line 1
 print &quot;Hello, World!&quot;
 ^
SyntaxError: Missing parentheses in call to &#39;print&#39;. Did you mean print(&quot;Hello, World!&quot;)?
</code></pre>From the above output, you can conclude that in Python3, <code>print()</code> is not a statement but a function.
Having said that, let&#39;s check the <code>type/class</code> of the <code>print()</code> function.
<pre><code class="lang-python">type(print)
</code></pre>
<pre><code>builtin_function_or_method
</code></pre>It returns <code>builtin_function_or_method</code>, which means it is a predefined or a builtin <code>Python Function</code>.
Now let&#39;s say you want to add a new line or a vertical space between the below two outputs, to achieve this you can simply call the <code>print()</code> function without passing any argument in it.
<pre><code class="lang-python">print(&quot;Hello, World!&quot;);print(&quot;Hello, World!&quot;)
</code></pre>
<pre><code>Hello, World!
Hello, World!
</code></pre><pre><code class="lang-python">print(&quot;Hello, World!&quot;)
print()
print(&quot;Hello, World!&quot;)
</code></pre>
<pre><code>Hello, World!

Hello, World!
</code></pre>Let&#39;s look at the syntax of the <code>print()</code> function.
print(value, ..., sep=&#39; &#39;, end=&#39;\n&#39;, file=sys.stdout, flush=False)
As you know by now, the print function Prints the values to a stream, or to sys.stdout by default. The sys.stdout or system standard output means the print function will print the output on the screen, and it can even be changed to stdin or stderr.
<h4 id="optional-keyword-arguments-">Optional keyword arguments:</h4>
<ul>
<li><code>sep</code>: It can be a string which you would like to insert between values, defaults to space.
 Let&#39;s put a list of words inside the print function and separate them with a new line. Remember, by default; the separator adds a blank space between each word.
</li>
</ul>
<pre><code class="lang-python">print(&#39;datacamp&#39;,&#39;tutorial&#39;,&#39;on&#39;,&#39;python&#39;,&#39;print&#39;,&#39;function&#39;)
</code></pre>
<pre><code>datacamp tutorial on python print function
</code></pre><pre><code class="lang-python">print(&#39;datacamp&#39;,&#39;tutorial&#39;,&#39;on&#39;,&#39;python&#39;,&#39;print&#39;,&#39;function&#39;,sep=&#39;\n&#39;) #`\n` will put each word in a new line
</code></pre>
<pre><code>datacamp
tutorial
on
python
print
function
</code></pre>Similarly, you can separate them with a comma, or add two <code>\n</code> which will add an empty line in between or even add a plus $(+)$ sign.
<pre><code class="lang-python">print(&#39;datacamp&#39;,&#39;tutorial&#39;,&#39;on&#39;,&#39;python&#39;,&#39;print&#39;,&#39;function&#39;,sep=&#39;,&#39;)
</code></pre>
<pre><code>datacamp,tutorial,on,python,print,function
</code></pre><pre><code class="lang-python">print(&#39;datacamp&#39;,&#39;tutorial&#39;,&#39;on&#39;,&#39;python&#39;,&#39;print&#39;,&#39;function&#39;,sep=&#39;\n\n&#39;)
</code></pre>
<pre><code>datacamp

tutorial

on

python

print

function
</code></pre><pre><code class="lang-python">print(&#39;datacamp&#39;,&#39;tutorial&#39;,&#39;on&#39;,&#39;python&#39;,&#39;print&#39;,&#39;function&#39;,sep=&#39;,+&#39;)
</code></pre>
<pre><code>datacamp,+tutorial,+on,+python,+print,+function
</code></pre>Before you jump on to the next argument, i.e., <code>end</code>, remember that you can also pass in a variable to the print function. To understand this, let&#39;s take an example by defining a list of integers and pass it to the print function. You would expect it to print the list of integers.
<pre><code class="lang-python">int_list = [1,2,3,4,5,6]
print(int_list)
</code></pre>
<pre><code>[1, 2, 3, 4, 5, 6]
</code></pre><ul>
<li><code>end</code>: It is a string appended after the last value, defaults to a newline. It allows the programmer to define a custom ending character for each print call other than the default newline or <code>\n</code>.
Let&#39;s say you have two strings and you want to join them together with space, all you would need to do is in the print function of the first string <code>str1</code> add <code>end</code> argument with quotes, and you can expect the two strings to be joined by a space.
</li>
</ul>
<pre><code class="lang-python">str1 = &#39;datacamp tutorial on&#39;
str2 = &#39;python print function&#39;
</code></pre>
<pre><code class="lang-python">print(str1)
print(str2)
</code></pre>
<pre><code>datacamp tutorial on
python print function
</code></pre><pre><code class="lang-python">print(str1,end=&#39; &#39;)
print(str2)
</code></pre>
<pre><code>datacamp tutorial on python print function
</code></pre>Let&#39;s take another example where you have a function whose job is to print all values within a list on the same line. You could achieve this with the <code>end</code> argument, as shown below:
<pre><code class="lang-python">def value(items):
 for item in items:
 print(item, end=&#39; &#39;)
</code></pre>
<pre><code class="lang-python">value([1,2,3,4])
</code></pre>
<pre><code>1 2 3 4
</code></pre><ul>
<li><code>file</code>: A file-like object (stream); defaults to the current sys.stdout. Here you can mention the file in which you would like to write or append the output of the print function.
 By using the file argument, you can store the output of the print function to a file in various formats like <code>.csv</code>, <code>.txt</code>, etc. Let&#39;s understand this by taking an example wherein you iterate over each element of the list. It is saved in a text file. To accomplish this, first, you will open a text file in an <code>append</code> state in which you will be saving the output of the print statement. Next, you will define the function whose output will be appended in the text file.
</li>
</ul>
<pre><code class="lang-python">file = open(&#39;print.txt&#39;,&#39;a+&#39;)
</code></pre>
<pre><code class="lang-python">def value(items):
 for item in items:
 print(item, file=file)
 file.close() # close the file ones the function execution completes.
</code></pre>
<pre><code class="lang-python">value([1,2,3,4,5,6,7,8,9,10])
</code></pre>
Once the above function execution completes, you should see a file named <code>print.txt</code> in your current directory. Let&#39;s open it and see its contents.
<img src="https://res.cloudinary.com/dyd911kmh/image/upload/f_auto,q_auto:best/v1582839980/print2_las5q5.png" />
From the above output, it is clear that you can even save the output to files and not just print the output on the terminal or within the notebook.
<ul>
<li><code>flush</code>: It determines whether to forcibly flush the stream. By default, it is set to False.
Typically, output to a file or the console is buffered, with text output at least until you print a newline (<a href="https://stackoverflow.com/questions/15608229/what-does-prints-flush-do">Source</a>). Buffer means that the output is stored in some kind of a register where the output resides before it is ready to be stored or the file is finally closed. The job of the flush is to make sure that the output, which is being buffered, goes to the destination safely.
</li>
</ul>
<pre><code class="lang-python">import time
print(&#39;Please enter your email-id : &#39;, end=&#39; &#39;)
#print(&#39;Please enter your email-id : &#39;, end=&#39; &#39;, flush=True) #run this to see the difference and comment out the above line of code.
time.sleep(5)
</code></pre>
<pre><code>Please enter your email-id : 
</code></pre>If you run the above lines of code in the terminal, you will notice that the prompt string does not show up until the sleep timer ends and the program exits (<a href="https://stackoverflow.com/questions/15608229/what-does-prints-flush-do">Source</a>). However, if you add <code>flush=True</code> in the print function, you will see the prompt, and then you will have to wait for 5 seconds for the program to finish.
Somehow the Jupyter Notebook or Jupyter Lab takes care of it and shows the prompt before the 5 seconds timer, so if you want to test this functionality of print, make sure to run it in command line terminal and not on the jupyter notebook.
<a id='inp'></a>
Let&#39;s now see how you can make use of the print function to take input from the user in the jupyter notebook. For this, you will use python&#39;s builtin function <code>input()</code>.
<pre><code class="lang-python">tutorial_topic = input()
print(&quot;The topic of today&#39;s tutorial is: &quot;, end=&#39;&#39;)
print(tutorial_topic)
</code></pre>
<pre><code> Print Function


The topic of today&#39;s tutorial is: Print Function
</code></pre>As soon as you run the above cell, you should see an output as shown below:
<img src="https://res.cloudinary.com/dyd911kmh/image/upload/f_auto,q_auto:best/v1582839980/print3_cuub0l.png" />
<a href="#inp">Here</a> you defined an optional named argument <code>end</code> that you learned before, which concatenates the static statement inside print statement with the user input.
Let&#39;s see some cooler ways of printing variable values inside the print function.
<ul>
<li>To display a variable&#39;s value along with a predefined string, all you need to do is add a comma in between the two. Here the position of the predefined string and the variable does not matter.</li>
</ul>
<pre><code class="lang-python">a = 2
b = &quot;Datacamp&quot;
print(a,&quot;is an integer while&quot;,b,&quot;is a string.&quot;)
</code></pre>
<pre><code>2 is an integer while Datacamp is a string.
</code></pre><ul>
<li>You can make use of the <code>format</code> argument wherein you can pass as many variables as you want to print. When you pass the variables in the format function, you need to specify the index numbers (order in which they are placed inside the format argument) in the predefined string.
 So this print function will now act as a template for you.
 Another thing to remember is that here the index numbers are represented with a curly bracket <code>{}</code> representing a placeholder.
Let&#39;s understand it with the below example:
</li>
</ul>
<pre><code class="lang-python">a = 2
b = &quot;Datacamp&quot;
print(&quot;{0} is an integer while {1} is a string.&quot;.format(a,b))
</code></pre>
<pre><code>2 is an integer while Datacamp is a string.
</code></pre>If you put the index number of the second variable at both places, as expected, it will print the same values, in this case, <code>b</code> variable for both.
<pre><code class="lang-python">print(&quot;{1} is an integer while {1} is a string.&quot;.format(a,b))
</code></pre>
<pre><code>Datacamp is an integer while Datacamp is a string.
</code></pre><ul>
<li>Similar to a <code>format</code> argument where your print function acts as a template, you have a percentage (%) sign that you can use to print the values of the variables.
Like format argument, this also has a concept of placeholders. However, unlike the <code>format</code> function where you pass in just the index numbers, in this, you also need to specify the datatype the placeholder should expect.
<ul>
<li>%d is used as a placeholder for numeric or decimal values.</li>
<li>%s is used as a placeholder for strings.</li>
</ul>
</li>
</ul>
<pre><code class="lang-python">a = 2
b = &quot;Datacamp&quot;
print(&quot;%d is an integer while %s is a string.&quot;%(a,b))
</code></pre>
<pre><code>2 is an integer while Datacamp is a string.
</code></pre>Let&#39;s see what happens if you specify <code>%s</code> for the variable <code>a</code> which is an integer.
<pre><code class="lang-python">print(&quot;%s is an integer while %s is a string.&quot;%(a,b))
</code></pre>
<pre><code>2 is an integer while Datacamp is a string.
</code></pre>As you can see from the above example, it still works. The reason is that the <code>Print</code> function implicitly performed <code>typecasting</code> and converted the integer to a string. However, the opposite is not true. It will fail to convert a string to an integer and will result in a <code>TypeError</code>.
Let&#39;s find out.
<pre><code class="lang-python">print(&quot;%d is an integer while %d is a string.&quot;%(a,b))
</code></pre>
<pre><code>---------------------------------------------------------------------------

TypeError Traceback (most recent call last)

&lt;ipython-input-121-68c55041ecfe&gt; in &lt;module&gt;
----&gt; 1 print(&quot;%d is an integer while %d is a string.&quot;%(a,b))


TypeError: %d format: a number is required, not str
</code></pre><h2 id="conclusion">Conclusion</h2>
Congratulations on finishing the tutorial.
This tutorial was a good starting point for beginners who aspire to become proficient in Python. You might want to play around with the Print function a bit more and explore a few more functionalities of it that might have been missed out in this tutorial.
Please feel free to ask any questions related to this tutorial in the comments section below.
If you are just getting started in Python and would like to learn more, take DataCamp&#39;s <a target=“_blank” href="https://learn.datacamp.com/courses/introduction-to-data-science-in-python">Introduction to Data Science in Python</a> course.

https://www.datacamp.com/community/tutorials/python-print-function

Learn how you can leverage the capability of a simple Python Print function in various ways with the help of examples.

Learn how you can LEVERAGE the capability of a simple PYTHON Print function in various ways with the help of EXAMPLES.

(Tutorial) Python Print() Function

Python Print() Function

https://www.datacamp.com/community/tutorials/python-descriptors

Learn what Python Descriptors are, when you should use them, and why you should use them. 

(Tutorial) Python Descriptors

Python Descriptors

If you would like to learn about SQL from basic to an advanced level, take DataCamp&#39;s <a href="https://www.datacamp.com/tracks/sql-fundamentals">SQL Fundamentals</a> skill track.
<h2 id="introduction">Introduction</h2>
<center><img src="https://res.cloudinary.com/dyd911kmh/image/upload/f_auto,q_auto:best/v1582234330/sql1_txc0vs.png" /></center>

SQL stands for <code>Structured Query Language</code>. As per Wikipedia, SQL is a domain-specific language used in programming and designed for managing data held in a relational database management system (RDBMS), or for stream processing in a relational data stream management system (RDSMS). It is particularly useful in handling structured data, i.e., data incorporating relations among entities and variables (<a href="https://en.wikipedia.org/wiki/SQL">Source</a>).
Data can be inserted, searched, updated, or deleted from the database records using SQL. SQL can be beneficial in maintaining and even optimizing the databases.
As the name suggests, SQL is capable of handling only the structured type of data, which means data that can be represented in rows and columns format like dates, numbers, and strings. On the other hand, unstructured data can be represented in the form of images, videos, speech, or text.
But what kind of information do these Databases hold?
They can hold a variety of information or maybe anything that you could think of—ranging from catalogs of product, customer information, images metadata, text data, etc.
Let&#39;s say you want to automate the process of Resume screening, and you would like to store the name, education, job experience, and application date of the candidate who has applied for an open job position. You would need a database to be designed which would store the above information related to the candidate, and to achieve this; you will need an SQL server.
In order for the information to be easily accessible and understandable, you need database management systems or relational database management system. DBMS can be helpful in a variety of ways, like sorting information or linking databases to each other, provide reports about any updates in the database, and even manage administrative access to the database.
Some of the most popular SQL databases are:
<ul>
<li><code>MySQL</code>: It is the most popular open-source relational database management system. Just to name a few, MySQL is currently being used by Facebook, Youtube, and Twitter. Since it&#39;s open-source, it comes without any cost associated with it.
</li>
<li><code>Oracle Database</code>: It is a multi-model DBMS developed by Oracle and is written in the C++ language. It is widely used for running online transaction processing like bank payment server websites. Though being costly, it is very reliable. To handle unstructured data, Oracle has also released an Oracle NoSQL database.
</li>
<li><code>MS SQL</code>: An RDBMS developed by Microsoft. It supports both structured (SQL) and unstructured (NoSQL) data. Its primary function is to store and retrieve data based on the requests it receives from other software-like applications. It is fast and stable and works well with other Microsoft based products.
</li>
<li><code>Microsoft Azure</code>: It is a cloud computing service created by Microsoft. Its primary functionalities are building, testing, deploying, and managing applications and services which are managed by Microsoft owned data centers. It provides software as a service (SaaS), platform as a service (PaaS) and infrastructure as a service (IaaS)(<a href="https://www.juniper.net/documentation/en_US/vsrx/topics/concept/security-vsrx-azure-overview.html">Source</a>). It has support for various programming languages. It is considered to give a tough competition to Amazon Web Services (AWS) and Google Cloud Platform (GCP).
</li>
</ul>
Few other popular SQL databases are <code>IBM DB2</code>, <code>MariaDB</code>, <code>Sybase</code>, and <code>PostgreSQL</code>.
In today&#39;s tutorial, you will learn to install Microsoft SQL (MS SQL). So without any further ado, let&#39;s get started!
<h3 id="installing-ms-sql-on-windows">Installing MS SQL on Windows</h3>
<ul>
<li>Firstly you have to search on google <code>Microsoft SQL server download</code> and click on the very first link that it shows as shown below. Make sure it is a Microsoft website and not any other third-party site.</li>
</ul>
<center><img src="https://res.cloudinary.com/dyd911kmh/image/upload/f_auto,q_auto:best/v1582234330/sql2_gl4va2.png" /></center>

<ul>
<li>Then scroll down and look for <code>Developer</code> edition, click <code>Download Now</code>, and save the file. The developer edition is a full version and comes packaged with a fully featured free edition specially designed for developers.</li>
</ul>
<center><img src="https://res.cloudinary.com/dyd911kmh/image/upload/f_auto,q_auto:best/v1582234330/sql3_f2s66o.png" /></center>

<ul>
<li>Once the download is successful, go to the downloaded folder and look for the <code>SQLServer2017-SSEI-Dev.exe</code> file. Double click on that file, and you should see <code>Getting things ready</code>, which means everything is going smoothly.</li>
</ul>
<center><img src="https://res.cloudinary.com/dyd911kmh/image/upload/f_auto,q_auto:best/v1582234330/sql4_z1lj14.png" /></center>

<ul>
<li>After that, it will show you three options <code>Basic</code>, <code>Custom</code>, and <code>Download Media</code>. You need to select the second option, which is <code>Custom</code>.</li>
</ul>
<center><img src="https://res.cloudinary.com/dyd911kmh/image/upload/f_auto,q_auto:best/v1582234331/sql5_viij80.png" /></center>

<ul>
<li>Then you will be asked where you would like your MS SQL installation files to reside, choose accordingly, and click on <code>Install</code>. Make sure you have good internet connectivity. In the meantime, feel free to take a short nap since it will take some time to install.</li>
</ul>
<center><img src="https://res.cloudinary.com/dyd911kmh/image/upload/f_auto,q_auto:best/v1582234330/sql6_lpqizh.png" /></center>

<ul>
<li>Once the download is complete, you shall see download success. It will take you to the next steps that are necessary. A new window with the <code>SQL Server Installation Center</code> will open, which will have planning, installation, maintenance, etc. You need to click on <code>installation</code> and then on the right side of the panel you will find multiple options, you need to select <code>New SQL Server stand-alone installation or add features to existing installation</code>.</li>
</ul>
<center><img src="https://res.cloudinary.com/dyd911kmh/image/upload/f_auto,q_auto:best/v1582234331/sql7_ofg1mw.png" /></center>

<center><img src="https://res.cloudinary.com/dyd911kmh/image/upload/f_auto,q_auto:best/v1582234331/sql8_hydqxe.png" /></center>

<ul>
<li>Then it will open the <code>SQL Server 2017 setup</code> window in which, by default, the checkbox with <code>specify a free edition</code> to Developer would be selected. All you need to do is click next and accept the license terms and again click on next. It will install the setup files and move to the next step, which is <code>install rules</code>. You might get a warning of <code>windows firewall</code>, which you can safely ignore.</li>
</ul>
<center><img src="https://res.cloudinary.com/dyd911kmh/image/upload/f_auto,q_auto:best/v1582234331/sql9_hrve93.png" /></center>

<center><img src="https://res.cloudinary.com/dyd911kmh/image/upload/f_auto,q_auto:best/v1582234332/sql10_qxx8pq.png" /></center>

<center><img src="https://res.cloudinary.com/dyd911kmh/image/upload/f_auto,q_auto:best/v1582234331/sql11_m2v2wh.png" /></center>


<ul>
<li>Then you will be directed to the <code>Feature Selection</code> setup in which you will find a lot of options to select from, like instance features, database engine services, machine learning services, etc. You need to select the <code>Database engine services</code> and click next.</li>
</ul>
<center><img src="https://res.cloudinary.com/dyd911kmh/image/upload/f_auto,q_auto:best/v1582234331/sql12_okx4n0.png" /></center>

<ul>
<li>In the <code>instance configuration</code>, specify an instance name that will be later used to connect to the SQL server. Let&#39;s name it <code>Datacamp_Sql</code> and click next. You can skip the <code>Server configuration</code> and directly move on to the <code>database engine configuration</code>.</li>
</ul>
<center><img src="https://res.cloudinary.com/dyd911kmh/image/upload/f_auto,q_auto:best/v1582234330/sql13_jijtpt.png" /></center>

<ul>
<li>In database engine configuration, select <code>mix mode</code> as the authentication mode, specify the password, i.e., <code>datacamp@1234</code> and click on <code>add current user</code>. Remember that this password will be used with the instance name that you had created in the previous step. Finally, click on <code>install</code>.</li>
</ul>
<center><img src="https://res.cloudinary.com/dyd911kmh/image/upload/f_auto,q_auto:best/v1582234331/sql14_g9x79e.png" /></center>

<ul>
<li>Now you will be in the installation progress mode, wait for a while, and let the installation complete. Once the installation is complete, you will receive an <code>Installation successful</code> in the detail box. Feel free to close the SQL server setup window.</li>
</ul>
<center><img src="https://res.cloudinary.com/dyd911kmh/image/upload/f_auto,q_auto:best/v1582234331/sql15_y6ta5f.png" /></center>

<ul>
<li>Now coming back to the SQL Server installation center, you need to install the <code>SQL server management studio</code>, which provides you a graphical user interface (GUI) for connecting to the database, creating a database, tables, and a lot more. To install the studio, you need to click the <code>SQL server management tools</code>, which is the third option.</li>
<li>By clicking the <code>SQL server management tools</code>, you will be redirected to the Microsoft website from where you can download the SQL server management studio. It can also be downloaded from the same website from where you initially downloaded the SQL server 2019 developer edition.</li>
</ul>
<center><img src="https://res.cloudinary.com/dyd911kmh/image/upload/f_auto,q_auto:best/v1582234331/sql16_tzo4x8.png" /></center>

<ul>
<li>Once the installation is complete, you should see a file named <code>SSMS-Setup-ENU</code> in your downloaded folder. Double click on that file and select <code>Yes</code>. Then click on <code>Install</code>, it will take some time for it to complete again depending upon your internet connection. You might be asked to restart your system for the installation to complete. Once the setup is complete, click on close.</li>
</ul>
<center><img src="https://res.cloudinary.com/dyd911kmh/image/upload/f_auto,q_auto:best/v1582234331/sql17_kojzza.png" /></center>

<ul>
<li>Finally, you can close the <code>SQL server installation center</code>. Go to windows start and search for <code>Microsoft SQL Server Management Studio</code>, and you should be able to find it, once you open it the UI should look similar to one shown below:</li>
</ul>
<center><img src="https://res.cloudinary.com/dyd911kmh/image/upload/f_auto,q_auto:best/v1582234331/sql18_lv6o8v.png" /></center>

<ul>
<li>It will show you a <code>connect to server</code> option with multiple parameters like Server Type, Server Name, Authentication, etc. Click on <code>server name</code> and select <code>browse for more</code> in that select <code>Database engine</code>. Once you select <code>Database Engine</code> it would show you the instance name you had created in instance configuration, click ok.</li>
</ul>
<center><img src="https://res.cloudinary.com/dyd911kmh/image/upload/f_auto,q_auto:best/v1582234331/sql19_kgohpp.png" /></center>

<ul>
<li>Then in the <code>Authentication</code>, select <code>SQL Server authentication</code>. It&#39;s important to note that the login will be default name i.e., <code>sa</code>, and the password will be the same as you had created in the earlier steps.</li>
</ul>
<center><img src="https://res.cloudinary.com/dyd911kmh/image/upload/f_auto,q_auto:best/v1582234331/sql20_cazamw.png" /></center>

<center><img src="https://res.cloudinary.com/dyd911kmh/image/upload/f_auto,q_auto:best/v1582234332/sql21_ijce5q.png" /></center>

<ul>
<li>As a final step, just click on <code>Connect</code>. Once connected, you should see the <code>Datacamp_SQL</code> server that you had created listed on the <code>object explorer</code> panel, which means that you have successfully established a connection with your local SQL server. And you are all set to create a database, add, delete and insert in it.</li>
</ul>
<center><img src="https://res.cloudinary.com/dyd911kmh/image/upload/f_auto,q_auto:best/v1582234332/sql22_qxes1d.png" /></center>

Awesome, so you were successful in installing SQL Server. Enjoy learning SQL!
<h2 id="conclusion">Conclusion</h2>
Congratulations on finishing the tutorial.
This tutorial should take you one step closer to learning SQL in a more practical sense since your environment is set up now.
Please feel free to ask any questions related to this tutorial in the comments section below.
If you would like to learn about SQL from basic to an advanced level, take DataCamp&#39;s <a href="https://www.datacamp.com/tracks/sql-fundamentals">SQL Fundamentals</a> skill track.

https://www.datacamp.com/community/tutorials/how-to-install-sql-server

In this tutorial, you will learn how to install SQL Server on a Windows operating system with a brief introduction to SQL in general.

(Tutorial) How to Install SQL Server

How to Install SQL Server

<h2 id="pdf-documents">PDF Documents</h2>
PDF is a Portable Document Format where it contains texts, images, charts, etc. which is different from plain text files. It is a file that contains the &#39;.pdf.&#39; extension and was invented by Adobe. This type of file is independent of any platforms like software, hardware, and operating systems.
<h2 id="steps-to-install-package-">Steps to Install-Package:</h2>
<ol>
<li>You need to install a package named &quot;pypdf2&quot; which can handle the file with &#39;.pdf&#39; extension.
<img src = "https://i.imgur.com/vzhJM3Q.png" />
</li>
<li>You can see the &#39;pypdf2&#39; package is installed and shown below.
<img src ="https://i.imgur.com/wvEAm3B.png">
</li>
</ol>
<h2 id="reading-pdf-documents-and-extracting-a-data">Reading PDF documents and Extracting a data</h2>
You will be extracting only the text from the pdf file as PyPDF2 has a limitation when it comes to extracting the rich media content. The logos, pictures, etc. couldn&#39;t be extracted from it — the following pdf file needs to be download to work with this tutorial. 
<a href = "https://drive.google.com/file/d/1jEuyqKKNqeq--SuERYBlurM_XGy1z5He/view?usp=sharing">Download Pdf file</a>
<img src = "https://i.imgur.com/IoNecb9.png" />
The &#39;import&#39; statement in the code above gets the PyPDF2 module. You need to use &#39;open(&#39;pdfFileName&#39; , &#39;openingMode&#39;)&#39;where the &#39;pdfFilename&#39; is &#39;test.pdf&#39;, and the &#39;openingMode&#39; is &#39;rb&#39; which is the reading only in binary format.
<img src = "https://i.imgur.com/o0LPBve.png" />
The PyPDF2 has a method as &#39;PdfFileReader&#39;, which takes the newly created object &#39;pdfFileObject&#39;.You can now access the attribute named &#39;numPages&#39; from &#39;pdfFileObject&#39;, which gives a total number of the pages.
<img src= "https://i.imgur.com/YBL3JEV.png">
The above output is 1.Since; you can see the pdf file is of only one page.
<img src="https://i.imgur.com/oC6TWqV.png">
You can use the &#39;getPage(0)&#39; method inside the pdfReaderObject to get the first page.The result then is stored in the &#39;firstPageObject&#39; where all the text inside that particular page can be printed out by using the &#39;extractText()&#39; method.
<img src="https://i.imgur.com/8bBFHcz.png" width =600>
The above code gives all the text from the pdf file. However, the image is not shown in the terminal, which cannot be obtained using pyPDF2.
<h2 id="merging-multiple-pdf-files-into-one-pdf">Merging multiple PDF files into one PDF</h2>
You will be merging two different pdf files into a single pdf file. The old PDF file is previous that you&#39;ve worked with, whereas a new PDF file can be downloaded from the following link: 
<a href="https://drive.google.com/file/d/1_2r_S0K6wxTjH7dsQz0yHWuKaWGL5VCD/view?usp=sharing">New PDF file</a>.
<img src="https://i.imgur.com/pIKsS1H.png">
You will be importing the PdfFileMerger module from the PyPDF2 package, which helps to merge the pdf files. The &#39;path&#39; is specified, which indicates the path for the folder where the file is located. Also, pdf files to merge are included in &#39;pdf_files&#39; in a list.
<img src="https://i.imgur.com/MNNjURT.png">
You can see the merger object is created using the help of &#39;PdfFileMerger.&#39; The looping is done for each file in a list where merging is done by passing the path and file to the &#39;append&#39; method. At last, the final output can be obtained by using &#39;merger.write()&#39; where the merged content with a new PDF filename is obtained.
<img src="https://i.imgur.com/RizZlFc.png">
The above picture indicates a &#39;merged.pdf,&#39; which consists of the content merged from &#39;test.pdf&#39; and &#39;test-1.pdf&#39;.
<h2 id="word-documents">Word Documents</h2>
The Word documents consist of the &quot;.docx&quot; extension at the end of the filename. These documents don&#39;t only contain text as in plain text files, but it includes a rich-text document. The rich-text document contains the different structures for the document, which have size, align, color, pictures, font, etc. associated with them.
It would be best if you had an application for working with the Word Documents. The popular application for Windows and Mac Operating systems is Microsoft Word, but it is a paid subscription platform. However, there is a free alternative option like &quot;LibreOffice&quot;, which is an application in Linux which comes pre-installed. The applications can be downloaded for <a href = "https://www.libreoffice.org/download/download/"> Windows and Mac Operating systems.</a> This tutorial will use Microsoft Word in the Windows Operating system.
<h2 id="steps-to-install-package-">Steps to Install-Package:</h2>
<ol>
<li>You need to install a package named &quot;python-docx&quot; which can handle the word documents of the &#39;.docx&#39; extension.
<img src = "https://i.imgur.com/IdTL1nH.png" />
</li>
<li>You can see the &#39;python-docx&#39; package installed and shown below.
<img src ="https://i.imgur.com/8YaJGpn.png">
</li>
</ol>
You can code along in the interactive shell provided by Python, but it is preferred to use the Text Editor. So, Sublime Text is used for the coding part of this tutorial.
<h2 id="writing-a-word-documents">Writing a Word Documents</h2>
<img src="https://i.imgur.com/LfliFyr.png" width = 600 height = 600>
You can see above the &#39;document&#39; module is imported from the &#39;docx&#39; package in the first line. The code in the second line produces a new word document through the help of the Document object.The filename is saved as &#39;first.docx&#39; using the &#39;document.save()&#39;.
<h3 id="add-a-heading">Add a heading</h3>
<img src="https://i.imgur.com/hLsCRBu.png" width = 600 height = 600>
The above code contains a &#39;Document()&#39;opens a new file and &#39;document.save(&#39;addHeader.docx&#39;)&#39; is used to create a newly edited docx file. You can add the heading through method &#39;add_heading(&#39;text,&#39; level=number),&#39; which takes the text as a heading, and the heading level from starts from 0 to 4.
<img src="https://i.imgur.com/Uxp7c1B.png" width = 600 height = 600>
The above code gives the output as a newly created &#39;addedHeader.docx&#39; file where level 0 makes a headline with the horizontal line below the text, whereas the heading level 1 is the main heading. Similarly, the other headings are sub-heading with their&#39;s font-sizes in decreasing order.
<h3 id="add-a-paragraph">Add a Paragraph</h3>
<img src="https://i.imgur.com/CuSBhGJ.png" width = 600 height = 600>
The above code contains a &#39;Document()&#39; which opens a new document file and &#39;document.save(&#39;addParagraph.docx&#39;)&#39; is used to create a newly edited docx file. You can add the heading through method &#39;add_paragraph(&#39;text,&#39; style=&#39;required_style&#39;)&#39; which takes the text and also &#39;style&#39; is an optional argument where &#39;List Number&#39; and &#39;List Bullet&#39; can be used.
<img src="https://i.imgur.com/wcIur4j.png" width = 700 height = 700>
The above code gives the output as a newly created &#39;addedParagraph.docx&#39; file where there is a simple paragraph at first line. Similarly, there is a heading, and below it contains an ordered list containing an item with number 1 and 2.Below that there is another heading containing a two item in an unordered bulleted list.
<h3 id="add-a-picture">Add a Picture</h3>
<img src="https://i.imgur.com/BXLgbIr.png" width = 600 height = 600>
The above code contains a &#39;Document(),&#39; which creates a new document file, and &#39;document.save(&#39;addPicture.docx&#39;)&#39; is used to create a newly edited docx file. You can add the image by using &#39;add_picture()&#39; which contains the first parameter as &#39;cat-1.jpeg&#39; is the path for the cat image. The widths and heights are the optional parameters that will be default as &#39;72 dp,&#39; but we have used &#39;Inches&#39; for our purpose.
<img src="https://i.imgur.com/AAalXfY.png" width = 600 height = 600>
The above code gives the output as a newly created &#39;addedPicture.docx&#39; file, which contains a cat image where there are 1.25 inches of width and height in the image.
<h2 id="reading-a-word-documents">Reading a Word Documents</h2>
You&#39;ll now read a sample word document from Python, and it can be found in: 
<a href = "https://docs.google.com/document/d/13oX775JlQRweV02ZpY0_N35eC0CcWkE0fHK4CHaBLLc/edit?usp=sharing">Download Sample</a>.
<img src="https://i.imgur.com/0UbmZav.png" width =600 height =600 />
The first line in the code imports the Document from the &#39;docx&#39; module, which is used to pass the required document file and to create an object .&#39;obtainText&#39; is a function that receives the file &#39;fullText.docx.&#39; The looping is done for each paragraph, which is accessed by &#39;document.paragraphs&#39; and is inserted into an empty list using the &#39;append&#39; method. Finally, the function returns a list of paragraphs ending with a new line.
<img src="https://i.imgur.com/TRUWenI.png" width = 600 height = 600 />
The above output gives the plain text without any style, color, etc. which is not a rich text document.
<h2 id="congratulations">Congratulations</h2>
Congratulation, you&#39;ve finished reading this tutorial.
If you would like to learn more about importing data in Python, try DataCamp&#39;s <a href="https://www.datacamp.com/courses/introduction-to-importing-data-in-python">Introduction to Importing Data in Python</a> course.
You can also look at the following resources to help broaden your knowledge on specific topics. 
<ol>
<li><a href="https://python-docx.readthedocs.io/en/latest/">Documentation of Python Docx</a> </li>
<li><a href = "https://pythonhosted.org/PyPDF2/">Documentation of PyPDF2</a></li>
</ol>
References: 
<a href="https://automatetheboringstuff.com/chapter13/">Automate Boring Stuff With Python: Working with Word Documents</a>

https://www.datacamp.com/community/tutorials/reading-and-editing-pdfs-and-word-documents-from-python

This tutorial will allow you to read PDF documents and merge multiple PDF files into one PDF file. It will also show how to read and write word documents from Python.

(Tutorial) Reading and Editing PDF’s and Word Documents From Python

Reading and Editing PDF’s and Word Documents From Python

https://www.datacamp.com/community/tutorials/utilities-in-r

Learn about several useful functions for data structure manipulation, nested-lists, regular expressions, and working with times and dates in the R programming language.

Learn about several useful functions for DATA structure manipulation, nested-lists, REGULAR EXPRESSIONS, and working with times and dates in the R PROGRAMMING language.

(Tutorial) Utilities in R

Utilities in R

Django is a widely used free, open-source, and high-level web development framework. It provides a lot of features to the developers &quot;out of the box,&quot; so development can be rapid. However, websites built from it are secured, scalable, and maintainable at the same time.
<h2 id="goal">Goal</h2>
The goal of this tutorial is to build a blog application where the blog content can be created and updated through an administration panel. Blog contents are displayed on the page and can be deleted if needed.Overall application provides CRUD(Create,Read,Update,Delete) functionality. 
This tutorial doesn&#39;t use any FrontEnd technologies like Javascript, CSS, etc. but focuses on basic yet essential concepts that are needed in every Django Web Development.
<h2 id="required-setup">Required Setup</h2>
<ol>
<li>Git Bash: The user of all operating systems can use it. All the Django related commands and Unix commands are done through it. For downloading the Git bash: <a href="https://git-scm.com/downloads">Click Me</a>.</li>
<li>Text-Editor: Any Text-Editor like Sublime Text or Visual Studio Code can be used. For the following project, <a href="https://www.sublimetext.com/">Sublime Text</a> is used.</li>
<li>Python 3: The latest version of Python can be downloaded in <a href="https://www.python.org/downloads/">Download Python</a>.</li>
</ol>
Note: You can easily follow along with this tutorial if you understand the basics of Python and know about loops, function, classes, etc., and some knowledge of bash or command line.
<h2 id="virtual-environment">Virtual Environment</h2>
Virtual Environment acts as dependencies to the Python-related projects. It works as a self-contained container or an isolated environment where all the Python-related packages and the required versions related to a specific project are installed. Since newer versions of Python, Django, or packages, etc. will roll out, through the help of a Virtual Environment, you can work with older versions that are specific to your project. In Summary, you can start an independent project related to Django of version 2.0, whereas another independent project related to Django of version 3.0 can be started on the same computer. 
Note: There are many ways of creating a Virtual Environment, but only one way is shown below.
<h2 id="steps-to-create-a-virtual-environment">Steps to create a Virtual Environment</h2>
<ol>
<li>You can create the new directory named &#39;project-blog&#39; by using &#39;mkdir&#39; command in your Desktop.</li>
<li>Change the directory to &#39;project-blog&#39; by using &#39;cd&#39; command.
 <img src="https://i.imgur.com/GfvSQUj.png"> 
</li>
<li>The virtual environment is created by using &#39;python -m venv env&#39;, where env is our virtual environment shown by &#39;ls&#39; command.
 <img src="https://i.imgur.com/CbBq40I.png"> 
</li>
<li>For Activating your Virtual Environment:
The Virtual Environment can be activated by using the &#39;source&#39; command where the &#39;Scripts&#39; folder needs to be enabled or activated.
 <img src="https://i.imgur.com/Gu15w7W.png"> 
The &#39;env&#39; will be shown in the parenthesis if you&#39;ve successfully activated your Virtual Environment. 
</li>
<li>Installing the required package:
You can use &#39;pip install django&#39; to install Django in your specific Virtual Environment.
 <img src="https://i.imgur.com/PgLbUsT.png"> </li>
</ol>
Note: Linux and Mac users need to use &#39;python3&#39; specifically in the command because Python of version 2 is already pre-installed in their computer. Also, It is preferable to use version 3 as of now Python will not support version 2 after the year 2020.
<h2 id="creating-a-django-project">Creating a Django Project</h2>
<ol>
<li>The first step is creating your project by using the &#39;django-admin startproject <code>project_name</code>&#39; command, where &#39;project_name&#39; is &#39;django_blog&#39; in your case. Also, it will generate a lot of files inside our newly created project, which you can research further in <a href="https://docs.djangoproject.com/en/3.0/intro/tutorial01/">Django documentation </a> if needed.
 <img src="https://i.imgur.com/abCcs9y.png"> </li>
<li>Change the directory to the newly created project using &#39;cd&#39; command and to view the created file using &#39;ls&#39; command.
 <img src="https://i.imgur.com/81EkZNS.png"> </li>
<li>You can run your project by using &#39;python manage.py runserver&#39;.
 <img src="https://i.imgur.com/zLcoMn5.png"> </li>
<li>The project can be viewed in your favorite browser (Google Chrome, Mozilla Firefox, etc.).You can come into your browser and type &#39;localhost:8000&#39; or &#39;127.0.0.1:8000&#39; in the URL, as shown below.
 <img src="https://i.imgur.com/wOA4abG.png"> 
Note: To get the same page as above, the server in the bash needs to be running in the background. Also, you can manually stop the server if needed by hitting &#39;Ctr+C&#39; in Windows/Linux and &#39;Cmd+C&#39; in Mac.</li>
</ol>
<h2 id="starting-the-new-project">Starting the new Project</h2>
For creating a new project in the Django, it&#39;s always a two-step process, which is shown below.
<ol>
<li>The first step is to create an app by using &#39;python manage.py startapp <code>app_name</code>&#39; command, where app_name is &#39;blog&#39; in your case.
In Django, there are many apps to the single project where each app serves as single and specific functionality to the particular project.
 <img src="https://i.imgur.com/sr5TjIf.png"> </li>
<li>The second step is to make our project let know about our newly created app by making changes to the &#39;django_blog/settings.py&#39; INSTALLED_APP section.
 <img src="https://i.imgur.com/fwaWBa1.png"></li>
</ol>
<h2 id="changing-in-our-models">Changing in our Models</h2>
Django uses &#39;SQLite&#39; as the default database, which is light and only used for small projects, which is fine for this project.
It uses &#39;Object Relational Mapper(ORM)&#39; which makes it really easy to work with the database. The actual database code is not written, whereas the database tables are created through the help of &#39;class&#39; keyword in &#39;models.py&#39;.
Inside &#39;blog/models.py&#39;, you need to create a new model named &#39;Post&#39;. This is a class that will become a database table afterward which currently inherits from &#39;models.Model&#39;. As in a standard blog, a certain &#39;Post&#39; contains a title, which will be a field called CharField. It is a text-based column and accepts mandatory argument as &#39;max_length&#39;, which happens to be 50 in your case. Also, there is another field named &#39;content&#39;, which is the TextField, which contains the detail text of the &#39;Post&#39; as in a standard blog.
The double underscore(&#39;str&#39;) method is defined, which overrides the field &#39;title&#39; and returns the name of actual &#39;title&#39; instead of some objects.
 <img src="https://i.imgur.com/od9GmHw.png">
<h3 id="making-a-migrations">Making a Migrations</h3>
&#39;python manage.py makemigrations&#39; is a first step process which reads the &#39;models.py&#39; after it&#39;s creation. It creates a new folder called &#39;migrations&#39; where there is a file named &#39;0001_initial.py&#39;, which are portable across the database.
 <img src="https://i.imgur.com/Ab0weiT.png">
<h3 id="migrating-to-the-database">Migrating to the database</h3>
This is the second step where &#39;python manage.py migrate&#39; reads the newly created folder &#39;migrations&#39; and creates the database, and it evolves the database when there is a change in the model.
 <img src="https://i.imgur.com/zh5hYWe.png">
<h3 id="registering-to-the-admin">Registering to the admin</h3>
Let&#39;s move to &#39;blog/admin.py&#39; and do an import of the models called &#39;Post&#39; by using &#39;from .models import Post&#39;. To register models to the admin, the command is &#39;admin.site.register(Post)&#39;.
 <img src="https://i.imgur.com/z7WQZD3.png">
<h3 id="creating-superuser-and-viewing-in-the-administration-panel">Creating SuperUser and Viewing in the Administration panel</h3>
You need to create a SuperUser before accessing the &#39;admin&#39; panel. To do so, use &#39;winpty python manage.py createsuperuser&#39;.
 <img src="https://i.imgur.com/k2JLU52.png"> 
Note: winpty is bash specific command used for communicating with Windows Console Programs. 
Run your server in the background in bash by command python manage.py runserver. Head over to the browser and type the following in the URL.
 <img src="https://i.imgur.com/ZEv8Qgv.png"> 
Fill out your details afterward, i.e., the username and password that you&#39;ve created earlier:
 <img src="https://i.imgur.com/lWGLVzw.png"> 
View your admin panel afterward with our newly created models &#39;Post&#39;.
 <img src="https://i.imgur.com/VVMr1EV.png"> 
Change the content of the &#39;Post&#39; by clicking the &#39;Add&#39; button. Fill out the information and &#39;Save&#39; the detail.
 <img src="https://i.imgur.com/To8du5O.png">
<h3 id="changing-in-views-and-urls">Changing in views and urls</h3>
Move to &#39;blog/views.py&#39; and make the changes as shown below. Add the function &#39;blog_list&#39;, which takes in the request. The query is made, which gets all the objects created using &#39;Post.objects.all()&#39; and save it to the post. There is a newly created dictionary as &#39;context&#39; where the object can be passed as key and obtained through template &#39;blog-list.html&#39;, which is done by returning the response with the help of render.
 <img src="https://i.imgur.com/XyzzrE2.png"> 
Make a new file called &#39;urls.py&#39; in &#39;django_blog/blog&#39; and add the following changes. There is relative import to the views &#39;blog_list&#39; also a &#39;urlpatterns&#39;, which is a list of the path to a specific page on the website. Currently, the <b'path' contains the empty string and name of the view.
 <img src="https://i.imgur.com/tkScSfm.png"> 
Let&#39;s move to &#39;django_blog/urls.py&#39; and import include and make a change to &#39;urlpatterns&#39;. Then add the path to your app URLs through include. Also, when users route through &#39;posts/&#39; then, it gets directed to our &#39;blog.urls.&#39;
<h3 id="making-and-changing-the-templates">Making and Changing the Templates</h3>
Let&#39;s make a templates folder that generally holds the &#39;HTML&#39; and contains their own templating language called &#39;Jinja2&#39;.The folder needs to name &#39;templates/blog/blog_list.html&#39;, which is the convention.
 <img src="https://i.imgur.com/ceM1ffK.png"> 
You can see below there is syntax related to &#39;HyperTextMarkup Language(HTML) where &#39;h1&#39; for big headline and an unordered list(ul) with list element li. Also, &#39; for&#39; loop syntax related to &#39;Jinja 2&#39; is used where an object called &#39;blog_list&#39; passed as key from &#39;blog/views.py&#39; with each element called &#39;list&#39; is iterated.
 <img src="https://i.imgur.com/dt5UOJC.png"> 
View the &#39;title&#39; named as &#39;First Post&#39; on the webpage.
 <img src="https://i.imgur.com/5wMbeRT.png"> 
Let&#39;s add another information from the admin panel the same as above and name your second post title as &#39;Second Post.&#39;
 <img src="https://i.imgur.com/JF96yQl.png"> 
After adding the information and reloading the homepage, the information will be updated.
 <img src="https://i.imgur.com/KSaxElq.png">
<h3 id="details-for-each-individual-post">Details for Each Individual post</h3>
You will be creating each individual page containing information regarding the post title, and it&#39;s content. The &#39;url&#39; will be &quot;localhost:8000/posts/&#39;id&#39;&quot; where id indicates the unique number or primary key attached to each &#39;Post&#39; given by Django itself. 
Let&#39;s create a function as &#39;blog_detail&#39; in &#39;blog/view.py&#39; , which accepts id as a parameter. Also, there is a query made for getting specific id only and saving to &#39;each_post&#39;. Similarly, as above, the information needed is passed as context to the &#39;blog_detail.html&#39;.
 <img src="https://i.imgur.com/lEc6Tcb.png"> 
The url in &#39;blog/urls.py&#39; is changed where path contains the &#39;<code>&lt;id&gt;</code>&#39;, which accepts the unique id in the integer form. Assume that the user comes to &#39;posts/&#39; only then sees all the posts, but when they to &#39;posts/1&#39;, they only see the information regarding the first created post.
 <img src="https://i.imgur.com/gOqq4xb.png"> 
Let&#39;s create a new file, &#39;blog/blog_detail.html&#39;, and make the following changes. Since blog_detail is passed as context, the &#39;title&#39; and &#39;content&#39; can be accessed using dot notation.
 <img src="https://i.imgur.com/tzSxKPm.png"> 
Head over to the URL of your browser and type the same thing to get individual posts. Since the &#39;id&#39; for the first information created is &#39;1&#39; where the second information is to be &#39;2&#39; and so on for newly created information.
 <img src="https://i.imgur.com/CyPpbm3.png">
<h3 id="deleting-the-post">Deleting the Post</h3>
Let&#39;s define the blog_delete, which takes in the request and the id. Also, query is made where &#39;Post.objects.get(id=id)&#39; gets the object with a unique id and save it to each_post. After that the &#39;each_post.delete()&#39; is called to delete the &#39;Post&#39;.Finally HttpResponseRedirect is imported from the &#39;django.http&#39; module where it is used to redirect the page to the &#39;/posts/&#39;
 <img src="https://i.imgur.com/GzPTVdH.png"> .
In the &#39;urls.py&#39; import &#39;blog_delete&#39; and path is set to &#39;&lt;id&gt;/delete&#39; where the id with delete at the end will remove that particular object or information.
 <img src="https://i.imgur.com/TX2GuFL.png"> 
Let&#39;s delete our post by typing the following thing in the &#39;urls.py&#39;.
 <img src="https://i.imgur.com/0xHgfzl.png"> 
At last, the page gets redirected to &#39;/posts&#39; when &#39;posts/1/delete/&#39; is called where only one post exists on the homepage.
 <img src="https://i.imgur.com/O8Jb9rJ.png">
<h2 id="conclusion">Conclusion</h2>
Congratulations on finishing the tutorial!
You&#39;ve learned the basics of the Django Web Development and know about the CRUD functionality. Also, for more details in a particular topic head over to the <a href="https://docs.djangoproject.com/en/3.0/">Django Documentation.</a>
References:
<ul>
<li><a href="https://www.youtube.com/watch?v=_04toQWN5-8">Just Django</a></li>
<li><a href="https://developer.mozilla.org/en-US/docs/Learn/Server-side/Django/Introduction">Mozilla Django Introduction</a></li>
</ul>

https://www.datacamp.com/community/tutorials/web-development-django

Learn about the basics of web development using Django to build blog applications that have the (CRUD) Create, Read, Update, Delete functionality.

Learn about the basics of WEB DEVELOPMENT using DJANGO to build blog applications that have the (CRUD) Create, Read, Update, Delete functionality.

(Tutorial) Django Web Development in Python

Django Web Development in Python

https://www.datacamp.com/community/tutorials/conditionals-and-control-flow-in-r

Learn about relational operators for comparing R objects and logical operators for combining boolean TRUE and FALSE values. You'll also construct conditional statements.

Learn about RELATIONAL operators for comparing R OBJECTS and LOGICAL operators for combining boolean TRUE and FALSE values. You'll also construct CONDITIONAL statements.

(Tutorial) Conditionals and Control Flow in R

Conditionals and Control Flow in R

https://www.datacamp.com/community/tutorials/data-types-in-r

Learn about data types and their importance in a programming language. More specifically, learn how to use various data types like vector, matrices, lists, and dataframes in the R programming language.

Learn about data types and their importance in a programming language. More specifically, learn how to use various data types like VECTOR, MATRICES, LISTS, and DATAFRAMES in the R programming language.

(Tutorial) Data Types in R

Data Types in R

<center><a href="https://s3.amazonaws.com/assets.datacamp.com/email/other/Python+vs+R.pdf"><img src="https://res.cloudinary.com/dyd911kmh/image/upload/f_auto,q_auto:best/v1603467084/Tutorial__R_or_Python_for_Data_Analysis_fkkn9s.png" /></a></center> 
It&#39;s hard to know whether to use Python or R for data analysis. And that’s especially true if you&#39;re a newbie data analyst looking for the right language to start with.
But it is possible to figure out the strengths and weaknesses of both languages. One language isn’t better than the other—it all depends on your use case and the questions you’re trying to answer: What should I use for machine learning? I need a fast solution, so should I use Python or R?
Python vs. R for Data Analysis
At DataCamp, we often get emails from learners asking whether they should use Python or R when performing their day-to-day data analysis tasks. Both Python and R are among the most popular languages for data analysis, and each has its supporters and opponents. While Python is often praised for being a general-purpose language with an easy-to-understand syntax, R&#39;s functionality was developed with statisticians in mind, thereby giving it <a href="http://www.quora.com/Which-is-better-for-data-analysis-R-or-Python">field-specific advantages</a> such as great features for data visualization.
Our infographic &quot;When Should I Use Python vs. R?&quot; is for anyone interested in how these two programming languages compare to each other from a data science and analytics perspective, including their unique strengths and weaknesses. Click the image below to download the infographic and access the embedded links.
<center><a href="https://s3.amazonaws.com/assets.datacamp.com/email/other/Python+vs+R.pdf"><img src="https://res.cloudinary.com/dyd911kmh/image/upload/f_auto,q_auto:best/v1603890265/Python_vs_R_zerop6.pdf" /></a></center> 
For additional insight into these languages, read our blog post on <a href="https://www.datacamp.com/community/blog/when-to-use-python-or-r">Python vs. R for Data Science: What’s the Difference?</a> To explore these languages for yourself, try our <a href="https://www.datacamp.com/courses/intro-to-python-for-data-science/">Introduction to Python</a> and <a href="https://www.datacamp.com/courses/free-introduction-to-r/">Introduction to R</a> courses.

https://www.datacamp.com/community/tutorials/r-or-python-for-data-analysis

Wondering whether you should use Python or R for data analysis? You’ve come to the right place. 

(Tutorial) Choosing Python or R for Data Analysis? An Infographic

Choosing Python or R for Data Analysis? An Infographic

A Time series is a string of data points framed or indexed in particular time periods or intervals. More specifically, it is an ordered series of data points for a variable taken at successive equally spaced out points in time. Time series analysis consists of techniques for examining and analyzing time series data in order to bring out eloquent insights from the data. It assists in acquiring an understanding of the underlying forces in the data points, which are leading to a particular trend. This further helps in predicting future data points. This is achieved by creating a model based on the previous data points in order to predict future data points.
There are mainly four factors or elements which are responsible for any variation in time series data. These factors are commonly known as components of time series analysis, and they are as follows:
<ul>
<li>Trends</li>
<li>Seasonal Movements</li>
<li>Cyclic Movements</li>
<li>Random or Irregular Movements</li>
</ul>
Some of the domains where time series can be applied are - sales forecasting, stock market analysis, inventory management, weather analysis, trend identification, etc. As suggested, before applying any tests on time series data, it is advisable to analyze the data graphically.
In this tutorial, you are going to learn time series analysis, and the following topics will be covered:
<ul>
<li>ACF and PCF</li>
<li>Moving Averages</li>
<li>Moving Average in Spreadsheets</li>
<li>Holt Linear</li>
<li>Holt Linear in Spreadsheets</li>
<li>Conclusion</li>
</ul>
<h2 id="acf-and-pcf">ACF and PCF</h2>
As the name suggests, Autocorrelation is the linear dependence of a variable with itself at two different data points in time. This function is used to determine how well the present value of the series is related to its past values. ACF takes into consideration all of the components for time series, which are - trends, seasonality, cyclic, and random (residual) while finding correlations. Hence, it’s a complete auto-correlation plot. The ACF is a good way to confirm any positive or negative trend; for a positive trend, you will see the ACF will never be going down.
Another way to determine the linear relationship between any two variables is by partial autocorrelation function. Another way to measure the correlation between two random terms x and xt-1 is to only focus on the portion of correlation, which is explained by xt and xt+1 of and eliminating the linear impact of the random variables that fall in between, xt+1,...., xt+n and then determine the correlation of the transformed random variables. This process is termed as partial autocorrelation function.
<h2 id="moving-averages">Moving Averages</h2>
Moving averages smooth the time series data to give a clear indication of where the trend is following. Moving averages help smooth the data by eliminating the noise. For calculating the moving average, you will be taking the arithmetic mean of a variable of the data. There are two types of moving averages, and they are as follows:
<ul>
<li>Simple Moving Average: Simple moving average is calculated by taking the arithmetic mean of a given set of values. For example, to calculate a basic 5-day moving average of closing prices, you would add up the closing prices from the past 5 days and then divide the result by 5. One of the key functions of the moving average is to determine the trends (<a href="https://www.coursehero.com/file/p23kn7uv/has-a-corresponding-Hadoop-Distributed-File-System-HDFS-directory-Each-table/">Source</a>).</li>
</ul>
<center><img src="https://res.cloudinary.com/dyd911kmh/image/upload/f_auto,q_auto:best/v1578504461/image_1_q1bsdg.png" /></center><center><a href="https://otexts.com/fpp2/moving-averages.html">Source</a></center>&nbsp;

Where, m = 2k+1. That is, the estimate of the trend-cycle at time t is obtained by averaging values of the time series within k periods of t (<a href="https://otexts.com/fpp2/moving-averages.html">Source</a>).

 Day 1 - 30 
 Day 2 - 50 
 Day 3 -100 
 Day 4 - 40 
 Day 5 - 35 

 Simple Moving Average = 30 + 50 +100 + 40 + 35 / 5 

 = 255/5 

 = 51
- Exponential Moving Average: The exponential moving average (EMA) is a type of moving average (MA) that gives weight and emphasizes on the latest data points because simple moving averages can be manipulated if there exists a data point with spikes. Thus, the exponential moving average is also known as the exponentially weighted moving average. For example—considering the above data if you want to calculate you would be using the following formula:

 For a given series of n, Where N = 5, 

 EMA = [Last Value in the series - Second last Value ] (2 / n+1) + Second Last Value, 

 EMA = (35 - 40) (2 / 6) + 40 

 EMA = 35.33

<h2>Moving Average in Spreadsheets</h2>

Applying Simple Moving average to Electric Sales data. Let&#39;s compute the 3MA or 3-Moving Average:

1. Let’s first plot the data and see the trend.

<center><img src="https://res.cloudinary.com/dyd911kmh/image/upload/f_auto,q_auto:best/v1578504461/image_2_dgst9m.png" /></center>

&nbsp;2. Add a column named Three Moving Average(3MA) and apply the formula. For 3 MA, k value would be -1, 0, 1. You take the average of three terms previous term, current term, and the next term. For the first and last term, 3MA cannot be calculated because there’s no previous term and following term, which we can consider.
&nbsp;3. We will apply the function in C3,=AVERAGE(B2: B4). This will give the value of 3 MA.
<center><img src="https://res.cloudinary.com/dyd911kmh/image/upload/f_auto,q_auto:best/v1578504461/image_3_r2kx5f.png" /></center>

&nbsp;4. Copy and paste this formula from cell C4 to C20. You will have values.
<center><img src="https://res.cloudinary.com/dyd911kmh/image/upload/f_auto,q_auto:best/v1578504462/image_4_rya9ck.png" /></center>

&nbsp;5. Now select the data and 3MA columns and plot time series. For plotting in the same graph, go to select data and add a series name 3MA. Deselect the 1st and 20th entry because, in 3MA, these values are zero and click on ok.
<center><img src="https://res.cloudinary.com/dyd911kmh/image/upload/f_auto,q_auto:best/v1578504461/image_5_zbj4wr.png" /></center>

Similarly, you can do for 5 MA, 7MA, etc.
<h2 id="holt-linear">Holt Linear</h2>
Until now, you have seen various methods for forecasting, but you can see that these models don’t work well on data with high variations. For instance, if you want to predict the price of bitcoin in the future, which is increasing currently, using the methods stated above wouldn’t be a good option.
If you use any of the above methods, these methods won’t consider the trend. Trend, as discussed earlier, is the component of time series data, that represents the long term movement of a time series. Thus, you require a method that can determine the trend precisely without any assumptions. Hence, you will be using Holt’s Linear Trend method.
Holt’s Linear Method is also known as the Double Exponential Smoothing Technique. This method comprises of three equations which are a forecast equation and two smoothing equations,
<center><img src="https://res.cloudinary.com/dyd911kmh/image/upload/f_auto,q_auto:best/v1578504461/image_6_r4okcx.png" /></center>

For the first equation, lt is representing the evaluation of the level of time series at time t and bt is representing the evaluation of the slope of the time series at time t.
For the second equation and determining the trend of the current data, first determine the trend of the previous period, by adding bt-1 to the last smoothed value lt-1. This helps to eradicate lag and brings lt to the approximate level of the current data. Since the data can have some randomness or error term in it, in order to eradicate that error, the trend is adjusted by smoothing with β ( lt - lt-1 ), the trend in the last period, and adding that to the previous value of the trend. The last equation is used to forecast the final trend.
<h2 id="holt-linear-in-spreadsheets">Holt Linear in Spreadsheets</h2>
Let’s solve this using spreadsheets. You are taking data set from the book “Spyros G. Makridakis, Steven C. Wheelwright, Rob J Hyndman - Forecasting_ Methods and Applications-Wiley (1997)” of holt’s linear method.
<ol>
<li>To initialize the process, you require two estimates—one to get first smoothed values for L1 and the other for the value of trend b1. One alternative is to set L1 = Y1 and b1 = Y2-Y1 or (Y4-Y1)/3.
</li>
<li>At initial level you considered α = 0.501 and β = 0.072. These you need to optimize. Optimization can be done with MSE (Mean Squared Error) at whatever α and β values you get minimum MSE, consider that as your hyperparameter values.
</li>
<li>Let’s put these formulas into excel to get the forecasted values. At lag 1 (means m = 1) in third equation.
</li>
</ol>
<center><img src="https://res.cloudinary.com/dyd911kmh/image/upload/f_auto,q_auto:best/v1578504462/image_7_jsijd4.png" /></center>

<ol>
<li>As for the initial stage L1 = Y1 and b1 = Y2 – Y1. Let’s assign these values in excel.</li>
</ol>
<center><img src="https://res.cloudinary.com/dyd911kmh/image/upload/f_auto,q_auto:best/v1578504461/image_8_uun8bf.png" /></center>

<center><img src="https://res.cloudinary.com/dyd911kmh/image/upload/f_auto,q_auto:best/v1578504461/image_9_c2jaca.png" /></center>

<ol>
<li>Let’s use the formulas to calculate values for L2, b2, and F2.</li>
</ol>
<center><img src="https://res.cloudinary.com/dyd911kmh/image/upload/f_auto,q_auto:best/v1578504461/image_10_k2hjbl.png" /></center>

<center><img src="https://res.cloudinary.com/dyd911kmh/image/upload/f_auto,q_auto:best/v1578504461/image_11_dgz8eb.png" /></center>

<center><img src="https://res.cloudinary.com/dyd911kmh/image/upload/f_auto,q_auto:best/v1578504462/image_12_qvszoy.png" /></center>

<ol>
<li>Now copy and paste all three formulas till the end of the data available in the file.</li>
</ol>
<center><img src="https://res.cloudinary.com/dyd911kmh/image/upload/f_auto,q_auto:best/v1578504462/image_13_lbejd6.png" /></center>

You will have all these values. Now, if you want to forecast for the 25th period, we should consider m = 1 and if for 26th we should consider m = 2 and so on.
<ol>
<li>Let’s calculates forecast values at different periods. </li>
</ol>
for m = 1,
<center><img src="https://res.cloudinary.com/dyd911kmh/image/upload/f_auto,q_auto:best/v1578504462/image_14_rrhmvl.png" /></center>

For m=2,
<center><img src="https://res.cloudinary.com/dyd911kmh/image/upload/f_auto,q_auto:best/v1578504462/image_15_qisppz.png" /></center>

Similarly, you can calculate at different periods.
<center><img src="https://res.cloudinary.com/dyd911kmh/image/upload/f_auto,q_auto:best/v1578504462/image_16_chqc6j.png" /></center>

<h2 id="conclusion">Conclusion</h2>
Congratulations, you have made it to the end of this tutorial!
In this tutorial, you have covered a lot of details about the time series analysis. You have learned ACF and PCF, moving averages, moving averages in spreadsheets, Holt Linear, and Holt Linear in spreadsheets.
Hopefully, you can now utilize the time series analysis concepts to test the hypothesis. Thanks for reading this tutorial!
If you would like to learn more in spreadsheets, check out DataCamp&#39;s <a href="https://www.datacamp.com/courses/statistics-in-spreadsheets">Introduction to Statistics in Spreadsheets</a> course.

https://www.datacamp.com/community/tutorials/time-series-analysis-with-spreadsheets

In this tutorial, you'll learn basic time-series concepts and basic methods for forecasting time series data using spreadsheets.

(Tutorial) Time Series Analysis with Spreadsheets

Time Series Analysis with Spreadsheets

https://www.datacamp.com/community/tutorials/simplifying-sentiment-analysis-python

Learn the basics of sentiment analysis and how to build a simple sentiment classifier in Python.

Learn the basics of SENTIMENT analysis and how to build a simple sentiment CLASSIFIER in PYTHON.

(Tutorial) Simplifying Sentiment Analysis in Python

Simplifying Sentiment Analysis in Python

<center>
<a target=“_blank” href="https://www.datacamp.com/learn/python/"><img src="https://res.cloudinary.com/dyd911kmh/image/upload/f_auto,q_auto:best/v1583330891/python_2_wyjjwk.png" /></a>
</center> 
Typically, every novice learns to write a Python script on the command line first, then moves to execute the script from the command line wherein the script is usually written in a text editor and is run from the command line.
Computers cannot understand code in the way humans write it and hence, you need an interpreter between the computer and the human written code. The job of the interpreter is to convert the code into a format that computers can then understand and process.
The interpreter processes the code in the following ways:
<ul>
<li>Processes the Python script in a sequence
</li>
<li>Compiles the code into a byte code format which is a lower-level language understood by the computers.
</li>
<li>Finally, a Python Virtual Machine (PVM) comes into the picture. The PVM is the runtime powerhouse of Python. It is a process that iterates over the instructions of your low-level bytecode code to run them one by one.
</li>
</ul>
Like Scripts, you have a have something called Module which is a Python script imported and used in another Python script.
The Python script is saved with a .py extension which informs the computer that it is a Python program script. Unlike Windows, the Unix based operating systems such as Linux and Mac come with pre-installed Python. Also, the way Python scripts are run in Windows and Unix operating systems differ.
Note: For all users, especially Windows OS users, it is highly recommended that you install <code>Anaconda</code>, which can be downloaded from <a href="https://www.anaconda.com">this website</a>. You can follow along with the instructions given in this <a href="https://www.datacamp.com/community/tutorials/installing-anaconda-windows">DataCamp tutorial</a>, which are specific to Windows operating system.
To install <code>Python3</code> on a Windows operating system, please feel free to check out this <a href="https://www.digitalocean.com/community/tutorials/how-to-install-python-3-and-set-up-a-local-programming-environment-on-windows-10">link</a>.
Command-line interpreter for Python can be accessed on the various operating systems in the following ways:
<ul>
<li>On <code>Windows</code>, the command line is known as the command prompt which can be accessed by clicking the <code>start</code> menu and search for <code>command prompt</code>. Another way is by going to the <code>Run</code> dialog box type <code>cmd</code> and press enter (Start menu $-&gt;$ Run and type cmd). After which, if Python is installed in your C-drive then all you have to do is type C:\python36\python.exe, where python36 is the Python version (Note: This path may vary based on the directory at which Python is configured).</li>
</ul>
<center>
<figure>
<img src="https://res.cloudinary.com/dyd911kmh/image/upload/f_auto,q_auto:best/v1562598150/cmd1_cmgszw.png" />
 <figcaption>(<a href="https://pythonfun.wordpress.com/2012/04/04/installing-pyserial-on-windows-7-with-python3-2/">Source</a>) </figcaption>
</figure>
</center> 

<ul>
<li>On a <code>Mac</code> system, it is very straight-forward. All you need to do is open <code>Launchpad</code> and search for <code>Terminal</code>, and in the terminal, type <code>Python</code> and boom, it will give you an output with the Python version.</li>
</ul>
<center>
<figure>
<img src="https://res.cloudinary.com/dyd911kmh/image/upload/f_auto,q_auto:best/v1562598150/cmd2_jnyyar.png" />
</figure>
</center> 

<ul>
<li>Like the Mac system, accessing terminal on a <code>Linux</code> system is also very easy. Right click on the desktop and click <code>Terminal</code> and in terminal type <code>Python</code> and that&#39;s all!</li>
</ul>
<center>
<figure>
<img src="https://res.cloudinary.com/dyd911kmh/image/upload/f_auto,q_auto:best/v1562598150/cmd3_rmhrog.png" />
 <figcaption>(<a href="https://mbientlab.com/tutorials/LPython3.html">Source</a>) </figcaption>
</figure>
</center> 

Note: In this tutorial, you will be learning using the Mac OS Terminal.
So without further ado, lets get started!
<h3 id="writing-the-python-script-in-terminal">Writing the Python Script in Terminal</h3>
Let&#39;s see how we can code and generate the output in the terminal itself. To accomplish this, first, you will type <code>python3</code>, which means you will be using Python3 version.
After which you can code typically as you would in a <a href="https://www.datacamp.com/community/tutorials/top-python-ides-for-2019">text editor or an IDE</a> (integrated development environment), though you will not be getting the functionalities in the terminal as you would get with an IDE.
You will start with the evergreen <code>Hello, World!</code> example and let&#39;s see how the output looks like in the terminal.
<center>
<figure>
<img src="https://res.cloudinary.com/dyd911kmh/image/upload/f_auto,q_auto:best/v1562598151/cmd4_semikk.png" />
</figure>
</center> 

Isn&#39;t it nice how by just opening the terminal and typing Python3 you can code in Python? Let&#39;s try some more examples.
<center>
<figure>
<img src="https://res.cloudinary.com/dyd911kmh/image/upload/f_auto,q_auto:best/v1562598151/cmd5_jolchp.png" />
</figure>
</center> 

One thing to notice in the above example is, without even typing the <code>print</code> statement you were able to get the output.
Let&#39;s complicate the code a bit and lets you use the <code>NumPy</code> (Numerical Python) library to create two arrays and apply a few mathematical operations on it. For a little background on numpy, it is a Python programming library which has the capability of dealing with large, multi-dimensional arrays and matrices, along with an extensive collection of high-level mathematical functions to operate on these arrays.
<center>
<figure>
<img src="https://res.cloudinary.com/dyd911kmh/image/upload/f_auto,q_auto:best/v1562598151/cmd6_quakfq.png" />
</figure>
</center> 

You can observe from the above figure that using numpy; you were able to create, add, and multiply two numpy arrays within the terminal. One thing to note here is that the <code>multiply</code> function in numpy does an element-wise multiplication while <code>dot</code> function takes the dot product of two matrices. To accomplish the <code>np.dot</code> command, you need to make sure that the <code>columns</code> of the first matrix are equal to the <code>rows</code> of the second matrix and hence, the <code>value error</code>.
<h3 id="running-the-py-script-from-the-terminal">Running the <code>.py</code> script from the Terminal</h3>
Running the Python script from the terminal is very simple, instead of writing the Python script in the terminal all you need to do is use a text editor like vim, emacs or notepad++ and save it with a <code>.py</code> extension. Then, open the terminal and go to the directory where the code resides and run the script with a keyword <code>python</code> followed by the script name.
<center>
<figure>
<img src="https://res.cloudinary.com/dyd911kmh/image/upload/f_auto,q_auto:best/v1562598151/cmd7_tsl72k.png">
</figure>
</center> 

To create the <code>terminal.py</code> file, use <code>vim</code> in the terminal with the program name as <code>vim terminal.py</code> and paste the below code in it. To save the code, press <code>esc</code> key followed by <code>wq!</code>. And finally, to run that script all you need to do is type <code>python3 terminal.py</code> and within less than a second you will see the output as shown above.
The following is the code which was used in the above <a href="http://cs231n.github.io/python-numpy-tutorial/">example</a>.
<pre><code class="lang-python">import numpy as np

x = np.array([[1,2],[3,4]], dtype=np.float64)
y = np.array([[5,6],[7,8]], dtype=np.float64)

# Elementwise sum; both produce the array
# [[ 6.0 8.0]
# [10.0 12.0]]
print(&quot;Output of adding x and y with a &#39;+&#39; operator:&quot;,x + y)
print(&quot;Output of adding x and y using &#39;numpy.add&#39;:&quot;,np.add(x, y))

# Elementwise difference; both produce the array
# [[-4.0 -4.0]
# [-4.0 -4.0]]
print(&quot;Output of subtracting x and y with a &#39;-&#39; operator:&quot;,x - y)
print(&quot;Output of subtracting x and y using &#39;numpy.subtract&#39;:&quot;,np.subtract(x, y))

# Elementwise product; both produce the array
# [[ 5.0 12.0]
# [21.0 32.0]]
print(&quot;Output of elementwise product of x and y with a &#39;*&#39; operator:&quot;,x * y)
print(&quot;Output of element wise product of x and y using &#39;numpy.multiply&#39;:&quot;,np.multiply(x, y))

# Elementwise division; both produce the array
# [[ 0.2 0.33333333]
# [ 0.42857143 0.5 ]]
print(&quot;Output of elementwise division x and y with a &#39;/&#39; operator:&quot;,x / y)
print(&quot;Output of elementwise division x and y using &#39;numpy.divide&#39;:&quot;,np.divide(x, y))

# Elementwise square root; produces the array
# [[ 1. 1.41421356]
# [ 1.73205081 2. ]]
print(&quot;Output of elementwise square root x using &#39;numpy.sqrt&#39;:&quot;,np.sqrt(x))
</code></pre>
<pre><code>Output of adding x and y with a &#39;+&#39; operator: [[ 6. 8.]
 [10. 12.]]
Output of adding x and y using &#39;numpy.add&#39;: [[ 6. 8.]
 [10. 12.]]
Output of subtracting x and y with a &#39;-&#39; operator: [[-4. -4.]
 [-4. -4.]]
Output of subtracting x and y using &#39;numpy.subtract&#39;: [[-4. -4.]
 [-4. -4.]]
Output of elementwise product of x and y with a &#39;*&#39; operator: [[ 5. 12.]
 [21. 32.]]
Output of element wise product of x and y using &#39;numpy.multiply&#39;: [[ 5. 12.]
 [21. 32.]]
Output of elementwise division x and y with a &#39;/&#39; operator: [[0.2 0.33333333]
 [0.42857143 0.5 ]]
Output of elementwise division x and y using &#39;numpy.divide&#39;: [[0.2 0.33333333]
 [0.42857143 0.5 ]]
Output of elementwise square root x using &#39;numpy.sqrt&#39;: [[1. 1.41421356]
 [1.73205081 2. ]]
</code></pre><h3 id="passing-command-line-arguments-to-python-script">Passing Command Line Arguments to Python Script</h3>
Command line arguments make life a lot easier, many times in production-ready code command line arguments are used. It makes the code output reproducibility efficient. For example, let&#39;s say your code has a lot of user inputs or files that are being read, then by using command line arguments you will not have to go into the code to do all of these changes in case you need to change the file name or a variable input.
To accomplish this, you will make use of the <code>sys</code> module, which is an in-built Python module. Within <code>sys</code>, you have <code>argv</code> which gives you the list of command-line arguments passed to the Python program. <code>sys.argv</code> reads the command line arguments as a list of items where the first item/element in that list can be accessed as <code>sys.argv[1]</code> while first argument, i.e., <code>sys.argv[0]</code> is always the name of the program as it was invoked.
Let&#39;s take a simple example and see how it works.
Note: The command line argument is read as a <code>string</code> by Python, so make sure to convert it as an <code>integer</code> in case you are dealing with numbers.
Much like the previous example, save the below lines of code in an editor as <code>command_line.py</code> and to run the code type <code>python3 command_line.py 10</code> where 10 is the command line argument.
<pre><code class="lang-python">import sys
num = sys.argv[1]
for i in range(int(num)):
 print (i)
</code></pre>
<center>
<figure>
<img src="https://res.cloudinary.com/dyd911kmh/image/upload/f_auto,q_auto:best/v1562598152/cmd8_fpvufy.png" />
</figure>
</center> 

<h4 id="what-if-you-do-not-provide-any-command-line-argument-">What if you do not provide any command line argument?</h4>
You will get an error <code>list index out of range</code> which also reinforces that <code>sys.argv</code> reads as a list of items. To avoid such errors, you need <code>exceptional handling</code>, which is out of the scope for this tutorial.
<center>
<figure>
<img src="https://res.cloudinary.com/dyd911kmh/image/upload/f_auto,q_auto:best/v1562598154/cmd9_ks7w3s.png" />
</figure>
</center> 

<h3 id="writing-the-output-of-python-script-to-a-file">Writing the Output of Python Script to a File</h3>
Finally, as a bonus lets see how you can save the output of the Python script in a <code>txt</code> file with using the <code>&gt;</code> key. Yes, one mere character, isn&#39;t that amazing?
You will first create a folder <code>cli</code> and move the <code>command_line.py</code> code in the <code>cli</code> folder. Then, you will check what all is there in that folder, to make sure there is no <code>txt</code> file already existing.
Then, you will type <code>python3 command_line.py 10 &gt; output.txt</code> and finally check the content of the <code>cli</code> folder. Now, you should be able to see the <code>output.txt</code> file.
<center>
<figure>
<img src="https://res.cloudinary.com/dyd911kmh/image/upload/f_auto,q_auto:best/v1562598155/cmd10_l1zfq1.png" />
</figure>
</center> 

Let&#39;s open and see the content of the <code>output.txt</code> file.
<center>
<figure>
<img src="https://res.cloudinary.com/dyd911kmh/image/upload/f_auto,q_auto:best/v1562598155/cmd11_bxv24q.png" />
</figure>
</center> 

Voila! From the above output, you can see that the <code>0-9</code> digits have now been written in a text file using just a <code>&gt;</code> sign.
<h1 id="conclusion">Conclusion</h1>
Congratulations on finishing the tutorial.
There is still a lot to be explored like <a href="https://www.datacamp.com/community/tutorials/gui-tkinter-python">GUI</a> based execution in Python, running Python scripts interactively, running scripts from a file manager or from an IDE. Specific to command line execution you might want to experiment on the Windows <code>command prompt</code> and see how it is different from a Unix based operating system.
Please feel free to ask any questions related to this tutorial in the comments section below.
If you are just getting started in Python and would like to learn more, take DataCamp&#39;s <a href="https://www.datacamp.com/courses/introduction-to-data-science-in-python">Introduction to Data Science in Python</a> course.

https://www.datacamp.com/community/tutorials/running-a-python-script

Learn how you can execute a Python script from the command line, and also how you can provide command line arguments to your script.

Learn how you can run a PYTHON script from the COMMAND-LINE, and also how you can provide command line ARGUMENTS to your script.

(Tutorial) How to Run Python Scripts

How to Run Python Scripts

https://www.datacamp.com/community/tutorials/categorical-data

Learn the common tricks to handle categorical data and preprocess it to build machine learning models!

Learn the common tricks to handle CATEGORICAL data, such as converting to numeric PANDAS or missing data and preprocess it to build MACHINE LEARNING models!

(Tutorial) Handling Categorical Data in Python

Handling Categorical Data in Python

<center>
<a target=“_blank” href="https://www.datacamp.com/learn/python/"><img src="https://res.cloudinary.com/dyd911kmh/image/upload/f_auto,q_auto:best/v1583330891/python_2_wyjjwk.png" /></a>
</center> 
You have probably heard of the nested functions in Python. If you know what that means then understanding inner/nested classes is nothing. We will explore some new things in the Inner or Nested classes here.
<h2 id="sections">Sections</h2>
&nbsp; 1. <a href="#IONC">Inner or Nested Classes</a>
&nbsp; 2. <a href="#WIC">Why Inner Classes</a>
&nbsp; 3. <a href="#CIC">Coding Inner Classes</a>
&nbsp; &nbsp; &nbsp; &nbsp; 3.1. <a href="#MIC">Multiple Inner Classes</a>
&nbsp; &nbsp; &nbsp; &nbsp; 3.2. <a href="#MLIC">Multilevel Inner Classes</a>
<a id="IONC"></a>
<h2 id="1-inner-or-nested-classes">1. Inner or Nested Classes</h2>
Inner or Nested Class is defined inside another class. See the structure of inner or nested classes.
<pre><code class="lang-python">## outer class
class Outer:

 ## inner class
 class Inner:
 pass

 ## multilevel inner class
 class InnerInner:
 pass

 ## another inner class
 class _Inner:
 pass

 ## ...

 pass
</code></pre>
<a id="WIC"></a>
<h2 id="2-why-inner-classes-">2. Why Inner Classes?</h2>
<ol>
<li>Grouping of two or more classes. Suppose you have two classes Car and Engine. Every Car needs an Engine. But, Engine won&#39;t be used without a Car. So, you make the Engine an inner class to the Car. It helps save code.
</li>
<li>Hiding code is another use of Nested classes. You can hide the Nested classes from the outside world.
</li>
<li>It&#39;s easy to understand the classes. Classes are closely related here. You don&#39;t have to search for the classes in the code. They are all together.
</li>
</ol>
Inner or Nested classes are not the most commonly used feature in Python. But, it can be a good feature to implement code. The code is straightforward to organize when you use the inner or nested classes.
<a id="CIC"></a>
<h2 id="3-coding-inner-class">3. Coding Inner Class</h2>
Implementing the inner or nested classes is not difficult. You can see the structure of the code <a href="#IONC">here</a>.
You can access the inner class in the outer class using the self keyword. So, you can quickly create an instance of the inner class and perform operations in the outer class as you see fit. You can&#39;t, however, access the outer class in an inner class. Let&#39;s see an example below.
<pre><code class="lang-python">class Outer:
 &quot;&quot;&quot;Outer Class&quot;&quot;&quot;

 def __init__(self):
 ## instantiating the &#39;Inner&#39; class
 self.inner = self.Inner()

 def reveal(self):
 ## calling the &#39;Inner&#39; class function display
 self.inner.inner_display(&quot;Calling Inner class function from Outer class&quot;)

 class Inner:
 &quot;&quot;&quot;Inner Class&quot;&quot;&quot;

 def inner_display(self, msg):
 print(msg)
</code></pre>
Now, you&#39;ll make the instance of the Outer class and call it&#39;s reveal() method to execute the Inner class method inner_display().
<pre><code class="lang-python">## creating an instance of the &#39;Outer&#39; class
outer = Outer()
## calling the &#39;reveal()&#39; method
outer.reveal()
</code></pre>
<pre><code>Calling Inner class function from Outer class
</code></pre>Let&#39;s see another way to access the inner class. This way is a little less efficient.
<pre><code class="lang-python">Outer().Inner().inner_display(&quot;Calling the Inner class method directly&quot;)
</code></pre>
<pre><code>Calling the Inner class method directly
</code></pre>What if you want to create an instance of the inner class outside the outer class? Can you do that? Yes, let&#39;s see how to make an instance of the inner class outside of the outer class.
<pre><code class="lang-python">outer = Outer()

## instantiating the inner class
inner = outer.Inner() ## inner = Outer().Inner() or inner = outer.inner
inner.inner_display(&quot;Just Print It!&quot;)
</code></pre>
<pre><code>Just Print It!
</code></pre><a id="MIC"></a>
<h3 id="3-1-multiple-inner-classes">3.1. Multiple Inner Classes</h3>
It is a class containing more than one inner class. You can have more than one inner class in a class. As we defined earlier, it&#39;s easy to implement multiple inner classes.
<pre><code class="lang-python">class Outer:
 &quot;&quot;&quot;Outer Class&quot;&quot;&quot;

 def __init__(self):
 ## Instantiating the &#39;Inner&#39; class
 self.inner = self.Inner()
 ## Instantiating the &#39;_Inner&#39; class
 self._inner = self._Inner()

 def show_classes(self):
 print(&quot;This is Outer class&quot;)
 print(inner)
 print(_inner)

 class Inner:
 &quot;&quot;&quot;First Inner Class&quot;&quot;&quot;

 def inner_display(self, msg):
 print(&quot;This is Inner class&quot;)
 print(msg)

 class _Inner:
 &quot;&quot;&quot;Second Inner Class&quot;&quot;&quot;

 def inner_display(self, msg):
 print(&quot;This is _Inner class&quot;)
 print(msg)

 ## ...
</code></pre>
Accessing the classes is the same as we did earlier. See the example for better understanding.
<pre><code class="lang-python">## instantiating the classes

## &#39;Outer&#39; class
outer = Outer()
## &#39;Inner&#39; class
inner = outer.Inner() ## inner = outer.inner or inner = Outer().Inner()
## &#39;_Inner&#39; class
_inner = outer._Inner() ## _inner = outer._outer or _inner = Outer()._Inner()

## calling the methods
outer.show_classes()

print()

## &#39;Inner&#39; class
inner.inner_display(&quot;Just Print It!&quot;)

print()

## &#39;_Inner&#39; class
_inner.inner_display(&quot;Just Show It!&quot;)
</code></pre>
<pre><code>This is Outer class
&lt;__main__.Outer.Inner object at 0x0000021B37962048&gt;
&lt;__main__.Outer._Inner object at 0x0000021B37962160&gt;

This is Inner class
Just Print It!

This is _Inner class
Just Show It!
</code></pre><a id="MLIC"></a>
<h2 id="3-2-multilevel-inner-classes">3.2. Multilevel Inner Classes</h2>
In multilevel inner classes, the inner class contains another class which inner classes to the previous one. You can see the structure of this hierarchy <a href="#IONC">here</a>:
<pre><code class="lang-python">class Outer:
 &quot;&quot;&quot;Outer Class&quot;&quot;&quot;

 def __init__(self):
 ## instantiating the &#39;Inner&#39; class
 self.inner = self.Inner()
 ## instantiating the multilevel &#39;InnerInner&#39; class
 self.innerinner = self.inner.InnerInner()

 def show_classes(self):
 print(&quot;This is Outer class&quot;)
 print(inner)

 ## inner class
 class Inner:
 &quot;&quot;&quot;First Inner Class&quot;&quot;&quot;

 def __init__(self):
 ## instantiating the &#39;InnerInner&#39; class
 self.innerinner = self.InnerInner()

 def show_classes(self):
 print(&quot;This is Inner class&quot;)
 print(self.innerinner)

 ## multilevel inner class
 class InnerInner:

 def inner_display(self, msg):
 print(&quot;This is multilevel InnerInner class&quot;)
 print(msg)

 def inner_display(self, msg):
 print(&quot;This is Inner class&quot;)
 print(msg)

 ## ...
</code></pre>
Let&#39;s see how to instantiate the multilevel inner class.
<pre><code class="lang-python">outer = Outer()

inner = outer.Inner()

## this is &#39;InnerInner&#39; class instance
innerinner = inner.InnerInner() ## innerinner = Outer().Inner().InnerInner()

## let&#39;s call its method inner_display
innerinner.inner_display(&quot;Just Print It!&quot;)
</code></pre>
<pre><code>This is multilevel InnerInner class
Just Print It!
</code></pre><h2 id="conclusion">Conclusion</h2>
I hope you now understand the concept of inner classes. It&#39;s now time for you to experiment with nested classes. Happy Coding :)
If you would like to learn more about classes, take DataCamp&#39;s <a href="https://www.datacamp.com/courses/object-oriented-programming-in-python">Object-Oriented Programming in Python</a> course.

https://www.datacamp.com/community/tutorials/inner-classes-python

In this basic Python tutorial, you'll learn about why and when you should use inner classes.

Learn why and when you should use PYTHON inner/nested CLASSES.

community

datacamp

Tutorials