DEV Community

Cover image for Day 30 of My Data Analytics Journey !
Ramya .C
Ramya .C

Posted on

Day 30 of My Data Analytics Journey !

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 .

Top comments (0)