我想求每一个公司每年带有某几个关键词的无形资产占当年所有无形资产总额的比例,代码应该怎么写呢?求各位大佬指导!
input str12 Stkcd int Accper str90 Fn02202 float intandetail str17 Fn02207
"000008" 2016 "土地使用权" . "55525745.19"
"000008" 2016 "专利权" . "52891331.97"
"000008" 2016 "特许权" . "8253289.33"
"000008" 2016 "著作权" . "47644137.84"
"000008" 2016 "合计" 8 "168491630.86"
"000008" 2016 "软件使用权" 1 "4177126.53"
"000008" 2017 "土地使用权" . "54337463.43"
"000008" 2017 "合计" 8 "199665232.82"
"000008" 2017 "特许权" . "5934011.02"
"000008" 2017 "著作权" . "80754408.81999999"
"000008" 2017 "非专利技术" . "11549516.54"
"000008" 2017 "专利权" . "42214337.23"
"000008" 2017 "软件使用权" 1 "4875495.78"
"000008" 2018 "特许权" . "3629831"
"000008" 2018 "软件使用权" 1 "23994115.09"
"000008" 2018 "著作权" . "73169798.81999999"
"000008" 2018 "土地使用权" . "53149181.67"
"000008" 2018 "专利权" . "32889043.43"
"000008" 2018 "非专利技术" . "47095486.11"
"000008" 2018 "合计" 8 "233927456.12"
"000008" 2019 "著作权" . "65585188.82"
"000008" 2019 "土地使用权" . "51959274.51"
"000008" 2019 "特许权" . "2910693.28"
"000008" 2019 "软件使用权" 1 "58325333.52"
"000008" 2019 "专利权" . "52197881.77"
"000008" 2019 "非专利技术" . "49931211.95"
"000008" 2019 "合计" 8 "280909583.85"
"000008" 2020 "土地使用权" . "51573216.15"
"000008" 2020 "专利权" . "52057899.71"
"000008" 2020 "非专利技术" . "118540841.86"
"000008" 2020 "软件使用权" 1 "67077751.3"
"000008" 2020 "著作权" . "44370458.25"
"000008" 2020 "特许权" . "1174258.35"
"000008" 2020 "合计" 8 "334794425.62"
"000016" 2016 "其他" . "34725356.29"
"000016" 2016 "专利权" . "3587564.29"
"000016" 2016 "土地使用权" . "263625762.35"
"000016" 2016 "国外商标注册费" . "106944.51"
"000016" 2016 "合计" 8 "302045627.44"
"000016" 2017 "专利及专有技术" . "2912902.19"
"000016" 2017 "合计" 8 "205057773.69"
"000016" 2017 "国外注册商标" . ""
"000016" 2017 "土地使用权" . "162254827.18"
"000016" 2017 "其他" . "39890044.32"
"000016" 2018 "特许经营权" . "104387587.51"
"000016" 2018 "土地使用权" . "399878521.97"
"000016" 2018 "合计" 8 "737776686.34"
"000016" 2018 "专利及专有技术" . "146296459.69"
"000016" 2018 "软件使用权及其他" 1 "45088626.96"
"000016" 2018 "商标权" . "42125490.21"
"000016" 2019 "合计" 8 "1213271713.22"
"000016" 2019 "土地使用权" . "947665449.77"
"000016" 2019 "特许经营权" . "95466281.59999999"
"000016" 2019 "软件使用权及其他" 1 "56716076.38"
"000016" 2019 "知识产权商标权" . "70210395.95999999"
"000016" 2019 "专利及专有技术" . "43213509.51"
"000016" 2020 "特许经营权" . "91024256.59999999"
"000016" 2020 "合计" 8 "1189191001.51"
"000016" 2020 "软件使用权及其他" 1 "62968096.35"
"000016" 2020 "知识产权商标权" . "70215164.48"
"000016" 2020 "土地使用权" . "948183664.78"
"000016" 2020 "专利及专有技术" . "16799819.3"
"000017" 2016 "合计" 8 "3012000"
"000017" 2016 "商标" . "3012000"
"000017" 2017 "商标权" . "2259000"
"000017" 2017 "合计" 8 "2259000"
"000017" 2018 "合计" 8 "1506000"
"000017" 2018 "商标权" . "1506000"
"000017" 2019 "合计" 8 "753000"
"000017" 2019 "商标权" . "753000"
"000017" 2020 "合计" 8 ""
"000017" 2020 "商标权" . ""
"000020" 2016 "土地使用权" . "44618390.91"
"000020" 2016 "合计" 8 "44878095.77"
"000020" 2016 "计算机软件" 1 "259704.86"
"000020" 2017 "合计" 8 "43307316.37"
"000020" 2017 "土地使用权" . "43097497.43"
"000020" 2017 "计算机软件" 1 "209818.94"
"000020" 2018 "土地使用权" . "41655756.72"
"000020" 2018 "合计" 8 "41815689.74"
"000020" 2018 "计算机软件" 1 "159933.02"
"000020" 2019 "土地使用权" . "40210267.83"
"000020" 2019 "计算机软件" 1 "2758332.61"
"000020" 2019 "合计" 8 "42968600.44"
"000020" 2020 "合计" 8 "40820657.8"
"000020" 2020 "土地使用权" . "38764778.94"
"000020" 2020 "计算机软件" 1 "2055878.86"
"000021" 2016 "土地使用权" . "141714732.25"
"000021" 2016 "合计" 8 "143829134.91"
"000021" 2016 "办公软件" 1 "2114402.66"
"000021" 2017 "土地使用权" . "228165089.35"
"000021" 2017 "办公软件" 1 "1503298.33"
"000021" 2017 "合计" 8 "229668387.68"
"000021" 2018 "土地使用权" . "569419619.73"
"000021" 2018 "办公软件" 1 "3472886.45"
"000021" 2018 "合计" 8 "572892506.1799999"
"000021" 2019 "合计" 8 "565497772.28"
"000021" 2019 "软件" 1 "3596271.96"
"000021" 2019 "土地使用权" . "561901500.3200001"
"000021" 2020 "合计" 8 "602580486.11"