pivot_wider issues

tidyverse
1

getting errors trying to make a table...
I have dplyr and tidyr loaded

LPI_2019_mdw_location %>% group_by %>% summarise(sum_layer1 = sum(LAYER_1)(Location_fac, RATING_fac)) %>% pivot_wider(names_from = RATING, values_from = sum_layer1)
Error: attempt to apply non-function

raw data:

2485 3 2019 R24_NORTH ACAM4 4 0 0 0 0 0 Upper Meadow FACU
2486 3 2019 R24_NORTH ACMI2 4 0 0 0 0 0 Upper Meadow FACU
2487 3 2019 R24_NORTH AGGL 3 1 0 1 0 0 Upper Meadow FAC
2488 3 2019 R24_NORTH AGHE 5 0 0 0 0 0 Upper Meadow UPL
2489 3 2019 R24_NORTH ALAE 1 0 0 0 0 0 Upper Meadow OBL
2490 3 2019 R24_NORTH ALCA 5 0 0 0 0 0 Upper Meadow UPL
2491 3 2019 R24_NORTH ALLE 5 0 0 0 0 0 Upper Meadow UPL
2492 3 2019 R24_NORTH ALLIU 6 0 0 0 0 0 Upper Meadow NA
2493 3 2019 R24_NORTH ANLU2 5 0 0 0 0 0 Upper Meadow UPL
2494 3 2019 R24_NORTH ARAR8 5 0 0 0 0 0 Upper Meadow UPL
2495 3 2019 R24_NORTH ARCA 4 8 1 2 0 0 Upper Meadow FACU
2496 3 2019 R24_NORTH ARTR2 5 0 0 0 0 0 Upper Meadow UPL
2497 3 2019 R24_NORTH ASLE 5 0 0 0 0 0 Upper Meadow UPL
2498 3 2019 R24_NORTH SYSP 3 0 0 0 0 0 Upper Meadow FAC
2499 3 2019 R24_NORTH ASPU9 5 0 0 0 0 0 Upper Meadow UPL
2500 3 2019 R24_NORTH BAHO 5 0 0 0 0 0 Upper Meadow UPL
2501 3 2019 R24_NORTH BIBI5 2 0 0 0 0 0 Upper Meadow FACW
2502 3 2019 R24_NORTH BRTE 5 0 0 0 0 0 Upper Meadow UPL
2503 3 2019 R24_NORTH CAAT25 6 0 0 0 0 0 Upper Meadow NA
2504 3 2019 R24_NORTH CATT3 2 0 0 0 0 0 Upper Meadow FACW
2505 3 2019 R24_NORTH CADO2 3 0 0 0 0 0 Upper Meadow FAC
2506 3 2019 R24_NORTH CAFE4 3 12 12 2 1 0 Upper Meadow FAC
2507 3 2019 R24_NORTH CAFI 6 0 0 0 0 0 Upper Meadow NA
2508 3 2019 R24_NORTH CAIN10 1 0 0 0 0 0 Upper Meadow OBL
2509 3 2019 R24_NORTH CANE2 1 0 2 0 1 0 Upper Meadow OBL
2510 3 2019 R24_NORTH CAQU2 2 0 0 0 0 0 Upper Meadow FACW
2511 3 2019 R24_NORTH CASI2 1 0 0 0 0 0 Upper Meadow OBL
2512 3 2019 R24_NORTH CATE26 4 0 0 0 0 0 Upper Meadow FACU
2513 3 2019 R24_NORTH CAUT 1 0 0 0 0 0 Upper Meadow OBL
2514 3 2019 R24_NORTH CISC2 3 0 0 0 0 0 Upper Meadow FAC
2515 3 2019 R24_NORTH CLRU2 6 0 0 0 0 0 Upper Meadow NA
2516 3 2019 R24_NORTH COGR4 6 0 0 0 0 0 Upper Meadow NA
2517 3 2019 R24_NORTH COPA3 6 0 0 0 0 0 Upper Meadow NA
2518 3 2019 R24_NORTH DAUN 5 0 0 0 0 0 Upper Meadow UPL
2519 3 2019 R24_NORTH DECE 4 8 3 0 0 0 Upper Meadow FACU
2520 3 2019 R24_NORTH DEDA 4 0 0 0 0 0 Upper Meadow FACU
2521 3 2019 R24_NORTH DEUN2 6 0 0 0 0 0 Upper Meadow NA
2522 3 2019 R24_NORTH DRVE2 6 0 0 0 0 0 Upper Meadow NA
2523 3 2019 R24_NORTH ELEL5 4 0 0 0 0 0 Upper Meadow FACU
2524 3 2019 R24_NORTH ELGL 4 0 0 0 0 0 Upper Meadow FACU
2525 3 2019 R24_NORTH ELTR7 3 0 0 0 0 0 Upper Meadow FAC
2526 3 2019 R24_NORTH EPBR3 6 0 0 0 0 0 Upper Meadow NA
2527 3 2019 R24_NORTH EPCI 2 4 1 0 0 0 Upper Meadow FACW
2528 3 2019 R24_NORTH EPPY4 1 0 0 0 0 0 Upper Meadow OBL
2529 3 2019 R24_NORTH EQAR 3 0 0 0 0 0 Upper Meadow FAC
2530 3 2019 R24_NORTH EQLA 2 0 0 0 0 0 Upper Meadow FACW
2531 3 2019 R24_NORTH ERCI6 6 0 0 0 0 0 Upper Meadow NA
2532 3 2019 R24_NORTH ERNA10 6 0 0 0 0 0 Upper Meadow NA
2533 3 2019 R24_NORTH ERPR 6 0 0 0 0 0 Upper Meadow NA
2534 3 2019 R24_NORTH GNPA 2 0 1 0 0 0 Upper Meadow FACW
2535 3 2019 R24_NORTH HIVU2 1 0 0 0 0 0 Upper Meadow OBL
2536 3 2019 R24_NORTH HOBR2 2 0 0 0 0 0 Upper Meadow FACW
2537 3 2019 R24_NORTH IVAX 3 0 0 0 0 0 Upper Meadow FAC
2538 3 2019 R24_NORTH JUBA 1 0 0 0 0 0 Upper Meadow OBL
2539 3 2019 R24_NORTH JUBU 2 0 0 0 0 0 Upper Meadow FACW
2540 3 2019 R24_NORTH JUNCU 2 0 0 0 0 0 Upper Meadow FACW
2541 3 2019 R24_NORTH JUNE 2 0 0 0 0 0 Upper Meadow FACW
2542 3 2019 R24_NORTH JUOR 2 0 0 0 0 0 Upper Meadow FACW
2543 3 2019 R24_NORTH LEMO4 6 0 0 0 0 0 Upper Meadow NA
2544 3 2019 R24_NORTH LOMA3 6 0 0 0 0 0 Upper Meadow NA
2545 3 2019 R24_NORTH LONU2 4 0 0 0 0 0 Upper Meadow FACU
2546 3 2019 R24_NORTH LUBR3 6 0 0 0 0 0 Upper Meadow NA
2547 3 2019 R24_NORTH LULE2 6 0 0 0 0 0 Upper Meadow NA
2548 3 2019 R24_NORTH MACI 6 0 0 0 0 0 Upper Meadow NA
2549 3 2019 R24_NORTH MAGL2 4 0 0 0 0 0 Upper Meadow FACU
2550 3 2019 R24_NORTH MIGR 4 0 0 1 0 0 Upper Meadow FACU
2551 3 2019 R24_NORTH MIGU 1 0 0 0 0 0 Upper Meadow OBL
2552 3 2019 R24_NORTH MOLI4 3 0 0 0 0 0 Upper Meadow FAC
2553 3 2019 R24_NORTH MURI 3 0 0 0 0 0 Upper Meadow FAC
2554 3 2019 R24_NORTH MYMI2 1 0 0 0 0 0 Upper Meadow OBL
2555 3 2019 R24_NORTH NALE 1 0 0 0 0 0 Upper Meadow OBL
2556 3 2019 R24_NORTH PEBO2 6 0 0 0 0 0 Upper Meadow NA
2557 3 2019 R24_NORTH PELE5 6 0 0 0 0 0 Upper Meadow NA
2558 3 2019 R24_NORTH PEPA21 3 2 1 0 0 0 Upper Meadow FAC
2559 3 2019 R24_NORTH PERY 4 0 0 0 0 0 Upper Meadow FACU
2560 3 2019 R24_NORTH PLMO 2 0 0 0 0 0 Upper Meadow FACW
2561 3 2019 R24_NORTH POA 3 1 0 0 0 0 Upper Meadow FAC
2562 3 2019 R24_NORTH POBU 4 0 0 0 0 0 Upper Meadow FACU
2563 3 2019 R24_NORTH PODO4 4 0 0 0 1 0 Upper Meadow FACU
2564 3 2019 R24_NORTH POGR9 3 0 0 0 0 0 Upper Meadow FAC
2565 3 2019 R24_NORTH POMI4 2 7 6 0 0 0 Upper Meadow FACW
2566 3 2019 R24_NORTH POPO4 2 6 5 0 0 0 Upper Meadow FACW
2567 3 2019 R24_NORTH POPR 3 0 0 0 0 0 Upper Meadow FAC
2568 3 2019 R24_NORTH POSE 4 0 0 0 0 0 Upper Meadow FACU
2569 3 2019 R24_NORTH PYHI 6 0 0 0 0 0 Upper Meadow NA
2570 3 2019 R24_NORTH RAAL 2 0 1 0 0 0 Upper Meadow FACW
2571 3 2019 R24_NORTH RAOC 2 0 1 0 0 0 Upper Meadow FACW
2572 3 2019 R24_NORTH RUPA 3 0 0 0 0 0 Upper Meadow FAC
2573 3 2019 R24_NORTH RUSA 2 0 0 0 0 0 Upper Meadow FACW
2574 3 2019 R24_NORTH SEIN2 4 0 0 0 0 0 Upper Meadow FACU
2575 3 2019 R24_NORTH SENEC 4 0 0 0 0 0 Upper Meadow FACU
2576 3 2019 R24_NORTH SINU 6 0 0 0 0 0 Upper Meadow NA
2577 3 2019 R24_NORTH SIOR 2 0 0 0 0 0 Upper Meadow FACW
2578 3 2019 R24_NORTH SOLID 6 0 0 0 0 0 Upper Meadow NA
2579 3 2019 R24_NORTH STLO2 2 0 0 0 0 0 Upper Meadow FACW
2580 3 2019 R24_NORTH STOC2 5 1 1 0 0 0 Upper Meadow UPL
2581 3 2019 R24_NORTH SYSP 3 0 0 0 0 0 Upper Meadow FAC
2582 3 2019 R24_NORTH TAOF 4 0 0 0 0 0 Upper Meadow FACU
2583 3 2019 R24_NORTH TRLO 3 0 2 2 0 0 Upper Meadow FAC
2584 3 2019 R24_NORTH VEPE 1 0 0 1 0 0 Upper Meadow OBL
2585 3 2019 R24_NORTH VIBE2 6 0 0 0 0 0 Upper Meadow NA
2586 3 2019 R24_NORTH ROCK NA 0 0 0 0 0 Upper Meadow NA
2587 3 2019 R24_NORTH BARE GROUND NA 0 0 0 0 8 Upper Meadow NA
2588 3 2019 R24_NORTH MOSS NA 0 0 0 0 0 Upper Meadow NA
2589 3 2019 R24_NORTH PLANT BASE NA 0 0 0 0 2 Upper Meadow NA
2590 3 2019 R24_NORTH DRIED MOSS NA 0 0 0 0 0 Upper Meadow NA
2591 3 2019 R24_NORTH COWPIE NA 0 0 0 0 1 Upper Meadow NA
2592 3 2019 R24_NORTH LITTER NA 0 0 0 0 39 Upper Meadow NA
2593 3 2019 R24_SOUTH ACAM4 4 2 2 0 0 0 Upper Meadow FACU
2594 3 2019 R24_SOUTH ACMI2 4 0 0 0 0 0 Upper Meadow FACU
2595 3 2019 R24_SOUTH AGGL 3 1 8 0 0 0 Upper Meadow FAC
2596 3 2019 R24_SOUTH AGHE 5 0 0 0 0 0 Upper Meadow UPL
2597 3 2019 R24_SOUTH ALAE 1 0 0 0 0 0 Upper Meadow OBL
2598 3 2019 R24_SOUTH ALCA 5 0 0 0 0 0 Upper Meadow UPL
2599 3 2019 R24_SOUTH ALLE 5 0 0 0 0 0 Upper Meadow UPL
2600 3 2019 R24_SOUTH ALLIU 6 0 0 0 0 0 Upper Meadow NA
2601 3 2019 R24_SOUTH ANLU2 5 0 0 0 0 0 Upper Meadow UPL
2602 3 2019 R24_SOUTH ARAR8 5 0 0 0 0 0 Upper Meadow UPL
2603 3 2019 R24_SOUTH ARCA 4 2 0 0 0 0 Upper Meadow FACU
2604 3 2019 R24_SOUTH ARTR2 5 0 0 0 0 0 Upper Meadow UPL
2605 3 2019 R24_SOUTH ASLE 5 0 0 0 0 0 Upper Meadow UPL
2606 3 2019 R24_SOUTH SYSP 3 0 0 0 0 0 Upper Meadow FAC
2607 3 2019 R24_SOUTH ASPU9 5 0 0 0 0 0 Upper Meadow UPL
2608 3 2019 R24_SOUTH BAHO 5 0 0 0 0 0 Upper Meadow UPL
2609 3 2019 R24_SOUTH BIBI5 2 0 0 0 0 0 Upper Meadow FACW
2610 3 2019 R24_SOUTH BRTE 5 0 0 0 0 0 Upper Meadow UPL
2611 3 2019 R24_SOUTH CAAT25 6 0 0 0 0 0 Upper Meadow NA
2612 3 2019 R24_SOUTH CATT3 2 0 0 0 0 0 Upper Meadow FACW
2613 3 2019 R24_SOUTH CADO2 3 0 0 0 0 0 Upper Meadow FAC
2614 3 2019 R24_SOUTH CAFE4 3 13 6 1 0 0 Upper Meadow FAC
2615 3 2019 R24_SOUTH CAFI 6 0 0 0 0 0 Upper Meadow NA
2616 3 2019 R24_SOUTH CAIN10 1 0 0 0 0 0 Upper Meadow OBL
2617 3 2019 R24_SOUTH CANE2 1 1 0 0 0 0 Upper Meadow OBL
2618 3 2019 R24_SOUTH CAQU2 2 0 0 0 0 0 Upper Meadow FACW
2619 3 2019 R24_SOUTH CASI2 1 0 0 0 0 0 Upper Meadow OBL
2620 3 2019 R24_SOUTH CATE26 4 0 0 0 0 0 Upper Meadow FACU
2621 3 2019 R24_SOUTH CAUT 1 0 0 0 0 0 Upper Meadow OBL
2622 3 2019 R24_SOUTH CISC2 3 0 0 0 0 0 Upper Meadow FAC
2623 3 2019 R24_SOUTH CLRU2 6 0 0 0 0 0 Upper Meadow NA
2624 3 2019 R24_SOUTH COGR4 6 0 0 0 0 0 Upper Meadow NA
2625 3 2019 R24_SOUTH COPA3 6 0 0 0 0 0 Upper Meadow NA
2626 3 2019 R24_SOUTH DAUN 5 0 0 0 0 0 Upper Meadow UPL
2627 3 2019 R24_SOUTH DECE 4 2 0 0 0 0 Upper Meadow FACU
2628 3 2019 R24_SOUTH DEDA 4 2 0 0 0 0 Upper Meadow FACU
2629 3 2019 R24_SOUTH DEUN2 6 0 0 0 0 0 Upper Meadow NA
2630 3 2019 R24_SOUTH DRVE2 6 0 0 0 0 0 Upper Meadow NA
2631 3 2019 R24_SOUTH ELEL5 4 0 0 0 0 0 Upper Meadow FACU
2632 3 2019 R24_SOUTH ELGL 4 0 0 0 0 0 Upper Meadow FACU
2633 3 2019 R24_SOUTH ELTR7 3 0 0 0 0 0 Upper Meadow FAC
2634 3 2019 R24_SOUTH EPBR3 6 0 0 0 0 0 Upper Meadow NA
2635 3 2019 R24_SOUTH EPCI 2 5 0 0 0 0 Upper Meadow FACW
2636 3 2019 R24_SOUTH EPPY4 1 0 0 0 0 0 Upper Meadow OBL
2637 3 2019 R24_SOUTH EQAR 3 0 0 0 0 0 Upper Meadow FAC
2638 3 2019 R24_SOUTH EQLA 2 0 0 0 0 0 Upper Meadow FACW
2639 3 2019 R24_SOUTH ERCI6 6 0 0 0 0 0 Upper Meadow NA
2640 3 2019 R24_SOUTH ERNA10 6 0 0 0 0 0 Upper Meadow NA
2641 3 2019 R24_SOUTH ERPR 6 0 0 0 0 0 Upper Meadow NA
2642 3 2019 R24_SOUTH GNPA 2 0 0 0 0 0 Upper Meadow FACW
2643 3 2019 R24_SOUTH HIVU2 1 0 0 0 0 0 Upper Meadow OBL
2644 3 2019 R24_SOUTH HOBR2 2 0 1 0 0 0 Upper Meadow FACW
2645 3 2019 R24_SOUTH IVAX 3 0 0 0 0 0 Upper Meadow FAC
2646 3 2019 R24_SOUTH JUBA 1 0 0 0 0 0 Upper Meadow OBL
2647 3 2019 R24_SOUTH JUBU 2 0 0 0 0 0 Upper Meadow FACW
2648 3 2019 R24_SOUTH JUNCU 2 0 0 0 0 0 Upper Meadow FACW
2649 3 2019 R24_SOUTH JUNE 2 0 0 0 0 0 Upper Meadow FACW
2650 3 2019 R24_SOUTH JUOR 2 0 0 0 0 0 Upper Meadow FACW
2651 3 2019 R24_SOUTH LEMO4 6 0 0 0 0 0 Upper Meadow NA
2652 3 2019 R24_SOUTH LOMA3 6 0 0 0 0 0 Upper Meadow NA
2653 3 2019 R24_SOUTH LONU2 4 0 0 0 0 0 Upper Meadow FACU
2654 3 2019 R24_SOUTH LUBR3 6 0 0 0 0 0 Upper Meadow NA
2655 3 2019 R24_SOUTH LULE2 6 0 0 0 0 0 Upper Meadow NA
2656 3 2019 R24_SOUTH MACI 6 0 0 0 0 0 Upper Meadow NA
2657 3 2019 R24_SOUTH MAGL2 4 0 0 0 0 0 Upper Meadow FACU
2658 3 2019 R24_SOUTH MIGR 4 1 0 0 0 0 Upper Meadow FACU
2659 3 2019 R24_SOUTH MIGU 1 0 0 0 0 0 Upper Meadow OBL
2660 3 2019 R24_SOUTH MOLI4 3 0 0 0 0 0 Upper Meadow FAC
2661 3 2019 R24_SOUTH MURI 3 0 0 0 0 0 Upper Meadow FAC
2662 3 2019 R24_SOUTH MYMI2 1 0 0 0 0 0 Upper Meadow OBL
2663 3 2019 R24_SOUTH NALE 1 0 0 0 0 0 Upper Meadow OBL
2664 3 2019 R24_SOUTH PEBO2 6 0 0 0 0 0 Upper Meadow NA
2665 3 2019 R24_SOUTH PELE5 6 0 0 0 0 0 Upper Meadow NA
2666 3 2019 R24_SOUTH PEPA21 3 1 0 0 0 0 Upper Meadow FAC
2667 3 2019 R24_SOUTH PERY 4 0 0 0 0 0 Upper Meadow FACU
2668 3 2019 R24_SOUTH PLMO 2 0 0 0 0 0 Upper Meadow FACW
2669 3 2019 R24_SOUTH POA 3 0 0 0 0 0 Upper Meadow FAC
2670 3 2019 R24_SOUTH POBU 4 0 0 0 0 0 Upper Meadow FACU
2671 3 2019 R24_SOUTH PODO4 4 0 0 0 0 0 Upper Meadow FACU
2672 3 2019 R24_SOUTH POGR9 3 0 0 0 0 0 Upper Meadow FAC
2673 3 2019 R24_SOUTH POMI4 2 7 3 0 0 0 Upper Meadow FACW
2674 3 2019 R24_SOUTH POPO4 2 10 5 1 0 0 Upper Meadow FACW
2675 3 2019 R24_SOUTH POPR 3 0 0 0 0 0 Upper Meadow FAC
2676 3 2019 R24_SOUTH POSE 4 0 0 0 0 0 Upper Meadow FACU
2677 3 2019 R24_SOUTH PYHI 6 0 0 0 0 0 Upper Meadow NA
2678 3 2019 R24_SOUTH RAAL 2 0 0 0 0 0 Upper Meadow FACW
2679 3 2019 R24_SOUTH RAOC 2 0 0 0 0 0 Upper Meadow FACW
2680 3 2019 R24_SOUTH RUPA 3 0 0 0 0 0 Upper Meadow FAC
2681 3 2019 R24_SOUTH RUSA 2 0 0 0 0 0 Upper Meadow FACW
2682 3 2019 R24_SOUTH SEIN2 4 0 0 0 0 0 Upper Meadow FACU
2683 3 2019 R24_SOUTH SENEC 4 0 0 0 0 0 Upper Meadow FACU
2684 3 2019 R24_SOUTH SINU 6 0 0 0 0 0 Upper Meadow NA
2685 3 2019 R24_SOUTH SIOR 2 0 0 0 0 0 Upper Meadow FACW
2686 3 2019 R24_SOUTH SOLID 6 0 0 0 0 0 Upper Meadow NA
2687 3 2019 R24_SOUTH STLO2 2 0 0 0 0 0 Upper Meadow FACW
2688 3 2019 R24_SOUTH STOC2 5 1 0 0 0 0 Upper Meadow UPL
2689 3 2019 R24_SOUTH SYSP 3 0 0 0 0 0 Upper Meadow FAC
2690 3 2019 R24_SOUTH TAOF 4 1 0 0 0 0 Upper Meadow FACU
2691 3 2019 R24_SOUTH TRLO 3 0 2 0 0 0 Upper Meadow FAC
2692 3 2019 R24_SOUTH VEPE 1 0 0 0 0 0 Upper Meadow OBL
2693 3 2019 R24_SOUTH VIBE2 6 0 0 0 0 0 Upper Meadow NA
2694 3 2019 R24_SOUTH ROCK NA 0 0 0 0 0 Upper Meadow NA
2695 3 2019 R24_SOUTH BARE GROUND NA 0 0 0 0 8 Upper Meadow NA
2696 3 2019 R24_SOUTH MOSS NA 0 0 0 0 0 Upper Meadow NA
2697 3 2019 R24_SOUTH PLANT BASE NA 0 0 0 0 2 Upper Meadow NA
2698 3 2019 R24_SOUTH DRIED MOSS NA 0 0 0 0 0 Upper Meadow NA
2699 3 2019 R24_SOUTH COWPIE NA 0 0 0 0 1 Upper Meadow NA
2700 3 2019 R24_SOUTH LITTER NA 0 0 0 0 39 Upper Meadow NA
2

The error is occurring before pivot_wider. I think the following line is causing the problem:

summarise(sum_layer1 = sum(LAYER_1)(Location_fac, RATING_fac))

I'm not sure what (Location_fac, RATING_fac) is intended to be doing, but it is not correct syntax.

Also, the group_by is not causing an error, but it is also not doing anything because no grouping columns have been entered.

3

You made at least 3 errors in your code: 1) No arguments to group_by, 2) Wrong syntax in "sum_layer1 = sum(LAYER_1)(Location_fac, RATING_fac)" , 3) ungroup() should be done before pivoting wider

4

This topic was automatically closed 21 days after the last reply. New replies are no longer allowed.

If you have a query related to it or one of the replies, start a new topic and refer back with a link.