Why converting time to index in pandas dataframe?

  • #1
fog37
1,549
107
Hello,
When dealing with a dataframe with two columns, X and T where T is time, the time column is often converted to be the index of the dataframe itself (which by default is 0,1,2,3,...). What is the advantage of doing that? I know how to implement that but I am not sure what the main benefit is...

Thank you!
 
Computer science news on Phys.org
  • #2
fog37 said:
Hello,
When dealing with a dataframe with two columns, X and T where T is time, the time column is often converted to be the index of the dataframe itself (which by default is 0,1,2,3,...). What is the advantage of doing that? I know how to implement that but I am not sure what the main benefit is...

Thank you!
IF the time step is a constant, ##\delta t##, then the times can be converted into a time step index. That is the way a time series is usually represented. In the usual time series analysis, the magnitude of the time step is not used in the analysis, as long as it is constant.
 
Last edited:
  • Like
Likes fog37

Similar threads

I Looking for the most suitable distance for binary clustering
    • Set Theory, Logic, Probability, Statistics
Replies
1
Views
381
I Why is Cherenkov radiation blue? And what about refractive index?
    • Classical Physics
Replies
3
Views
724
Converting Voltage into Pressure
    • Introductory Physics Homework Help
Replies
24
Views
1K
I Time series and why would we remove seasonality and trend?
    • Set Theory, Logic, Probability, Statistics
Replies
10
Views
739
A Index-Free Expressions & Unique Metric-Compatible Connections
    • Special and General Relativity
Replies
1
Views
621
Understanding DRAM Refresh Operations
    • Computing and Technology
Replies
14
Views
3K
B Array Representation Of A General Tensor Question
    • Linear and Abstract Algebra
Replies
2
Views
870
I Can time be another basis vector under Galilean relativity?
    • Special and General Relativity
5
Replies
146
Views
5K
Relating acceleration to distance and time
    • Introductory Physics Homework Help
Replies
5
Views
951
Help with Debugging a Program Using reinterpret_cast
    • Programming and Computer Science
Replies
32
Views
2K

Hot Threads

Recent Insights

Back
Top