Em Andamento

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

destination_ip
attachments - as coincides with Protocol = Microsoft
hashes
sha512
md5
description
identifier
honeypot
hpfeed_id



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:

jonathancarroll

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)
4.2

18 freelancers estão ofertando em média £113 para este trabalho

kmittal

A proposal has not yet been provided

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

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)
5.2
aberkanefouad

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)
4.5
gokulanand

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)
4.4
d2imatrix

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)
4.2
sajidmahmud

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)
4.2
numberNmatrix

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)
3.3
mirabueno319

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)
2.9
swolf1981

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)
2.3
DevDataAnalyst

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)
2.3
naveenthourani

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)
2.3
abhinovpankaj

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)
1.9
akashagoyal

A proposal has not yet been provided

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

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)
1.0
ayanbishnu

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 [url removed, login to view] IF you need see some samples of my work, then, pleas Mais

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

Bir öneri henüz sağlanmadı

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

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)
0.0
harukomcgovern

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)
0.0
kapil69

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)
0.0