Hello all!
I have a problem to group my data (years) in 10 years classes. For example
for year
year decade
1598 1590-1600
1599 1590-1600
1600 1590-1600
1601 1600-1610
---
my is like this>
[1] 1598 1599 1600 1601 1602 1603 1604 1605 1606 1607 1608 1609 1610 1611
1612
[16] 1613 1614 1615 1616 1617 1618 1619 1620 1621 1622 1623 1624 1625 1626
1627
[31] 1628 1629 1630 1631 1632 1633 1634 1635 1636 1637 1638 1639 1640 1641
1642
[46] 1643 1644 1645 1646 1647 1648 1649 1650 1651 1652 1653 1654 1655 1656
1657
[61] 1658 1659 1660 1661 1662 1663 1664 1665 1666 1667 1668 1669 1670 1671
1672
[76] 1673 1674 1675 1676 1677 1678 1679 1680 1681 1682 1683 1684 1685 1686
1687
[91] 1688 1689 1690 1691 1692 1693 1694 1695 1696 1697 1698 1699 1700 1701
1702
[106] 1703 1704 1705 1706 1707 1708 1709 1710 1711 1712 1713 1714 1715 1716
1717
[121] 1718 1719 1720 1721 1722 1723 1724 1725 1726 1727 1728 1729 1730 1731
1732
[136] 1733 1734 1735 1736 1737 1738 1739 1740 1741 1742 1743 1744 1745 1746
1747
[151] 1748 1749 1750 1751 1752 1753 1754 1755 1756 1757 1758 1759 1760 1761
1762
[166] 1763 1764 1765 1766 1767 1768 1769 1770 1771 1772 1773 1774 1775 1776
1777
[181] 1778 1779 1780 1781 1782 1783 1784 1785 1786 1787 1788 1789 1790 1791
1792
[196] 1793 1794 1795 1796 1797 1798 1799 1800 1801 1802 1803 1804 1805 1806
1807
[211] 1808 1809 1810 1811 1812 1813 1814 1815 1816 1817 1818 1819 1820 1821
1822
[226] 1823 1824 1825 1826 1827 1828 1829 1830 1831 1832 1833 1834 1835 1836
1837
[241] 1838 1839 1840 1841 1842 1843 1844 1845 1846 1847 1848 1849 1850 1851
1852
[256] 1853 1854 1855 1856 1857 1858 1859 1860 1861 1862 1863 1864 1865 1866
1867
[271] 1868 1869 1870 1871 1872 1873 1874 1875 1876 1877 1878 1879 1880 1881
1882
[286] 1883 1884 1885 1886 1887 1888 1889 1890 1891 1892 1893 1894 1895 1896
1897
[301] 1898 1899 1900 1901 1902 1903 1904 1905 1906 1907 1908 1909 1910 1911
1912
[316] 1913 1914 1915 1916 1917 1918 1919 1920 1921 1922 1923 1924 1925 1926
1927
[331] 1928 1929 1930 1931 1932 1933 1934 1935 1936 1937 1938 1939 1940 1941
1942
[346] 1943 1944 1945 1946 1947 1948 1949 1950 1951 1952 1953 1954 1955 1956
1957
[361] 1958 1959 1960 1961 1962 1963 1964 1965 1966 1967 1968 1969 1970 1971
1972
[376] 1973 1974 1975 1976 1977 1978 1979 1980 1981 1982 1983 1984 1985 1986
1987
[391] 1988 1989 1990 1991 1992 1993 1994 1995 1996 1997
Thank you!
--
---
Catalin-Constantin ROIBU
Lecturer PhD, Forestry engineer
Forestry Faculty of Suceava
Str. Universitatii no. 13, Suceava, 720229, Romania
office phone +4 0230 52 29 78, ext. 531
mobile phone +4 0745 53 18 01
+4 0766 71 76 58
FAX: +4 0230 52 16 64
silvic.usv.ro
[[alternative HTML version deleted]]
brs <- seq(1590,2000,by=10) lbs <- paste(brs[-length(brs)],brs[-1],sep="-") y <- cut(x,breaks=brs,labels=lbs) # Where "x" is your data vector. grpd <- data.frame(year=x,decade=y) head(grpd)> year decade > 1 1598 1590-1600 > 2 1599 1590-1600 > 3 1600 1590-1600 > 4 1601 1600-1610 > 5 1602 1600-1610 > 6 1603 1600-1610OK? cheers, Rolf Turner P.S. In future please provide your data using dput() to make it easier for helpers to read it in. R. T. On 04/07/2013 07:47 PM, catalin roibu wrote:> Hello all! > I have a problem to group my data (years) in 10 years classes. For example > for year > > year decade > 1598 1590-1600 > 1599 1590-1600 > 1600 1590-1600 > 1601 1600-1610 > --- > > my is like this> > > [1] 1598 1599 1600 1601 1602 1603 1604 1605 1606 1607 1608 1609 1610 1611 > 1612 > [16] 1613 1614 1615 1616 1617 1618 1619 1620 1621 1622 1623 1624 1625 1626 > 1627 > [31] 1628 1629 1630 1631 1632 1633 1634 1635 1636 1637 1638 1639 1640 1641 > 1642 > [46] 1643 1644 1645 1646 1647 1648 1649 1650 1651 1652 1653 1654 1655 1656 > 1657 > [61] 1658 1659 1660 1661 1662 1663 1664 1665 1666 1667 1668 1669 1670 1671 > 1672 > [76] 1673 1674 1675 1676 1677 1678 1679 1680 1681 1682 1683 1684 1685 1686 > 1687 > [91] 1688 1689 1690 1691 1692 1693 1694 1695 1696 1697 1698 1699 1700 1701 > 1702 > [106] 1703 1704 1705 1706 1707 1708 1709 1710 1711 1712 1713 1714 1715 1716 > 1717 > [121] 1718 1719 1720 1721 1722 1723 1724 1725 1726 1727 1728 1729 1730 1731 > 1732 > [136] 1733 1734 1735 1736 1737 1738 1739 1740 1741 1742 1743 1744 1745 1746 > 1747 > [151] 1748 1749 1750 1751 1752 1753 1754 1755 1756 1757 1758 1759 1760 1761 > 1762 > [166] 1763 1764 1765 1766 1767 1768 1769 1770 1771 1772 1773 1774 1775 1776 > 1777 > [181] 1778 1779 1780 1781 1782 1783 1784 1785 1786 1787 1788 1789 1790 1791 > 1792 > [196] 1793 1794 1795 1796 1797 1798 1799 1800 1801 1802 1803 1804 1805 1806 > 1807 > [211] 1808 1809 1810 1811 1812 1813 1814 1815 1816 1817 1818 1819 1820 1821 > 1822 > [226] 1823 1824 1825 1826 1827 1828 1829 1830 1831 1832 1833 1834 1835 1836 > 1837 > [241] 1838 1839 1840 1841 1842 1843 1844 1845 1846 1847 1848 1849 1850 1851 > 1852 > [256] 1853 1854 1855 1856 1857 1858 1859 1860 1861 1862 1863 1864 1865 1866 > 1867 > [271] 1868 1869 1870 1871 1872 1873 1874 1875 1876 1877 1878 1879 1880 1881 > 1882 > [286] 1883 1884 1885 1886 1887 1888 1889 1890 1891 1892 1893 1894 1895 1896 > 1897 > [301] 1898 1899 1900 1901 1902 1903 1904 1905 1906 1907 1908 1909 1910 1911 > 1912 > [316] 1913 1914 1915 1916 1917 1918 1919 1920 1921 1922 1923 1924 1925 1926 > 1927 > [331] 1928 1929 1930 1931 1932 1933 1934 1935 1936 1937 1938 1939 1940 1941 > 1942 > [346] 1943 1944 1945 1946 1947 1948 1949 1950 1951 1952 1953 1954 1955 1956 > 1957 > [361] 1958 1959 1960 1961 1962 1963 1964 1965 1966 1967 1968 1969 1970 1971 > 1972 > [376] 1973 1974 1975 1976 1977 1978 1979 1980 1981 1982 1983 1984 1985 1986 > 1987 > [391] 1988 1989 1990 1991 1992 1993 1994 1995 1996 1997 > > Thank you!
Hi, Try: year1<- 1598:1997 ?indx<-findInterval(year1,seq(1591,2000,by=10)) group<-seq(1590,2000,by=10) ind<-seq(1,length(group),by=1) labl1<-paste(group[ind],group[ind+1],sep="-")[-42] dat1<- data.frame(year=year1,decade=labl1[indx],stringsAsFactors=FALSE) head(dat1,5) #? year??? decade #1 1598 1590-1600 #2 1599 1590-1600 #3 1600 1590-1600 #4 1601 1600-1610 #5 1602 1600-1610 A.K. ----- Original Message ----- From: catalin roibu <catalinroibu at gmail.com> To: r-help at r-project.org Cc: Sent: Sunday, April 7, 2013 3:47 AM Subject: [R] group data in classes Hello all! I have a problem to group my data (years) in 10 years classes. For example for year year? ? decade 1598? 1590-1600 1599? 1590-1600 1600? 1590-1600 1601? 1600-1610 --- my is like this> [1] 1598 1599 1600 1601 1602 1603 1604 1605 1606 1607 1608 1609 1610 1611 1612 [16] 1613 1614 1615 1616 1617 1618 1619 1620 1621 1622 1623 1624 1625 1626 1627 [31] 1628 1629 1630 1631 1632 1633 1634 1635 1636 1637 1638 1639 1640 1641 1642 [46] 1643 1644 1645 1646 1647 1648 1649 1650 1651 1652 1653 1654 1655 1656 1657 [61] 1658 1659 1660 1661 1662 1663 1664 1665 1666 1667 1668 1669 1670 1671 1672 [76] 1673 1674 1675 1676 1677 1678 1679 1680 1681 1682 1683 1684 1685 1686 1687 [91] 1688 1689 1690 1691 1692 1693 1694 1695 1696 1697 1698 1699 1700 1701 1702 [106] 1703 1704 1705 1706 1707 1708 1709 1710 1711 1712 1713 1714 1715 1716 1717 [121] 1718 1719 1720 1721 1722 1723 1724 1725 1726 1727 1728 1729 1730 1731 1732 [136] 1733 1734 1735 1736 1737 1738 1739 1740 1741 1742 1743 1744 1745 1746 1747 [151] 1748 1749 1750 1751 1752 1753 1754 1755 1756 1757 1758 1759 1760 1761 1762 [166] 1763 1764 1765 1766 1767 1768 1769 1770 1771 1772 1773 1774 1775 1776 1777 [181] 1778 1779 1780 1781 1782 1783 1784 1785 1786 1787 1788 1789 1790 1791 1792 [196] 1793 1794 1795 1796 1797 1798 1799 1800 1801 1802 1803 1804 1805 1806 1807 [211] 1808 1809 1810 1811 1812 1813 1814 1815 1816 1817 1818 1819 1820 1821 1822 [226] 1823 1824 1825 1826 1827 1828 1829 1830 1831 1832 1833 1834 1835 1836 1837 [241] 1838 1839 1840 1841 1842 1843 1844 1845 1846 1847 1848 1849 1850 1851 1852 [256] 1853 1854 1855 1856 1857 1858 1859 1860 1861 1862 1863 1864 1865 1866 1867 [271] 1868 1869 1870 1871 1872 1873 1874 1875 1876 1877 1878 1879 1880 1881 1882 [286] 1883 1884 1885 1886 1887 1888 1889 1890 1891 1892 1893 1894 1895 1896 1897 [301] 1898 1899 1900 1901 1902 1903 1904 1905 1906 1907 1908 1909 1910 1911 1912 [316] 1913 1914 1915 1916 1917 1918 1919 1920 1921 1922 1923 1924 1925 1926 1927 [331] 1928 1929 1930 1931 1932 1933 1934 1935 1936 1937 1938 1939 1940 1941 1942 [346] 1943 1944 1945 1946 1947 1948 1949 1950 1951 1952 1953 1954 1955 1956 1957 [361] 1958 1959 1960 1961 1962 1963 1964 1965 1966 1967 1968 1969 1970 1971 1972 [376] 1973 1974 1975 1976 1977 1978 1979 1980 1981 1982 1983 1984 1985 1986 1987 [391] 1988 1989 1990 1991 1992 1993 1994 1995 1996 1997 Thank you! -- --- Catalin-Constantin ROIBU Lecturer PhD, Forestry engineer Forestry Faculty of Suceava Str. Universitatii no. 13, Suceava, 720229, Romania office phone? ? +4 0230 52 29 78, ext. 531 mobile phone? +4 0745 53 18 01 ? ? ? ? ? ? ? ? ? ? ? +4 0766 71 76 58 FAX:? ? ? ? ? ? ? ? +4 0230 52 16 64 silvic.usv.ro ??? [[alternative HTML version deleted]] ______________________________________________ R-help at r-project.org mailing list https://stat.ethz.ch/mailman/listinfo/r-help PLEASE do read the posting guide http://www.R-project.org/posting-guide.html and provide commented, minimal, self-contained, reproducible code.