Creating an index using survey data

You can do all those things in R (and much more) for sure, but if you need more specific help, please provide a proper REPRoducible EXample (reprex) illustrating your issue.