Creating a MATLAB Matrix from ISP Connections

  • Context: MATLAB 
  • Thread starter Thread starter Stoccardo
  • Start date Start date
  • Tags Tags
    Isp Matlab Matrix
Click For Summary
SUMMARY

This discussion focuses on creating a matrix in MATLAB from a text or Excel file containing Internet Service Provider (ISP) connections. The user seeks assistance in importing data formatted with city connections and providers into MATLAB. Key functions mentioned for data import include textread, fscanf, and xlsread. The goal is to visualize connections in a matrix format, where each connection is represented as a pair of cities.

PREREQUISITES
  • Familiarity with MATLAB programming
  • Understanding of data import functions in MATLAB
  • Basic knowledge of matrix operations
  • Experience with text and Excel file formats
NEXT STEPS
  • Research MATLAB's textread function for reading text files
  • Explore the fscanf function for formatted data input
  • Learn about the xlsread function for importing Excel files
  • Investigate matrix manipulation techniques in MATLAB
USEFUL FOR

MATLAB programmers, data analysts, and anyone involved in processing ISP connection data for visualization or analysis.

Stoccardo
Messages
1
Reaction score
0
hello everyone!
perhaps I am right here. i need help with programming MATLAB. i ve got a txt (or alternatively a xls) file. stored in it are internet service provider connections. i want to import this file and form a matrice. in this initial matrice each connection should be shown (a connection is city1 --> city2). below is a _small_ excerpt of the file i have.
help is really appreciated.
/Stoccardo

Rk City1 City2 Provider
84 Ealing, UnitedKingdom Ilford, UnitedKingdom Brit.Telecom
85 Ealing, UnitedKingdom Glasgow, UnitedKingdom Brit.Telecom
86 Kingston, UnitedKingdom Ilford, UnitedKingdom Brit.Telecom
87 Bletchley, UnitedKingdom Milan, Italy Brit.Telecom
88 Ealing, UnitedKingdom Santa Clara, CA Brit.Telecom
89 Ealing, UnitedKingdom Dallas, TX Brit.Telecom
90 Paris, France London, UnitedKingdom Colt
91 London, UnitedKingdom Caracas, Venezuela Colt
92 Paris, France Berlin, Germany Colt
93 London, UnitedKingdom Dublin, Ireland Colt
94 London, UnitedKingdom Barcelona, Spain Colt
 
Physics news on Phys.org
Look up textread, fscanf and xlsread :)