Visualizing Port Locations on a Map

Feb 18, 2025, 10:30 AM

allports.xlsx

Missing file

Visualize port locations on a map.

What are the top 5 countries with the most ports?

The top 5 countries with the most ports are:
  1. United States of America with 111 ports
  2. United Kingdom with 71 ports
  3. Japan with 67 ports
  4. France with 49 ports
  5. Australia with 44 ports
These countries have the highest number of ports according to the dataset provided.
Would you like to explore more about these ports or any other specific analysis?

Show me the distribution of ports by continent.

The bar chart above shows the distribution of ports by continent based on the available data.
Please note that the mapping of countries to continents is partial and may need to be expanded for a complete analysis.
Would you like to add more countries to the continent mapping or explore another aspect of the data?

What are the top 5 ports in terms of size or capacity?

To determine the top 5 ports in terms of size or capacity, we would need specific data on the size or capacity of each port. This information is typically measured in terms of TEU (Twenty-foot Equivalent Unit) for container ports or tonnage for bulk ports.
Unfortunately, the current dataset does not contain information on the size or capacity of the ports. If you have another dataset or additional information that includes these details, please provide it, and I can assist you further.
Do you have any other questions or is there another aspect of the data you would like to explore?

How can I visualize the data on a map?

To visualize the data on a map, we can use Plotly's scattermapbox to plot the ports based on their latitude and longitude. Here's a step-by-step guide on how to do this:
  1. Install Plotly: Ensure you have Plotly installed in your environment. You can install it using pip install plotly.
  2. Prepare the Data: Make sure your dataset includes latitude and longitude for each port. In our case, we have DDLat and DDLon columns for this purpose.
  3. Create a Map: Use Plotly's scattermapbox to create a map. You can customize the map style, zoom level, and other properties to suit your needs.
  4. Display the Map: Use the .show() method to display the map.
Here's an example code snippet to visualize the ports on a map:
This code will create an interactive map showing the locations of ports worldwide. You can hover over each point to see the port name and country.
Would you like to proceed with this visualization or need help with something else?

yes

Can you show me the ports in a specific country?

Please specify the country you would like to focus on, and I will filter the data to show only the ports in that country.

india

Get started with Vizly