How to take a difference within the data of the same city but not across the city, Part 3

4 visualizzazioni (ultimi 30 giorni)
I have a table
City Date Cumulative_Visitors
-----------------------
NY January 1 100
NY January 2 150
NY January 3 200
SF January 1 70
SF January 2 200
SF January 3 400
I explained the problem of calculating the new_visitors.
If I just use "diff", then, it will create a problem at the first entry of each city.
Then the idea is
run diff
then replace the first entry of each city with the cumulative_visitor of that day
How can one write "replace the first entry of each city with the cumulative_visitor of that day"?
  2 Commenti
John D'Errico
John D'Errico il 8 Dic 2020
STOP ASKING THE SAME QUESTOIN REPEATEDLY. While you claim this is different, it is the same thing you asked before.
alpedhuez
alpedhuez il 8 Dic 2020
This is a "different way of solving the same question" that can be applied to other problems. Thus not redundant.

Accedi per commentare.

Risposta accettata

Ameer Hamza
Ameer Hamza il 8 Dic 2020

Più risposte (0)

Tag

Community Treasure Hunt

Find the treasures in MATLAB Central and discover how the community can help you!

Start Hunting!

Translated by