knitr::opts_chunk$set(echo = TRUE, message = FALSE, 
                      warning = FALSE)

Место исследования

Карта

Море

Работа с таблицей по каспийским насекомым

Таблица данных 
library(readxl)
A <- read_excel("Caspian spiders.xlsx")
formattable::formattable(A)
id plants.d coast RH Aphelacarus acarinus Oppiella nova Microppia minus Punctoribates hexagonus Protoribates capucinus Zygoribatula glabra (cf.) Oribatella caspica (cf.) Scheloribates laevigatus (cf.) Acrotritia ardua Epilohmannia styriaca Austrophthiracarus duplex (cf.) Eobrachychthonius latior Trichogalumna nipponica Galumna tarsipennata Scheloribates distinctus Trhypochthoniellus longisetus Sellnickochthonius immaculatus Sellnickochthonius suecicus Brachychthonius bimaculatus Liochthonius lapponicus Ramusella (Insculptoppia) furcata Suctobelbella (Suctobelbella) subcornigera Zygoribatula undulata Hydrozetes lemnae Trichoribates berlesei Eupelops plicatus Malaconothrus monodactylus Tectocepheus sarekensis Pilogalumna tenuiclava Pergalumna obvia Brachychthonius berlesei Belba daghestanica (cf.) Xenillus tegeocranus Oppia denticulata Ramusella clavipectinata Leitneria pugio Dendrolaelaspis lindquisti (aff.) Blattisocidae gen.sp. Lasioseius sp.1 Cheiroseius curtipes Cheiroseius necorniger Cheiroseius serratus Cheiroseius sp.1 Amblyseius sp.1 Neoseiulus sp.1 Neoseiulus sp.3 Ameroseius corbicula Ameroseius lidiae (aff.) Epicriopsis palustris Proctolaelaps pygmaeus Proctolaelaps sp.1 Gaeolaelaps nolli Gaeolaelaps aculeifer Ololaelaps placentula Ololaelaps placidus Macrocheles scutatus Macrocheles insignitus Pachylaelaps pectinifer (cf.) Neojordensia sinuata Neojordensia sp. Arctoseius cetratus Arctoseius venustus Leioseius minusculus Gamasellodes bicolor Gamasellodes sp. Protogamasellus massula Protogamasellus mica Neogamasus unicornutus Pergamasus crassipes (aff.) Lysigamasus sp. Gamasiphis pulchellus Rhodacarus denticulatus (cf.) Rhodacarellus silesiacus Zercon sp. Tyrophagus sp.1 Tyrophagus sp.2 Histiogaster sp. Acarus sp.1 Acarus sp.2 Pyroglyphidae gen.sp.
PbAe1 Aeluropus pebbly 31.9717600 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 1 0 0 0 0 0
PbAe2 Aeluropus pebbly 32.8808181 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0
PbAe3 Aeluropus pebbly 31.9802909 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 1 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 1 0 0 0 0
PbAe4 Aeluropus pebbly 32.3838081 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0
PbAe5 Aeluropus pebbly 32.8219433 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 1 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0
PbDe1 Deschampsia pebbly 29.7359357 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 1 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 1 0 0 0 0 0 0 0 0 0 0
PbDe2 Deschampsia pebbly 31.9729330 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 1 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 1 0 0 0 0 0 0 0 0 0 0 0 0
PbDe3 Deschampsia pebbly 30.5540613 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 4 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0
PbDe4 Deschampsia pebbly 28.2292156 0 0 0 0 0 2 0 0 0 0 1 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 4 0 0 0 0 0 0 0 0 0 0 0 16 0 6 0 0 0 0 0 0 0 0 0 0
PbDe5 Deschampsia pebbly 33.9622642 0 0 0 0 0 1 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 32 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 2 0 0 0 0 0 0 0 0 0 0 0
PbPo1 Poa pebbly 27.5301205 0 0 0 0 0 0 0 0 0 0 0 0 1 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 2 0 0 0 1 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0
PbPo2 Poa pebbly 32.8936743 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 2 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0
PbPo3 Poa pebbly 33.7974684 0 0 0 1 0 0 0 0 0 0 1 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 3 0 1 0 3 0 0 0 0 0 0 0 0 0 0 0 0 12 0 0 0 0 0 0 0 0 0 0 0 16 2 3 7 0 0 0 0 0 0 0 0 0
PbPo4 Poa pebbly 34.0253165 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 9 0 0 0 0 0 0 0 2 0 0 0 0 0 0 0 0 0 0 0 0 0 0 1 0 39 0 0 0 0 0 0 0 0 0 0 0 0 0 0 2 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0
PbPo5 Poa pebbly 24.2591316 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 8 0 0 0 0 0 0 0 0 0 0 0 0 0 0 1 0 0 0 1 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0
PbTu1 Typha pebbly 32.8875090 0 0 0 0 0 1 0 0 0 0 1 0 0 0 0 0 12 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 1 0 0 0 0 0 0 0 0 0 0 0 3 0 5 0 0 1 0 2 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0
PbTu2 Typha pebbly 32.4273664 0 0 0 0 0 0 0 0 0 0 3 0 0 0 0 0 14 0 0 0 0 0 0 0 1 0 0 0 0 0 0 0 0 0 0 0 0 2 0 2 0 0 1 0 0 0 0 0 0 0 1 0 9 0 0 0 0 0 0 3 0 0 0 3 0 0 0 0 0 0 0 0 0 0 18 15 3 0 0 0
PbTu3 Typha pebbly 31.5101899 0 0 0 0 0 0 0 0 0 0 1 0 0 0 0 0 8 0 0 0 0 0 0 0 13 0 0 0 0 0 0 0 0 0 0 0 0 5 1 0 0 0 1 1 0 0 0 0 0 0 1 0 6 0 0 0 0 0 0 0 0 0 0 30 0 0 0 0 0 1 0 0 0 0 52 26 0 0 0 0
PbTu4 Typha pebbly 30.8875360 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 1 0 0 0 0 0 0 0 0 0 0 0 0 0 0 3 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 1 0 0 0 1 1 0 0 0 0 0 1 0 0 0 0 0
PbTu5 Typha pebbly 32.4981017 0 0 0 0 0 1 0 0 0 0 4 0 0 0 0 0 7 0 0 0 0 0 0 0 5 0 0 0 0 0 0 0 0 0 0 0 0 0 0 3 0 0 0 0 1 0 0 0 0 0 1 0 1 0 0 0 0 2 0 0 0 0 0 0 0 0 0 1 8 1 0 0 0 0 1 0 2 0 0 0
PbTl1 Typha pebbly 31.9814600 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 1 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0
PbTl2 Typha pebbly 28.5714286 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 2 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 11 3 0 0 0 1 0 0 0 0 0 0 0 1 0 0 11 0 3 0 0 0 2 0 0 0 0 0 0 0 0 2 0 0 0 0 0 6 0 1 0 0 0
PbTl3 Typha pebbly 30.0776915 0 0 0 0 0 0 0 0 0 0 1 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 1 0 2 0 0 3 0 1 0 3 0 0 0 0 0 0 0 0 1 0 0 0 0 0 2 10 0 0 0 0
PbTl4 Typha pebbly 33.5314685 0 2 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 2 0 0 0 1 0 0 0 0 0 0 0 0 0 0 0 0 0 0 4 7 0 0 0 0
PbTl5 Typha pebbly 26.9458712 0 0 0 14 0 0 1 0 0 0 1 0 1 0 1 17 3 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 7 0 0 1 0 4 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 1 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 2 0 0 0
SdJj1 Juncus sandy beach 27.0052734 0 0 0 0 0 0 0 0 0 0 0 0 0 0 34 0 0 0 0 0 0 0 88 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 2 1 0 4 0 2 1 3 0 0 0 0 0 0 0 0 0 0 0 0 8 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 1 0 0 0 0
SdJj2 Juncus sandy beach 26.4773379 0 0 0 0 0 0 0 0 0 0 0 0 0 0 19 0 0 0 0 0 1 0 41 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 2 8 0 0 0 0 0 0 0 0 0 0 0 0 0 0 8 0 0 0 3 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0
SdJj3 Juncus sandy beach 28.0619298 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 2 0 0 0 0 0 0 0 0 0 0 0 0 0 0 1 0 0 0 0 0 0 1 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 4 0 0 0 0 0 0 0 0 0 0 0 0 0
SdJj4 Juncus sandy beach 27.1174119 0 0 0 0 0 0 0 0 0 0 0 0 0 0 1 0 0 0 0 0 0 0 58 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 1 1 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 2 0 0 0 1 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0
SdJj5 Juncus sandy beach 30.6015038 0 0 0 0 0 0 0 0 0 0 0 0 0 0 25 0 0 0 0 0 0 0 14 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 1 1 0 0 0 0 1 0 0 0 0 0 0 0 0 0 0 0 0 0 1 0 0 0 0 0 0 0 1 0 0 0 0 0 0 0 0 0 0 0 0 0
SdEq1 Equisetum sandy beach 25.9322034 0 0 0 0 0 0 0 0 0 0 0 0 0 0 28 0 1 0 0 0 0 0 6 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 2 8 0 1 0 0 0 2 0 0 0 0 0 5 0 0 0 0 0 0 0 0 2 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0
SdEq2 Equisetum sandy beach 23.0835985 0 0 0 0 0 0 0 0 0 0 0 0 0 0 2 0 10 0 0 0 0 0 30 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 2 0 0 0 0 0 2 0 0 0 0 0 0 0 0 1 0 0 0 0 0 1 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0
SdEq3 Equisetum sandy beach 23.0694354 0 0 0 0 0 0 1 0 0 0 0 0 0 0 0 0 2 0 0 0 0 0 1 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 1 1 0 0 0 0 0 1 0 0 0 0 0 0 7 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0
SdEq4 Equisetum sandy beach 26.0514019 0 0 0 0 0 0 0 0 0 0 0 0 0 0 3 0 1 0 0 0 0 0 24 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 1 0 0 0 0 0 1 0 0 0 0 0 2 1 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 1 0 0 0 0 0 0 0 0 0 0 0
SdEq5 Equisetum sandy beach 25.3725332 0 0 0 0 0 0 0 0 0 0 0 0 0 0 22 0 6 0 0 0 0 0 41 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 1 0 0 0 0 0 10 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0
SdTu1 Typha sandy beach 23.6719082 0 0 0 0 0 0 0 0 0 0 0 0 0 0 54 0 0 0 0 0 0 0 41 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 2 5 0 3 0 0 2 0 0 0 0 0 0 0 0 0 0 0 0 0 18 0 0 0 5 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0
SdTu2 Typha sandy beach 22.4859875 0 0 0 0 0 0 0 0 0 0 0 0 0 0 5 0 0 0 0 0 0 0 3 0 0 0 0 0 0 0 0 0 0 0 0 0 0 1 0 2 0 1 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 5 0 5 0 19 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0
SdTu3 Typha sandy beach 23.0740464 0 0 0 0 0 0 0 0 0 0 0 0 0 0 20 0 1 0 0 0 0 0 3 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 1 8 0 0 0 0 0 0 0 0 0 0 0 0 0 0 1 1 0 0 3 0 12 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0
SdTu4 Typha sandy beach 24.1089307 0 0 0 0 0 0 0 0 0 0 0 0 0 0 2 0 0 0 0 0 0 0 2 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 1 3 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 3 0 1 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0
SdTu5 Typha sandy beach 22.6672172 0 0 0 0 0 0 0 0 0 0 0 0 0 0 1 0 1 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 1 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 1 0 0 2 0 5 0 4 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0
SdEc1 Elaeagnus sandy beach 19.3536122 0 0 0 0 0 1 0 0 1 0 0 0 0 0 1 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 5 0 0 0 0 0 0 0 0 0 0 0 0 4 0 0 0 3 0 0 0 0 0 0 0 0 0 0 0 0 0
SdEc2 Elaeagnus sandy beach 28.0592362 0 0 0 0 0 34 1 0 0 0 0 0 5 0 0 0 127 0 0 0 0 1 0 0 1 0 0 6 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 5 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 1 0 0 0 0 0 0 0 0 0 0 0 0 0
SdEc3 Elaeagnus sandy beach 28.5611511 0 0 0 0 0 0 39 1 0 0 0 0 0 0 0 0 127 0 0 0 0 0 0 0 0 0 0 0 0 0 0 18 0 0 0 17 0 0 0 0 0 0 0 20 0 0 16 0 0 1 0 0 11 0 0 0 0 0 0 0 0 0 0 0 0 0 10 0 1 0 0 0 0 1 1 0 0 0 0 15
SdEc4 Elaeagnus sandy beach 14.2454161 0 0 0 0 0 0 0 0 5 0 0 0 0 0 3 0 12 0 0 0 0 0 0 0 0 0 0 0 0 1 0 0 0 0 0 2 0 0 0 0 0 0 0 1 0 0 1 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 3 0 0 0 10 0 0 0 0 0 0 0 0 0 0 0 0 0
SdEc5 Elaeagnus sandy beach 29.3262239 0 0 0 0 0 14 0 4 0 0 0 0 0 0 0 0 8 0 0 0 13 1 0 0 0 0 0 3 0 0 0 1 0 0 0 18 5 0 0 0 0 0 4 0 0 0 0 0 22 2 0 0 0 0 0 0 0 0 0 0 1 0 0 0 0 0 0 0 0 3 0 0 0 13 0 0 0 0 0 0
SdTa1 Typha sandy beach 28.5714286 0 0 0 0 0 0 0 0 0 0 0 0 0 0 34 0 0 0 0 0 0 0 4 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 1 0 1 0 3 0 0 0 0 2 0 0 6 0 0 0 0 0 0 0 0 0 6 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0
SdTa2 Typha sandy beach 25.9383129 0 0 0 0 0 0 0 0 0 0 0 0 0 0 55 0 0 0 0 0 0 0 10 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 1 0 0 2 0 0 0 0 1 0 0 2 0 0 0 1 1 0 0 3 0 0 0 2 0 0 0 1 0 0 0 0 0 0 0 0 0 0 0 0 0
SdTa3 Typha sandy beach 29.5734101 0 0 0 0 0 0 1 0 0 0 0 0 0 0 0 0 134 0 23 0 0 0 8 0 0 0 0 0 0 0 1 0 0 0 0 0 0 0 1 0 0 0 0 0 0 0 0 0 0 0 0 7 2 0 0 0 0 0 0 0 32 0 3 0 15 0 40 0 0 0 0 0 0 0 0 0 0 0 0 0
SdTa4 Typha sandy beach 30.5990080 0 0 0 0 0 0 0 0 0 0 0 0 0 0 1 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 1 0 0 0 0 0 0 0 0 0 0 0 0 1 0 0 0 0 0 0 1 0 3 0 0 0 0 0 4 0 0 0 0 0 0 0 0 0 0 0 0 0
SdTa5 Typha sandy beach 25.5667038 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 2 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 2 0 0 0 0 0 0 0 0 0 0 0 2 0 1 0 0 1 0 0 0 0 0 0 12 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0
SdJm1 Juncus sandy beach 25.3587024 0 0 0 0 0 0 0 0 0 0 0 0 0 0 74 0 7 0 0 0 0 0 10 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 1 0 0 0 0 0 0 0 0 0 0 0 1 1 0 1 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 1 1 0
SdJm2 Juncus sandy beach 24.8106744 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 6 0 0 0 0 0 15 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 4 0 0 0 0 0 1 0 0 0 0 0 1 1 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 2 0 0 0 0
SdJm3 Juncus sandy beach 20.2730375 0 0 0 0 0 0 8 0 0 0 0 0 0 0 0 0 46 0 0 0 0 0 4 0 0 0 0 1 0 0 0 0 0 0 0 0 0 0 0 1 0 0 0 0 0 2 0 3 0 0 0 0 0 0 0 0 0 0 0 0 1 0 0 0 0 0 1 0 0 1 0 0 0 0 0 0 0 0 0 0
SdJm4 Juncus sandy beach 24.7879722 0 0 0 0 0 0 0 0 0 0 0 0 0 0 49 0 23 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 13 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0
SdJm5 Juncus sandy beach 24.2492492 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 13 0 0 0 0 0 3 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 1 3 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 1 0 0 0 0 0 0 0 0 0 0 0
SdFn1 Phragmites sandy beach 47.7828429 0 4 0 0 0 0 14 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 12 0 0 18 58 3 2 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 3 0 0 16 0 0 0 0 0 0 0 0 0 0 0 12 0 0 0 0 0 3 0 1 0 0 0
SdFn2 Phragmites sandy beach 45.3157895 0 21 0 0 0 0 1 0 0 0 0 0 0 28 0 0 0 0 0 23 0 0 1 0 0 0 18 0 3 9 0 0 0 0 0 0 6 0 0 0 0 0 1 0 0 0 0 0 0 0 0 0 0 4 0 0 5 0 0 0 0 0 0 3 0 0 0 0 31 0 0 0 0 0 1 0 1 0 0 0
SdFn3 Phragmites sandy beach 28.0857952 0 7 0 0 0 0 1 0 0 0 0 0 0 1 6 0 0 0 0 24 0 0 0 0 0 0 0 0 2 7 0 0 0 0 0 0 13 0 0 0 0 0 2 0 0 0 0 0 0 0 0 0 0 0 0 2 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0
SdFn4 Typha sandy beach 22.1399482 0 0 0 0 0 0 0 0 0 0 0 0 0 0 3 0 0 0 0 0 0 0 1 0 0 0 0 0 0 0 0 0 0 0 0 0 3 0 3 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 1 0 0 0 0 0 0 0 0 0 0 0 4 0 0 0 0 0 0 0 1 0 0 0
SdFn5 Typha sandy beach 29.9861496 0 0 0 0 0 0 0 0 0 0 0 0 0 0 2 0 0 0 0 0 0 0 1 7 0 0 0 0 0 0 0 0 0 0 0 0 0 0 1 0 0 0 1 0 0 0 0 0 0 0 0 0 0 1 0 1 2 0 0 0 0 0 0 1 0 0 0 0 1 0 0 0 0 0 1 0 0 0 0 0
RsFd1 Phragmites reeds 24.5621181 0 7 0 0 0 0 0 3 0 11 0 1 0 0 0 0 10 0 0 4 3 0 0 0 0 0 0 0 0 0 23 3 1 6 3 2 0 0 0 0 0 0 0 0 0 0 0 0 1 0 0 0 0 0 0 0 0 0 0 0 0 5 0 0 0 1 0 0 0 0 0 0 12 0 0 0 1 0 1 0
RsFd2 Phragmites reeds 26.6263238 0 0 0 0 1 0 0 4 0 4 0 1 0 0 0 0 0 0 0 0 7 0 0 0 0 0 0 1 0 0 3 0 1 5 4 0 0 0 0 0 0 0 0 0 0 0 0 0 1 0 0 0 0 0 0 0 0 0 0 0 0 1 0 0 0 5 0 0 0 0 0 0 14 0 0 0 0 0 0 0
RsFd3 Phragmites reeds 26.2936475 0 7 0 0 3 0 0 0 1 6 0 0 0 0 0 0 4 0 0 0 1 0 0 0 1 0 0 0 0 0 19 0 2 6 0 0 0 0 0 0 0 0 0 0 0 0 0 0 1 0 0 0 0 0 0 0 0 0 0 0 0 1 0 0 0 2 0 0 0 0 0 0 6 0 0 0 1 1 0 0
RsFd4 Phragmites reeds 28.8649204 0 2 0 0 0 0 5 3 0 0 0 2 0 0 0 0 45 0 0 0 0 0 0 0 6 0 0 0 0 0 1 0 5 8 3 0 16 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 2 0 0 0 0 0 0 0 0 0 0 2 0 0 0 3 2 1 0
RsFd5 Phragmites reeds 31.9535588 0 0 0 0 8 0 0 0 0 0 0 5 0 0 0 0 18 0 0 20 0 2 0 0 0 0 0 0 0 0 2 2 3 1 82 0 29 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 13 0 0 0 0 0 0 0 0 0 0 1 0 0 0 1 8 8 0
SdCJ1 Convolvulus dunes 3.3097686 0 0 2 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 1 0 0 0 0 0 0 0 0
SdCJ2 Convolvulus dunes 5.5804340 0 0 0 0 0 0 2 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 1 0 0 0 0 0 0 0 0
SdCJ3 Convolvulus dunes 9.8338870 0 5 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 1 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0
SdCJ4 Convolvulus dunes 6.5529923 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 2 0 0 0 0 0 0 0 0
SdCJ5 Convolvulus dunes 6.5536355 0 0 1 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0
SdCS1 Convolvulus dunes 2.2787029 0 0 0 0 0 0 0 0 0 0 0 1 0 0 0 0 12 2 8 0 0 1 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 1 0 0 0 0 0 0 0 0
SdCS2 Convolvulus dunes 1.3902681 0 0 2 0 0 0 0 0 0 0 0 0 0 0 0 0 3 7 14 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 1 0 0 0 0 0 0 0 0 0 0 0 0 0
SdCS3 Convolvulus dunes 2.6631158 0 0 1 0 0 0 0 0 0 0 0 0 0 0 0 0 9 3 22 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 2 0 0 0 0 0 0 0 0
SdCS4 Convolvulus dunes 1.1450382 0 0 2 0 0 0 0 0 0 0 0 0 0 0 0 0 4 1 19 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 7 0 0 0 0 0 0 0 0
SdCS5 Convolvulus dunes 0.5416667 0 0 2 0 0 0 0 0 0 0 0 0 0 0 0 0 6 3 16 0 0 0 1 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0

