Completed

R Studio: Download two text files each day, combine and find the percent of two columns

There is a website that posts two text files each day that I need downloaded into R Studio. I need a short and simple script that will do the requirements below.

Requirements

Download both text files into R Studio

Combine text files

Calculate the percent of two columns

Show only stocks that have total volume of over 1,000,000 and sort by percent

Both files are the same format, and a sample output is below;

20180223|A|155733|0|1221258|Q

20180223|AA|496762|2155|1111306|Q

20180223|AABA|440663|0|4473346|Q

20180223|AAC|44416|0|105355|Q

20180223|AADR|13722|0|15982|Q

20180223|AAL|474313|1492|831238|Q

20180223|AAMC|2|0|95|Q

20180223|AAN|25441|0|70706|Q

20180223|AAOI|384343|27668|801691|Q

20180223|AAON|15081|0|28154|Q

20180223|AAP|181737|0|373863|Q

20180223|AAPL|4049327|16850|9598594|Q

20180223|AAT|17663|0|82277|Q

20180223|AAU|20400|0|44298|Q

Skills: R Programming Language, Web Scraping

See more: merge multiple text files in r, count number of observations in r, r count rows by group, which r command creates a 2 by 2 matrix with the values 1,2,3 and 4?, plyr count, unclass function in r, r count frequency, r count number of occurrences in column, text files match numbers, java parse text files numbers, text files merge, search replace text files, java file parser find text files, search text files report java, excel macros create text files excel, translate text files spanish, mysql database hold text files, create html files text files, vbs merge text files, vbscripts text files

About the Employer:
( 6 reviews ) Duncan, Canada

Project ID: #16406566

Awarded to:

utkarshkatiyar19

i am an expert in R programming. i am sure that i can do your job. feel free to ping me. can have a chat.

$150 CAD in 7 days
(4 Reviews)
3.5

8 freelancers are bidding on average $161 for this job

mantislin

Hi sir, This is Lin and I am scraping expert, i have checked all details for your project. can we discuss more info then i can provide example data for you? Please message me then we can discuss more ASAP. Tha More

$181 CAD in 5 days
(214 Reviews)
7.2
anantpp

Hello I am a interested in your project So text me Then we will discuss

$277 CAD in 8 days
(0 Reviews)
0.0
$155 CAD in 5 days
(0 Reviews)
0.0
PavanKumar101

I have access to Windows, Mac, Linux, sot that I can test the script on various platforms and catch platform specific issues early.

$155 CAD in 10 days
(0 Reviews)
0.0
hurqui

Data scientist, professional in Information Systems and master in statistics, having excellent skills and abilities for teamwork, well-interpersonal communication, leadership skills, enterprising spirit and great initi More

$200 CAD in 10 days
(0 Reviews)
0.0
$35 CAD in 1 day
(0 Reviews)
0.0
$133 CAD in 2 days
(0 Reviews)
0.0