Wednesday, January 17, 2024

Pandas, Numpy and Matplotlib: Basic Python libraries for Loading data from data files into our Python program.

Install all these three libaraies using the following commands:

pip install pandas 

pip install numpy

pip install matplotlib --user

Now, open the Python interpreter and import each in your Python program as follows:

import pandas as pd

import numpy as np

import matplotlib.pyplot as plt

Now start using each of them in your program as follows:

df = pd.read_csv('location path of the .csv file from which data has to be loaded')



Sunday, January 14, 2024

Data Analytics

Data Analytics


Data helps in 

1) Make better decisions

2) Solve problems by finding the reason for it

3) To evaluate, improve and benchmarking process

4) To understand consumers (their preferences) and the market 


Data Analytics - The scientific process of transforming data into insights for making better decisions.

It is about what will happen in the future and how we can improve it.


Data Analysis - A kind of postmortem analysis - what has happened in the past, why it happened etc.


Types of Data Analytics -

The level of difficulty and value added by it increases from top to bottom.

1) Descriptive Analytics - what happened

2) Diagnostic Analytics - why it happened 

3) Predictive Analytics - what will happen, forecasting trends 

4) Prescriptive Analytics - how can we make it happen


Skill set required to be a good data analyst are:


1) Mathematics 2) Hacking skills (Technology)  3) Business and strategy acumen - Domain knowledge. 

One person may not have all, so we need a group of people working together. 

Why Python? 

It is very simple and versatile programming language with extensive libraries. And it can also be embedded into programs written in other languages. 

It can be used for building many types of applications like: 

1. Desktop apps

2. Web apps

3. Database apps

4. Networking apps

5. Data science 

6. Machine Learning

7. IoT and Embedded Systems

Differenet types of Variables i.e. DATA - can be :

1. Categorical - Defined categories

1. Nominal data: No ranks like Gender, color, etc.

2. Ordinal data: Ranked data like grades A, B, C 

2. Numerical - 

1. Discrete - Countable items like no. of children 

2. Continuous - Measured quantities like weight, voltage, salary.

1. Interval Scale - The difference is meaningful but there is no 'zero point' on the scale, like year, tempeartue.

2. Ratio Scale - The difference is meaningful and there is a 'zero point' too like weight, salary, age.


Python for Data Analytics

1 Numpy and Data Manipulation

- Introduction to Numpy - Installation of Jupyter Notebook - Creation, Indexing, and Slicing of Numpy Arrays - Mathematical Operations, Combining and Splitting Arrays - Search, Sort, Filter Arrays, Aggregating Functions - Statistical Functions in Arrays 2 Pandas for Data Analysis - Introduction to Pandas - Creation of Data Frames, Exploring Data - Dealing with Duplicate values, Missing Data - Column Transformation in Pandas, GroupBy - Merge, Concatenate, Join in Pandas - Pivoting and Melting Dataframes 3 Matplotlib for Data Visualization - Introduction to Matplotlib - Bar, Line, Scatter, Pie, Box, Histogram, Violin, Stem plots - Stack Plot, Step Chart, Legends, Subplot - Save a Chart Using Matplotlib - Data Visualization in Seaborn - Seaborn Project

DATA ANALYTICS 4 MySQL for Data Analytics - Introduction to MySQL - Installation, Importing Data - Select Query, Where Clause - AND, OR, NOT Operators, Like Operator - Order By, Limit, Between - IN, NOT IN operator, String Functions - Data Aggregation, Numeric Functions - Date Functions, Case Operator - Group By, Having Clause - Joins, Set Operators, Subqueries, Views - Stored Procedure, Window Functions 5 Excel for Data Analytics - Introduction to MS Excel - Basic Functions, Data Validation - Data Connectors, Conditional Formatting - Basics of Formatting, Sorting, Filtering Data - Dealing with Null Values, Duplicate Values - Trimming Whitespaces, Text Functions - IF, AND, OR Functions, Date & Time Functions - COUNTIF, SUMIF Functions, Xlookup - Power Query, Cleaning and Transformation - Creating a Dashboard in Excel, myExcel Project 6 Power BI Essentials - Introduction to Power Bi - Installation of Power Bi Desktop - Data Connectors, Basic Transformations - Format Tool, Pivoting, Unpivoting of data - Adding Conditional Columns, Merge queries - Data model, Relationship Management - Introduction to DAX, Calculated Columns, Measures - DAX Functions, Visualizations, Filters - Creating Reports, Custom Visuals - Designing for Phone vs Desktop Report Viewers - Publishing Reports to Power BI Services

Tuesday, December 26, 2023

What is a holding company?

 A holding company is a parent company that is created to buy and control the ownership

 interests of other companies. The companies that are owned or controlled by a  holding

 company are called its subsidiaries.

holding companies don’t manufacture anything, sell any products or services, or conduct any

 other business operations. Their sole purpose is to hold the controlling stock or membership

 interests in other companies. This type of holding company is called a pure holding company.

In a typical holding company structure, the subsidiary companies manufacture, sell, or

 otherwise conduct business. These are called operating companies.

The holding company can own 100% of the subsidiary, or it can own just enough stock or membership interests to control the subsidiary. Having control means it has enough stock or membership interests to ensure that a vote of owners will go its way. This can be 51%. Where there are many owners, it can be a much lower percentage.

Each subsidiary has its own management who run the day-to-day business. The holding company’s management is responsible for overseeing how the subsidiaries are run. They can elect and remove corporate directors or managers and can make major policy decisions like deciding to merge or dissolve. The people running the holding company do not participate in the operating companies’ day-to-day decision making.


