30 European family offices are looking to set up in Hong Kong as the city overtakes Switzerland in cross-border wealth

Learn to create financial data visualizations that show the growing interest in Hong Kong as a wealth management hub, similar to trends reported in recent financial news.

Introduction

In today's interconnected world, understanding global wealth management trends is crucial for anyone interested in finance, investment, or international business. This tutorial will guide you through creating a simple financial dashboard that visualizes data about family offices and wealth management trends using Python and basic data visualization tools. You'll learn how to collect, process, and display data that reflects the growing interest in Hong Kong as a wealth management hub, similar to what was reported in the TNW article.

This project will help you understand how to work with real-world financial data and create meaningful visualizations that can be used to analyze global wealth trends.

Prerequisites

Before starting this tutorial, you should have:

A basic understanding of Python programming concepts
Python 3.x installed on your computer
Basic knowledge of data analysis and visualization concepts

No prior experience with financial data analysis is required. We'll walk you through everything step by step.

Step-by-Step Instructions

1. Install Required Python Libraries

First, we need to install the necessary Python libraries for data manipulation and visualization. Open your terminal or command prompt and run:

pip install pandas matplotlib seaborn

Why we do this: These libraries provide the tools we need to handle data (pandas), create visualizations (matplotlib), and make our charts more attractive (seaborn).

2. Create a Sample Data Set

Let's create a simple Python script that generates sample data about family offices in Hong Kong and Europe. Create a new file called family_office_data.py and add the following code:

import pandas as pd
import matplotlib.pyplot as plt
import seaborn as sns

# Create sample data representing family office trends
sample_data = {
    'Year': [2020, 2021, 2022, 2023, 2024],
    'European_Family_Offices': [25, 28, 32, 30, 30],  # Number of European offices planning to move
    'Hong_Kong_Interest': [15, 20, 25, 30, 30],      # Interest in Hong Kong
    'Switzerland_Interest': [40, 38, 35, 32, 28]     # Interest in Switzerland
}

df = pd.DataFrame(sample_data)
print("Sample Data Set:")
print(df)

Why we do this: This creates a realistic dataset that mirrors the trends mentioned in the article. The data shows the shift in interest from Switzerland to Hong Kong.

3. Visualize the Data

Now, let's add code to create a line chart that shows how interest in Hong Kong has grown compared to Switzerland:

# Set the style for better-looking charts
sns.set_style("whitegrid")

# Create the plot
plt.figure(figsize=(10, 6))

# Plot the data
plt.plot(df['Year'], df['Switzerland_Interest'], marker='o', label='Switzerland Interest')
plt.plot(df['Year'], df['Hong_Kong_Interest'], marker='s', label='Hong Kong Interest')

# Add labels and title
plt.xlabel('Year')
plt.ylabel('Interest Level (Arbitrary Scale)')
plt.title('Growing Interest in Hong Kong vs. Switzerland for Family Offices')
plt.legend()

# Show the plot
plt.tight_layout()
plt.show()

Why we do this: This visualization helps us understand the trend data clearly. It shows how Hong Kong's interest level has overtaken Switzerland, matching the trend described in the article.

4. Add More Detailed Analysis

Let's enhance our analysis by adding a bar chart that shows the number of European family offices planning to move to Hong Kong:

# Create a second chart showing European family offices
plt.figure(figsize=(10, 6))

# Bar chart for European family offices
bars = plt.bar(df['Year'], df['European_Family_Offices'], color='skyblue')

# Add value labels on bars
for bar in bars:
    height = bar.get_height()
    plt.text(bar.get_x() + bar.get_width()/2., height,
             f'{int(height)}',
             ha='center', va='bottom')

plt.xlabel('Year')
plt.ylabel('Number of European Family Offices')
plt.title('European Family Offices Planning to Set Up in Hong Kong')
plt.grid(axis='y')

plt.tight_layout()
plt.show()

Why we do this: This bar chart provides a clearer view of the actual numbers mentioned in the article (30 European family offices), showing how this number has grown over time.

5. Save Your Analysis

Let's add code to save our charts for future reference:

