Day 30 of My Data Analytics Journey !

Avatar photoByAdil

Today marks the 30th day of my Data Analytics learning!
The following questions and tasks were given by my Training Director to strengthen my basics and improve my practical skills.

🔹 1. How did Python get its name?

Python was created by Guido van Rossum in the late 1980s.
The name didn’t come from the snake 🐍, but from the British comedy show Monty Python’s Flying Circus.
Guido wanted something short, unique, and fun for his programming language.

🔹 2. What is a Scripting Language?

  • A scripting language is used to automate tasks
  • Usually interpreted, not compiled
  • Examples: Python, JavaScript, Bash
    👉 Think of it as writing small programs to quickly solve problems

🔹 3. What is a Query Language?

  • A query language is used to interact with databases
  • Example: SQL (Structured Query Language)
    👉 You use it to ask questions from your data, like:
    SELECT name, age FROM students WHERE age > 20

🔹 4. What is a Programming Language?

  • A programming language is a formal language to build software
  • Examples: Python, Java, C++
    👉 You use it to design algorithms, build applications, and solve complex problems

🔹 5. Difference Between Scripting, Query, and Programming

  • Scripting Language → Used for automation (e.g., Python, JavaScript, Bash)
  • Query Language → Used for extracting and manipulating data (e.g., SQL)
  • Programming Language → Used for building full applications (e.g., Java, C++, Python)

🔹 6. Task – Repeat a Sentence 2000 Times in MS Word (Macro Method 1)

Sometimes Alt+F11 may not open VBA editor. Instead, use this method:

Step 1: Enable Developer Tab

  1. Open MS Word
  2. Go to File → Options → Customize Ribbon
  3. On the right side, tick Developer → Click OK
    👉 Now you’ll see the Developer tab

Step 2: Open Visual Basic Editor

  1. Go to the Developer tab
  2. Click Visual Basic

Step 3: Insert a Module

  1. In the VBA editor, click Insert → Module
  2. A blank window opens

Step 4: Paste This Code
Sub RepeatSentence()
 Dim i As Long
 For i = 1 To 2000
  Selection.TypeText “I am learning Data Analytics.” & vbCrLf
 Next i
End Sub

Step 5: Run the Macro

  1. Close the VBA editor
  2. In Word → Developer → Macros
  3. Select RepeatSentence → Click Run

✅ our sentence will be repeated 2000 times in the document automatically.

🔹 7. Task – Send Different Emails to 100 People (Thunderbird Mail Merge)

  1. Create a CSV file with columns like Email, Name, and Message

  1. In Thunderbird → Install Mail Merge Add-on

  2. Write an email like this:

To: {{Email}}
Subject: Personal Mail
Hi {{Name}},

{{Message}}

  1. Go to Tools → Mail Merge → Select CSV → Send Now ✅

🔹 8. Task – VLOOKUP & HLOOKUP in Excel

VLOOKUP (Vertical Lookup):
=VLOOKUP(101, A2:C10, 2, FALSE)
👉 Finds the value in the 2nd column for ID 101

HLOOKUP (Horizontal Lookup):
=HLOOKUP(“Maths”, A1:F3, 2, FALSE)
👉 Finds the value under the “Maths” heading .

Similar Posts