# Message Boards

Posted 5 years ago
7506 Views
|
3 Replies
|
12 Total Likes
|
3 Replies
Sort By:
Posted 5 years ago
 You should look into URLFetch for potential alternatives, but simple import works too: data = Import["https://docs.google.com/spreadsheets/d/1BvqdIUxuMVS2kNsg4tl53iVpNyj1tnYnO3zXH5qW9Rk", "Data"]; and then some sort of parsing or data manipulation: data[[2, 1, 2]] // TableForm 
 You can modify your url to change the format to CSV for downloading: url = "https://docs.google.com/spreadsheets/d/1BvqdIUxuMVS2kNsg4tl53iVpNyj1tnYnO3zXH5qW9Rk/export?format=csv"; Then you can import it (I needed to use the CharacterEncoding option to get the characters to import normally): csv = Import[url, "CSV", CharacterEncoding -> "UTF8"]; Then you can make a Dataset, which makes data a little bit easier to reason with in many cases: dataset = Dataset[Map[AssociationThread[First[csv], #] &, Rest[csv]]] Now you can get all the species with pin equal to 7, for example: dataset[Select[#Pin == 7 &]] Or do the same and then sort by species, alphabetically: dataset[Select[#Pin == 7 &] /* SortBy[#Species &]] Or group by species, get a count of how many there are for each species (using Length) and sorting that in descending order: dataset[GroupBy[#Species &] /* Sort /* Reverse, Length] Or group by station and then by species (the extra //Normal // Dataset should not be needed, but helps with formatting): ds2 = dataset[GroupBy[#Plot &], GroupBy[#Species &] /* Sort /* Reverse, Length] // Normal // Dataset Or, proceeding with data set 'ds2', make pie charts for each distribution: ds2[All, PieChart[#, ChartLegends -> Keys[#]] &]