In today's adventure, we are delving into two important techniques in Python: comparison and concatenation operations. Our mission is to understand how these operations work, when to use them, and how to avoid some common pitfalls. So, let's grab our gear and get started!

Comparison operations allow us to pit two elements against each other and return a Boolean value (True or False), letting us know which of the two prevails. Concatenation operations, on the other hand, act as a friendly glue that binds strings or lists together. From validating a user's age for a video game to creating a full name from first and last names, these operations are essential in Python programming, as we shall shortly discover.

Firstly, let's explore the six comparison operators in Python: ==, !=, <, <=, >, and >=. These operators enable us to compare values of the same or different data types.

The equality operator == checks whether two values are mirror images of each other. For example, 5 == 5 returns True because both values mirror each other. Similarly, the inequality operator != determines whether two values are unalike. So, for 5 != 3, it returns True since 5 and 3 are indeed different.

Order comparison operators (<, <=, >, >=) consider the order of values. They work with numerical and string data types. So, for instance, 7 < 10 returns True. For string enthusiasts, 'apple' > 'banana' returns False because alphabetically, apple comes before banana (think of alphabet dictionary order).

Let's try a few examples:

print(5 == 5)  # This is True
print("Hello" != "Hello")  # This is False
print(7 <= 10)  # This is True
print("apple" >= "banana")  # This is False

The most exciting part is that you can chain your comparison operators, which can greatly simplify your code:

print(0 <= 5 <= 10) # This is True
print(0 <= 5 <= 7 <= 10 <= 10) # This is True
print(3 == 3 == 3) # This is True
print(3 == 3 == 4) # This is False
print(0 <= 5 >= 7) # This is False

Comparing apples with oranges, meaning different data types, can be quite the riddle. Though Python allows us to compare numerical types (int and float) directly, it becomes trickier when we bring strings into the equation. For example, comparing the number 10 with the string '10' as in 10 < '10' would cause Python to raise a TypeError. Python is confused because it doesn't know how to compare an integer with a string.

When we wish to run comparisons between different types, we first need to convert them into a common type. The most common scenario involves converting strings to floats or integers while comparing.

print(10 == int("10"))  # This is True
print(7.0 <= float("10.5"))  # This is True