Suoritettu

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

Taidot: R-ohjelmointikieli, Tietojen kaavinta verkosta

Näytä lisää: 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

Tietoa työnantajasta:
( 6 arvostelua ) Duncan, Canada

Projektin tunnus: #16406566

Myönnetty käyttäjälle:

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 7 päivässä
(4 Arvostelua)
3.5

8 freelanceria on tarjonnut keskimäärin 161$ tähän työhön

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 Lisää

$181 CAD 5 päivässä
(214 arvostelua)
7.2
anantpp

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

$277 CAD 8 päivässä
(0 arvostelua)
0.0
$155 CAD 5 päivässä
(0 arvostelua)
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 10 päivässä
(0 arvostelua)
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 Lisää

$200 CAD 10 päivässä
(0 arvostelua)
0.0
$35 CAD 1 päivässä
(0 arvostelua)
0.0
$133 CAD 2 päivässä
(0 arvostelua)
0.0