Question: How do I extract the numerical part from the below in R and proceed with calculations? Example of my data: Rs 3,94,24,827 ~ 3 Crore+

How do I extract the numerical part from the below in R and proceed with calculations?

Example of my data:

Rs 3,94,24,827 ~ 3 Crore+

Rs 75,106 ~ 75 Thou+

Required result: Rs 3,94,24,827 ~ 3 Crore+ to 39424827

Rs 75,106 ~ 75 Thou+ to 75106

Also how to merge two excel sheets in R using the common column name?

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Mathematics Questions!

Q:

1. Calculate the cost of each capital component, after-tax cost of debt, cost of preferred, and cost of equity with the DCF method and CAPM method. 2. What do you estimate the company?s WACC? Please...

Q:

MATHEMATICS FOR MACHINE LEARNING Marc Peter Deisenroth A. Aldo Faisal Cheng Soon Ong Contents Foreword 1 Part I Mathematical Foundations 9 1 Introduction and Motivation 11 1.1 Finding Words for...

Q:

The research firm LL Research collected data from 200 client businesses. They want to determine how the businesses compare among four variables: 2015 Profit in millions of dollars 2016 Profit in...

Q:

Sheet1 Sheet2 Historical sales data 9 3 2231 976 4 2861 677 12 1986 1067 UAE Oman Kuwait KSA Bahrain 1 1864 1411 649 4620 361 2 2489 1014 500 5518 490 Week 6 1347 926 $21 1370 632 5 2144 686 566 S017...

Q:

In this part, you are required to use Excel software and a sample of 838 real mutual funds to answer the following questions. Please provide your answer in Excel worksheet. Construct a summary table...

Q:

A. B. A. B. ( ( ) ) Beginning and Intermediate Algebra An open source (CC-BY) textbook Available for free download at: http://wallace.ccfaculty.org/book/book.html by Tyler Wallace 1 ISBN...

Q:

This assignment asks you to write bash shell scripts to compute matrix operations. The purpose is to get you familiar with the Unix shell, shell programming, Unix utilities, standard input, output,...

Q:

This assignment asks you to write bash shell scripts to compute matrix operations. The purpose is to get you familiar with the Unix shell, shell programming, Unix utilities, standard input, output,...

Q:

This assignment asks you to write bash shell scripts to compute matrix operations. The purpose is to get you familiar with the Unix shell, shell programming, Unix utilities, standard input, output,...

Q:

This assignment asks you to write bash shell scripts to compute matrix operations. The purpose is to get you familiar with the Unix shell, shell programming, Unix utilities, standard input, output,...

Q:

Use SQL and the Colonial Adventure Tours database to complete the following exercises. Provide screen snips of query outputs 5. List the customer number, customer last name, and customer first name...

Q:

Assume that in silver metal there is one free electron per silver atom. Compute the free electron density for silver, and compare it to the value given in Exercise 25.2.

Q:

The following are comparative balance sheets for Whispering Winds Company \ table [ [ Whispering Winds Compariy Comparative Balance Sheets December 3 1 ] , [ Assets , 2 0 2 2 , 2 0 2 1 ] , [ Cash , $...

Q:

Lapangan Golf Cakram P2-1A McKay dibuka pada tanggal 1 Maret oleh Evan McKay. Berikut ini peristiwa dan transaksi terpilih yang terjadi selama bulan Maret. 1 Maret Menginvestasikan uang tunai sebesar...