# Save the first chart
plt.figure(figsize=(10, 6))
plt.plot(df['Year'], df['Switzerland_Interest'], marker='o', label='Switzerland Interest')
plt.plot(df['Year'], df['Hong_Kong_Interest'], marker='s', label='Hong Kong Interest')
plt.xlabel('Year')
plt.ylabel('Interest Level')
plt.title('Family Office Interest Trends')
plt.legend()
plt.savefig('family_office_trends.png')

# Save the second chart
plt.figure(figsize=(10, 6))
bars = plt.bar(df['Year'], df['European_Family_Offices'], color='skyblue')
for bar in bars:
    height = bar.get_height()
    plt.text(bar.get_x() + bar.get_width()/2., height,
             f'{int(height)}',
             ha='center', va='bottom')
plt.xlabel('Year')
plt.ylabel('Number of European Family Offices')
plt.title('European Family Offices in Hong Kong')
plt.savefig('european_family_offices.png')

print("Charts saved successfully!")

Why we do this: Saving the charts allows you to share your analysis with others or reference it later. These visualizations can be used to present findings about the wealth management trends.

6. Run Your Complete Analysis

Now, let's put everything together in one complete script:

import pandas as pd
import matplotlib.pyplot as plt
import seaborn as sns

# Create sample data
sample_data = {
    'Year': [2020, 2021, 2022, 2023, 2024],
    'European_Family_Offices': [25, 28, 32, 30, 30],
    'Hong_Kong_Interest': [15, 20, 25, 30, 30],
    'Switzerland_Interest': [40, 38, 35, 32, 28]
}

df = pd.DataFrame(sample_data)
print("Sample Data Set:")
print(df)

# Set the style for better-looking charts
sns.set_style("whitegrid")

# Create the first chart
plt.figure(figsize=(10, 6))
plt.plot(df['Year'], df['Switzerland_Interest'], marker='o', label='Switzerland Interest')
plt.plot(df['Year'], df['Hong_Kong_Interest'], marker='s', label='Hong Kong Interest')
plt.xlabel('Year')
plt.ylabel('Interest Level (Arbitrary Scale)')
plt.title('Growing Interest in Hong Kong vs. Switzerland for Family Offices')
plt.legend()
plt.tight_layout()
plt.show()

# Create the second chart
plt.figure(figsize=(10, 6))
bars = plt.bar(df['Year'], df['European_Family_Offices'], color='skyblue')
for bar in bars:
    height = bar.get_height()
    plt.text(bar.get_x() + bar.get_width()/2., height,
             f'{int(height)}',
             ha='center', va='bottom')
plt.xlabel('Year')
plt.ylabel('Number of European Family Offices')
plt.title('European Family Offices Planning to Set Up in Hong Kong')
plt.grid(axis='y')
plt.tight_layout()
plt.show()

# Save charts
plt.figure(figsize=(10, 6))
plt.plot(df['Year'], df['Switzerland_Interest'], marker='o', label='Switzerland Interest')
plt.plot(df['Year'], df['Hong_Kong_Interest'], marker='s', label='Hong Kong Interest')
plt.xlabel('Year')
plt.ylabel('Interest Level')
plt.title('Family Office Interest Trends')
plt.legend()
plt.savefig('family_office_trends.png')

plt.figure(figsize=(10, 6))
bars = plt.bar(df['Year'], df['European_Family_Offices'], color='skyblue')
for bar in bars:
    height = bar.get_height()
    plt.text(bar.get_x() + bar.get_width()/2., height,
             f'{int(height)}',
             ha='center', va='bottom')
plt.xlabel('Year')
plt.ylabel('Number of European Family Offices')
plt.title('European Family Offices in Hong Kong')
plt.savefig('european_family_offices.png')

print("Charts saved successfully!")

Why we do this: This complete script brings together all our analysis steps. Running it will create the visualizations we need to understand the wealth management trends.

Summary

In this tutorial, you've learned how to create financial data visualizations that represent the growing interest in Hong Kong as a wealth management hub. You've:

Installed the necessary Python libraries for data analysis and visualization
Created sample data that reflects the trends described in the TNW article
Generated line charts showing the shift in interest from Switzerland to Hong Kong
Created bar charts displaying the number of European family offices planning to move to Hong Kong
Learned how to save and export your visualizations

This hands-on approach gives you practical experience in analyzing financial trends and creating meaningful visualizations that can be applied to real-world data analysis. The skills you've learned can be extended to analyze other financial trends and datasets.