Pivot tables in R

I have some CSV files and would like to analyse in R.

But being an R beginner, just getting frustrated, and thinking of just using Excel.

There us a date field eg 2014-10-26T23:23:[url removed, login to view] which i guess i need to split into date and time ...

Plus I would like to get a feel for the equivalent of a pivot table, so I can summarize the results .

1 frequency count of source_ip addresses - sorted by most frequent

2 frequency count of destination_port - sorted by most frequent

3 table combining 1 and 2

4 graph of number occurrences per day from timestamp

5 graph of number occurrences per hour of each day from timestamp

6 pivot table of days / hours and their counts.

7 counts per protocol per day

I would like to do this in "R", not Excel, that is my fall back if I cant solve in "R"

these columns can be discarded

attachments - as coincides with Protocol = Microsoft

Habilidades: Processamento de dados, Linguagem de Programação R, Estatísticas

Ver mais: statistics R, pivot tables, pivot table excel, in r, excel PIVOT, excel pivot table, analyse some data, excel frequency table, summarize data graph excel, excel timestamp, analyse data table excel, defining pivot data source macro, excel graph days, graph days excel, tables students results university database, split addresses excel, graph csv data excel, count number occurrences excel, change pivot table source, excel graph per hour, csv pivot table, trixbox source ip cdr, software open source ip camara, processing statistics excel, open source ip city country sweden database

Acerca do Empregador:
( 0 comentários ) Plymouth, United Kingdom

ID do Projeto: #6812854

Premiar a:


Hi, I'm a theoretical physicist/data analyst and I work primarily in R. I do the types of processing you've described on a daily basis (aggregating fisheries data at the moment) and I'd be happy to point you in the rig Mais

£72 GBP em 5 dias
(11 Avaliações)

18 freelancers are bidding on average £113 for this job


A proposal has not yet been provided

£200 GBP in 5 dias
(19 Comentários)

Hey, I guess I can help you with the tasks. I would finish within one/two days. Regards. _____________

£150 GBP in 3 dias
(28 Comentários)

Hello, R expert here, I have already earned a USA certificate on R pogramming: [url removed, login to view] I would be very happy to inform you that I am Mais

£250 GBP in 3 dias
(8 Comentários)

Hello, If you want the specified things to do it in Excel, I can help you out. Let me know if you are interested. Thanks

£60 GBP em 1 dia
(11 Comentários)

Hi, We can write the code in r so that you first get the data converted from txt file and then get the tables one after other based on your requirements. If this works kindly let us know. Webhave years of experiance o Mais

£55 GBP in 3 dias
(7 Comentários)

Dear sir I am ready to start your job, if you give me chance I can do it properly and right time delivery. Thanks

£100 GBP em 1 dia
(56 Comentários)

I have worked for many projects in R programming as you can see from my profile. What you need (7 points that you indicated) is not a problem for me. From my quick doing, I show you the five most frequent source_ip wit Mais

£50 GBP in 2 dias
(5 Comentários)

I can do this for you. I am proficient in Microsoft Excel. I work fast and accurately. Please award me this project.

£100 GBP in 2 dias
(7 Comentários)

I have dealt with many file I/O issues using R. It does look like you have some data clean-up issues with your [url removed, login to view] file that would require pre-processing. Specifically, any entry with a microsoft-ds protocol Mais

£90 GBP in 3 dias
(3 Comentários)

Hi i saw your text file attached , however i think you need to provide a CSV file so that i can neatly feed it to R . also i can help you with the pivot table issue by using a open source [url removed, login to view] me here if you ne Mais

£150 GBP in 3 dias
(3 Comentários)

Hello. I am expert in microsoft excel. My first priority is satisfaction of my clients. If you give me a chance, I promise to deliver you quality work in agreed time. Thanks. You can check my profile for assurance.

£88 GBP in 2 dias
(5 Comentários)

Hi, I am working as software professional in IT industry from last 4 years. I work on VB scripting along with VBA for MS office applications. Also developed various Desktop based application using Visual Studio Mais

£94 GBP in 3 dias
(2 Comentários)

A proposal has not yet been provided

£88 GBP in 2 dias
(1 Comentário)

My self Ph.D. in advanced analytics and deliver and develop projects using open source R (including in-memory computing), and can deliver your requirement with R, accompanied by a step-by-step word document, what each Mais

£125 GBP in 3 dias
(1 Comentário)

Hi I can assure you that i am having the best excel experience and i can do almost everything possible with excel. Please check my review in IF you need see some samples of my work, then, pleas Mais

£105 GBP in 2 dias
(2 Comentários)

Bir öneri henüz sağlanmadı

£244 GBP in 3 dias
(0 Comentários)

Hi, I have prepared a Frequency count of Source IP address from the text file. If you could message me or gimme you email address then I can send you attachment, as here is no option for attachment in proposal. Mais

£88 GBP em 1 dia
(0 Comentários)

Hello, My name is Haruko. I am a qualified business and financial analyst. I do this type of work quite regularly and am sure you would be happy with the results. Look forward to hearing from you.

£111 GBP in 2 dias
(0 Comentários)

I work from Noida, India and completely understand your requirements. I have extensive experience in Excel and can do a good job for you

£111 GBP in 3 dias
(0 Comentários)