List and Tuple - Difference

 The key difference between lists and tuples in Python is their mutability:

• List: Ordered and mutable, meaning you can change its elements (add, remove, or modify them).
• Tuple: Ordered but immutable, meaning once it's created, its elements cannot be changed.

---

Example: List

# Creating a list
my_list = [1, 2, 3]

# Modifying the list
my_list[0] = 10  # Update an element
my_list.append(4)  # Add a new element
my_list.remove(2)  # Remove an element

print(my_list)  # Output: [10, 3, 4]

---

Example: Tuple

# Creating a tuple
my_tuple = (1, 2, 3)

# Trying to modify the tuple
# my_tuple[0] = 10  # This will raise an error: TypeError: 'tuple' object does not support item assignment

# Accessing elements (this is allowed)
print(my_tuple[0])  # Output: 1

---

Key Characteristics:

1. Mutability:

   • Lists allow you to modify their elements.
   • Tuples do not allow modification after creation.

2. Performance:

   • Tuples are slightly faster than lists due to their immutability.

3. Usage:

   • Use lists when the data needs to change (e.g., dynamically adding/removing elements).
   • Use tuples for fixed collections of data (e.g., coordinates (x, y) or configuration data).

---

Practical Difference Example:

List Use Case:

# Shopping list: It changes over time
shopping_list = ["milk", "bread"]
shopping_list.append("eggs")
print(shopping_list)  # Output: ['milk', 'bread', 'eggs']

Tuple Use Case:

# Days of the week: Fixed and unchanging
days_of_week = ("Monday", "Tuesday", "Wednesday", "Thursday", "Friday", "Saturday", "Sunday")
print(days_of_week)  # Output: ('Monday', 'Tuesday', 'Wednesday', 'Thursday', 'Friday', 'Saturday', 'Sunday')

AttributeError: 'DataFrame' object has no attribute 'unique'

AttributeError: 'DataFrame' object has no attribute 'unique'

The error message "'DataFrame' object has no attribute 'unique'" occurs when you are trying to use the unique() method on a pandas DataFrame object, but this method is only available for pandas Series objects.

#1. Applying unique to dataframe

df = pd.DataFrame([{"A":"aaa","B":"bbb"}])

print(df.unique()) #Throws error

#2. Error can be reproduced if dataframe has multiple columns with same name.The error can pop-up if column is renamed mistakenly.

import pandas as pd

df = pd.DataFrame([{"A":"aaa","B":"bbb"}])

print(df)

print(df['A'].dropna().unique()) #works fine

df =df.rename(columns={ df.columns[1]:df.columns[0] }) # column

print(df)

print(df['A'].dropna().unique()) #

Hope it helps!!

working with report model

To create a shared data source

1. In Solution Explorer, right-click Shared Data Sources, and then select Add New Data Source.
2. In the Name box, type: RMS.
3. In the Type drop-down list, select Report Server Model.
4. In the Connection string area, type: Server=<>; datasource=<>.
5. Select Credentials.
6. Select Use Windows Authentication (Integrated Security) and then click OK.
   The data source appears in the Shared Data Sources folder in Solution Explorer.
7. On the File menu, click Save All.

XML parsing: line 1, character 75, illegal name character

When saving strings to XML, or when trying to extract text within tags it important to escape invalid characters . The following table shows the invalid XML characters and their escaped equivalents.

Invalid XML Character Replaced With
<                          <
>                          >
" "
' '
& &

if we try following code in SQL window, where we are trying to extract text from within html tags.

declare @v varchar(40)
Set @v='a & b'
Select cast(@v as XML).value('.','varchar(max)')

we will receive error like "XML parsing: line 1, character xx, illegal name character"

Solution: 

declare @v varchar(40)
Set @v='a & b'
Select cast(replace(replace(replace(@v,'>','><![CDATA['),'</',']]></')+']]>','<![CDATA[]]>','') as XML).value('.','varchar(max)')

As we know CDATA section is "a section of element content that is marked for the parser to interpret as only character data, not markup." so we will include CDATA in such a way that text is inside it and parsing of it wouldn't result in error. 

Hope it helps

Error ‘Microsoft Office Excel cannot access the file’ while accessing Microsoft Office 11.0 Object Library from SSIS

When executing the Open function. I received the following exception:

Microsoft Office Excel cannot access the file ‘e:\report\report.xls’.

There are several possible reasons:

• The file name or path does not exist

• The file is being used by another program.

• The workbook you are trying to save has the same name as a currently open workbook.

SOLUTION:

For Windows Server x64: Create the following directory:

C:\Windows\SysWOW64\config\systemprofile\Desktop

For Windows Server x86: Create the following directory:

C:\Windows\System32\config\systemprofile\Desktop

Interop type 'Microsoft.Office.Interop.Excel.ApplicationClass' cannot be embedded. Use the applicable interface instead

.NET 4.0 allows primary interop assemblies (or rather, the bits of it that you need) to be embedded into your assembly so that you don't need to deploy them alongside your application.

Reason:
In most cases, this error is the result of code which tries to instantiate a COM object.

For example
Excel.ApplicationClass xlapp = new Excel.ApplicationClass();

Solution #1
Typically, in .NET 4 you just need to remove the 'Class' suffix and compile the code:
Excel.Application xlapp = new Excel.Application();

Solution #2
For whatever reason, this assembly can't be embedded. Just open the Properties tab for the assembly in Visual Studio 2010 and set "Embed Interop Types" to "False".

Long running SQL Agent job

We tried to launch an .exe from SQL Server Agent Job and job keeps on running, it need to be stopped manually.

Steps to troubleshoot
#1. Any program that has windows interaction i.e. opens any type of window e.g. Notepad, ms-paint or excel etc.

#2. So it simply means we can only use console programs and that too without any prompts or wait for input.
Therefore, we can't execute Date or Time (DOS internal command) as they expect input.

Execute the .exe given in job step from command prompt to validate there are no wait for input.

Hope it helps