Анализ данных

Сначала решили найти как зависит обилие от влажности для разных типов берегов

library(readxl)
library(tidyverse)

A <- read_excel("Caspian spiders.xlsx") %>% 
  pivot_longer(names_to="sp", values_to="abu", 
               -c("id", "plants.d","coast","RH"))
A1 <- A %>%
  filter(abu > 0) %>% 
  group_by(id, plants.d, coast, RH, abu) %>% 
  summarise(nsp = n(), .groups = "drop") %>% 
  ungroup()

  A2 <- ggplot(A1, aes(RH, abu))+facet_wrap(vars(coast))+
  geom_point(colour = "red", size = 0.5)+
  labs(x = "Влажность", y = "Обилие",
       title = "Зависимость обилия от влажности для разных типов берегов") + 
  theme_linedraw() 
plotly::ggplotly(A2)

Далеерасчитали индекс Менхиника и построили модель зависимости индекса от влажности.

library(readxl)
library(tidyverse)

A <- read_excel("Caspian spiders.xlsx") %>% 
  pivot_longer(names_to="sp", values_to="abu", 
               -c("id", "plants.d","coast","RH"))
df2 <- A %>% 
  filter(abu>0) %>% 
  group_by(id, plants.d, coast) %>%
  summarise(S = n(),
            N = sum(abu),
            RH = mean(RH)) %>% 
  mutate(m_index = ((S-1) / sqrt(N))) %>% 
  ungroup()

