Group data and aggregate into new variables - Python

I have a data feed that gets updated every minute with marine traffic data by csv.

The plan is that when I have at least 2 updates per ship I will group the data by IMO number(unique ref per ship) then if the time between updates is < 1 minute I will compute the following;

Latest SOG - Previous SOG

I also want some kind of text output if the NAVSTAT has changed between updates.

This will be presented in a kind of live table which is updated every minute when the data gets updated however I will most probably just schedule using Cron.

Skills: Python, Data Processing

See more: report access chart linked group data, write scripts group data, perl group data according field, birla group data entry project, extracting data html file perl python, excel vba group data date hour, home biz group data wox, macro group data, excel macro group data, data type xml file python, work qlink group data entry work, excel script group data, macro will group data, python cron mysql, data processing machine learning python, data entry new comers, exploratory data analysis categorical variables python

About the Employer:
( 7 reviews ) chester, Spain

Project ID: #22743780

24 freelancers are bidding on average $135 for this job


Hello Sir, I am expert who understands the value of time. I pride myself in my attention to detail. I am very hard working and aim to deliver in less time than quoted. I want to make you, my employer happy without cha More

$220 USD in 4 days
(214 Reviews)

Hello, I'd be glad to develop the python tool that retrieved the desired data and aggregates it following your needs. Looking forward to chat with you soon for more details. Best regards.

$95 USD in 1 day
(147 Reviews)

I can provide you a Python script that will read CSV file (or several files) and for each unique IMO it will check the number of updates. If the time between updates less than 1 minute it will perform additional checks More

$120 USD in 1 day
(278 Reviews)

Hi, Nice to meet you! I have read your requirements carefully and I am very interesting for your project. I am confident of this project as I'm a professional Python expert with over 5 years of experience. [login to view URL] More

$140 USD in 7 days
(43 Reviews)

Hello, how are you? Thank you for your project posting. Here is Eric, skilled with professional python. As a senior web developer I can deliver good results with quality in time you want. Please invite me so that we ca More

$100 USD in 1 day
(15 Reviews)

Hello? How are you? I am excited to work with you on this project. I have done a lot of jobs with python like Django admin, Flask, python scrap, pysql, python tkinter GUI etc Here is on of my scrap with python wor More

$155 USD in 3 days
(55 Reviews)

Hi, I hope you're having a wonderful day i have done scrapping almost on Half of Worldwide web including eCommerce giants (Amazon, eBay, craigslist) News Feed, Social media websites, API's. I develop my own scr More

$175 USD in 7 days
(11 Reviews)

Hello Dear I have read your detailed post. Understand all. I'm a pro python developer. and I know well cron job for Linux platform I can do this and wont make you dissapointed. Let's chat Thanks

$140 USD in 7 days
(5 Reviews)

Soy un desarrollador de Python. Estoy muy interesado en tu proyecto. Estoy seguro de que daré el mejor resultado.

$350 USD in 7 days
(7 Reviews)

Hi my Professional Aim is: (Services then Solutions then Satisfactions) I hope you are [login to view URL] an experience in this field from last 5 years i am sure i can do it perfectly with in a time and budget Able to deliver y More

$30 USD in 7 days
(3 Reviews)

Hello, dear. I am Python expert and I can manage data grouping and aggregation using Python. I wanna contact and discuss over chat. Best regards.

$99 USD in 3 days
(3 Reviews)

How are you. Thank you for looking at my bid! I will my best to deliver only perfectly results. I can finish successfully it if you would provide your project to me. I have a lot of experience for Paython, [login to view URL], Reac More

$100 USD in 7 days
(2 Reviews)

Hi. Dear. Your job posting has caught my attention. I have an expertise in Python and Python Frameworks such as Flask,Django. I have many experiences in python, tkinter, django. I can complete your project successfully More

$250 USD in 7 days
(1 Review)

Hi, I have read all of your requirement. I can do this job and deliver it punctually. I am professional virtual assistant. I have a lot of experienced working as personal assistant for a few companies. I have experie More

$140 USD in 7 days
(0 Reviews)

will be delivering in sometime Relevant Skills and Experience have multiple skill set java oracle sybase python angular etc

$155 USD in 3 days
(0 Reviews)

Hi, sir. Thank you for your posting project. I am a Python expert with 7+ years of experience. I have checked your project and I am very interested in your proejct. In past I have implemented the proejct of Data Mining More

$50 USD in 2 days
(0 Reviews)

Hello, Sir I've read your project carefully and I am so interested in it. Your specification seems to be written for me. As a C++, C#, Java, Python expert, I am very proud of my skills and I have rich experience in the More

$140 USD in 7 days
(0 Reviews)
$155 USD in 3 days
(0 Reviews)

Sir, If you give us the opportunity to work for you, We will give you 100% result. I am IBM certified python expert. with both conceptual as well as practical knowledge. How to read the problem and execute the solution More

$30 USD in 1 day
(0 Reviews)

Hi, this is an interesting task which involved programming skill and a good attitude on algorithm. I would like to have the opportunity to work on this task.

$110 USD in 2 days
(0 Reviews)