Skip to main content

Posts

SQL for Data Science

What is SQL Ans: Structured Query Language  DBMS = Data base management System MySQL is DBMS RDBMS = Relational based database management system =  basically data alg alg column me hota hai use merge krne ke liye relation to hona chahiye use maintain krna hi RDBMS, Data me primary key aur foreign key hoti hai RDBMS (Relational Database Management System) RDBMS ek aisa database management system hota है jisme data tables (rows + columns) ke form me store kiya जाता है, aur tables relationships ke through connected hote हैं. ⭐ RDBMS Kya Hotा Hai? RDBMS = Relational Database Management System Ye ek software hotा है jo: Data ko tables me store karta है Tables ke beech relationships banata है Data ko CRUD operations (Create, Read, Update, Delete) se manage karta है SQL language ka use karta है 📌 RDBMS Ka Structure 1️⃣ Table Data rows (records) aur columns (fields) me hotा है Example: Customers table 2️⃣ Row (Record / Tuple) Table ka ek complete data ent...
Post a Comment
Read more
Recent posts

Data Analysis Project 1 Ola

 I have 1 Lakhs rows Random data of Ola Ride Step I'm following here    Data Cleaning Remove Duplicate  Data Tab on Ribon ---> Trim Whitespace Sabhi me nhi aa rha ab Lets Start on SQL ==================== 1) Import CSV file , go to schema and then Table Data Import wizard   Import CSV File, go to Schema and Then table data import wizard Now Solving Problems One by One  First Question is : # Retrieve all successful bookings from data: Ans:  CREATE database Ola; Use Ola; #Retrieve all successful bookings from data: Create View Successful_Bookings As #jab bhi ham koi output nikalte hai, temporary form me store krke rakh rhe Select * From newbooking WHERE `Booking Status` = 'Success'; Select * From Successful_Bookings; Explain =========== 1️⃣ Database Creation CREATE DATABASE Ola; USE Ola; Explanation: CREATE DATABASE Ola; → नया database Ola बनाता है। USE Ola; → अब जो भी commands देंगे, वो Ola database में apply होंगे। 2️⃣ Retriev...
Post a Comment
Read more

Excel For Data Analysis

 sum = Add numbers, it is basically sumission  =SUM(number1, [number2], ...) Example: =SUM(A1:A7)  ⚡ Tips: You can use AutoSum for quick addition: Select a cell → click Home → AutoSum (Σ) → press Enter . Shortcut key: Alt + = (automatically inserts =SUM() ). Min = TO FIND MINIMUM VALUE  =MIN(A1:A12)  max = TO FIND MAXIMUM VALUE =MAX(A1:A13)  Right  ExamPle: =RIGHT(E2,10)  basically mere pas number hai 91 country code ke sath, main chahta hu 91 code ke bad right se 10 numbers mujhe nikal ke aa jaye yaha E2 mera column number hai and 10 jo mujhe chahiye right se Cases: किसी product code ke last digits निकालने के लिए  किसी date ya year ke last 2 digits निकालने के लिए किसी naam ke last letters निकालने के लिए Note: if I want to paste horizontally number then will use 'paste ke option me transpose left  == left se digits extract krne ke liye will use this  =LEFT(E2,2)   E2 IS CELL AND 2 IS DIG...
Post a Comment
Read more

Python Final Lectures

 Q- how to Print Hello World print("Hello World") Variables in python ------- age = 30   #variable should be intutive so that we can learn any time print(age) Note: Shift+Enter is shortcut to run command 2) ' #' this is for writing the comment in python Rules for Variables--- Variable can not be start with any number like - 1age  Number can use in between and end with variable like - age1 age2 Special characters are not allowed expect _ (underscore) like - age_my Space not allowed in variable  Python is case sensitive  Way to define Variable --- age1,age2 = 30,25  age1 = 30 age2 = 25 age1=age2=30   #if 30 age for both variable   >> Data type the type of data is basically data type Integer = age1 to age3 is basically integer   , Integer is basically full number lets check = type(age1)  #it will give u print int float=  basically decimal values Interest =  30.24 type(Interest) #answer is float Message = ...
Post a Comment
Read more

Python

Indexing--  it will help u to fetch single character  string= "Python" string[2] # slicing process of fetching a sub-string from the given string  #sequence of charater we can fetch means more than 1 character string="Divyanshu" string[2:4+1]   #basically here number is index value #string[start_index:end+index+1] string = "Hunny"   #indexing agr positive hai to left se count hoga #right se negative me string[:]  #it will give u entire string #now If i want to any characterwise index like string is Hunny and I want un only #string[start_index:end_index+1:step] string[1:4:2] #reverse your string #string[:: -1] string="Baba hunny" string[:: -1] # to convert into lowecase string="New Divyanshu" new_string=string.lower()  #new_string becase we've to create another string print(new_string) s1={1,2,3,4,5}    s2={3,2,8,67,85} s3=s1.union(s2) s3   #isme add hota hai whole value lekin common value update nhi hongi #intersection - ...
Post a Comment
Read more

SQL and rest python for Data analysis

SQL (Structured Query Language) की ओर — ये डेटा हैंडलिंग का अगला स्टेप है, जहाँ हम database से data को fetch, update, delete, filter, aur organize करना सीखते हैं। 💾 SQL क्या है (What is SQL)? SQL का मतलब है Structured Query Language — ये एक database language है जिसका इस्तेमाल data को store, access, और manage करने के लिए किया जाता है। जैसे Excel में data sheets होती हैं, वैसे SQL में tables होती हैं। Type Keyword Use 1️⃣ DDL (Data Definition Language) CREATE , ALTER , DROP Database structure change करने के लिए 2️⃣ DML (Data Manipulation Language) INSERT , UPDATE , DELETE Data change करने के लिए 3️⃣ DQL (Data Query Language) SELECT Data निकालने के लिए 4️⃣ DCL (Data Control Language) GRANT , REVOKE Permission देने या हटाने के लिए 5️⃣ TCL (Transaction Control Language) COMMIT , ROLLBACK Changes को confirm या cancel करने के लिए Download MY SQL From Google >>>Lets learn this concept compare with excel Concept in SQL Excel Equivalen...
Post a Comment
Read more