fit <- lm(m_index~RH, data=df2)
summary(fit)
## 
## Call:
## lm(formula = m_index ~ RH, data = df2)
## 
## Residuals:
##     Min      1Q  Median      3Q     Max 
## -1.0400 -0.3222  0.0130  0.3329  1.2829 
## 
## Coefficients:
##             Estimate Std. Error t value Pr(>|t|)    
## (Intercept) 0.715110   0.167631   4.266 6.04e-05 ***
## RH          0.009876   0.006251   1.580    0.119    
## ---
## Signif. codes:  0 '***' 0.001 '**' 0.01 '*' 0.05 '.' 0.1 ' ' 1
## 
## Residual standard error: 0.5189 on 71 degrees of freedom
## Multiple R-squared:  0.03396,    Adjusted R-squared:  0.02036 
## F-statistic: 2.496 on 1 and 71 DF,  p-value: 0.1186
A3 <- ggplot(df2, aes(RH,m_index))+
  geom_abline(slope = fit$coefficients[2],
              intercept = fit$coefficients[1], colour = "green")+
  geom_point()+
  labs(x = "Влажность", y = "Индекс Менхиника",
       title = "Зависимость индекса Менхиника от влажности") + 
  theme_bw()
plotly::ggplotly(A3)

Определили среднее обилие длякаждого типа берега и растительности.

df3 <- A %>% 
  filter(abu>0)%>%
  group_by(coast, plants.d) %>% 
  summarise(mean=mean(abu)) %>%
  view()%>%
   ungroup()
  
A4 <- ggplot(df3, aes(x= coast, y = mean, fill = plants.d))+
  geom_col() + 
  labs(x = "Тип берега", y = "Среднее значение обилий",
       title = "Среднее значение обилий по типам берега") + 
  theme_classic()
plotly::ggplotly(A4)