The holding company’s management is also responsible for deciding where to invest its money. A pure holding company can obtain the funds to make its investments by selling equity interests in itself or its subsidiaries or by borrowing. It can also earn revenue from payments it receives from its subsidiaries in the form of dividends, distributions, interest payments, rents, and payments for back-office functions it may provide. 


A holding company structure is popular with large enterprises with multiple business units. Take, for example, a large corporation that manufactures and sells several different consumer goods, including hair care products, skincare products, baby care products, and others. Rather than using one corporation with different divisions, this enterprise could be structured with one holding company and several subsidiaries. Each business unit could be operated as a separate subsidiary in which the holding company owns a controlling interest. The company’s intellectual properties, equipment, and real estate may also be placed in separate subsidiaries, with the operating companies paying to use the intellectual properties, lease the equipment, and rent its offices.


LLC holding companies

Holding companies can also be used by much smaller businesses — even by single entrepreneurs. Take, for example, a person who wants to buy an apartment building for the rental income. Two business entities could be formed: an LLC operating company that would own the apartment building and an LLC holding company that would own the LLC operating company.

Now, let’s say that our entrepreneur wants to buy a fast-food restaurant and a thoroughbred horse farm. A new subsidiary LLC can be formed for each new investment.

A holding company can own businesses in a variety of unrelated industries. It doesn’t matter if the owners and managers of the holding company don’t know about those businesses because each subsidiary has its own management to run the day-to-day operations.


Thursday, October 5, 2023

Python program to find the length and cost of a stock portfolio.

 d10={'tvs':1500,'tm':616,'axis':1000,'icici':950,'infy':1450,'wipro':400,'auro':875,'lupin':1150,'hindalco':470,'tisco':125,'pfc':240,'idfc first':92,'bob':212,'rec':280,'bel':140 }

l10 = len(d10)

s10=sum(d10.values())


print('d10: ',end='')

print(d10)

print('Sum of d10: ' + str(s10)) #9500

print('Number of stocks in d10: ' + str(l10))

print()


d25={'tvs':1500,'tm':616,'axis':1000,'icici':950,'infy':1450,'wipro':400,'auro':875,'lupin':1150,'hindalco':470,'tisco':125,'lt':3075,'polycab':5270,'titan':3215,'trent':2050,'hal':1950 }

l25 = len(d25)

s25=sum(d25.values())


print('d25: ',end='')

print(d25)

print('Sum of d25 :' + str(s25)) #24100

print('Number of stocks in d25: ' + str(l25))


Sunday, July 16, 2023

Nice poem

 हारे हुए लोग कहाँ जायेंगे ? ?

हारे हुए लोगों के लिए कौन दुनिया बसाएगा ?
उन पराजित योद्धाओं के लिए ,
तमाम शिकस्त खाए लोगों के लिए।
प्रेम में टूटे हुए लोग,
सारी जिंदगी को कहीं दांव लगाकर हारे हुए लोग
थके-हारे लोग, गुमनाम लोग
वो बूढ़े पिता जो अब अकेले रह गए हैं
वो कल्पनाओं में खोया रहने वाला बच्चा
जो परीक्षा में फेल हो गया है
वो लड़की जो तेज कदमों से घर की तरफ लौट रही है
वो बूढ़ा गुब्बारे वाला जो कांपते हाथों से पैसे गिनता है
एक असफल लेखक
मैच हार गया खिलाड़ी
इंटरव्यू से वापस लौटा युवा
और ऐसे तमाम लोग
जिन्हें पता था कि वे सफल हो सकते हैं
मगर उन्होंने असफलताओं से भरा रास्ता चुना,
वो लोग जिन्होंने
हमेशा गलत राह पर चलने का जोखिम उठाया
वो लोग जिन्होंने
गलत लोगों पर भरोसा किया
वो जिन्होंने
चोट खाई, धोखा खाया, ठोकर खाई
गिरे और धूल झाड़कर खड़े हुए
वे कहां जाएंगे ?
क्या कोई ऐसी दुनिया होगी
जहां दो हारे हुए इंसान
एक-दूसरे की हथेलियां थामे
कई पलों तक खामोश रह सकते हों
अपनी चुप्पी में तकलीफ बांटते हुए।
जिन्होंने इकारस की तरह
सूरज की तरफ उड़ान भरी
और उनके पंख पिघल गए
हारे हुए लोगों के लिए कोई जगह नहीं है
न किसी घर में, न समाज में, न किसी देश में।
क्या जो विजेता थे
वो इनसे बेहतर हैं? बेहतर थे?
नहीं, वही हारा जिसने जिंदगी की अनिश्चितता पर यकीन किया
वही जिसने अनजान रास्तों पर चलने का जोखिम उठाया
जिसने गलती करनी चाही , जो मक्कार चुप्पियों के पीछे छिपा नहीं।
जो बोल सकता था मगर बोला नहीं
उसने वो चुना जिसे चुनने का कोई तर्क नहीं था
सिवाय उसकी आत्मा के
जो हारा आखिर वो भी एक नायक था।
एक पराजित नायक के दर्द को
कौन समझना चाहेगा?
जाएंगे कहाँ सूझता नहीं
चल पड़े मगर रास्ता नहीं
क्या तलाश है कुछ पता नहीं
बुन रहे हैं दिल ख़्वाब दम-ब-दम।
पंक्तियां : दिनेश श्रीनेत

What is a superconductor?

 A superconductor is a material that can conduct electricity with zero electrical resistance when it is cooled below a specific, very cold t...