Introduction
This lab will guide you through handling time series data using the Python package, Pandas. We will be working with air quality data for this tutorial. You will learn how to convert strings into datetime objects, perform operations on these datetime objects, resample time series to another frequency, and more.
VM Tips
After the VM startup is done, click the top left corner to switch to the Notebook tab to access Jupyter Notebook for practice.
Sometimes, you may need to wait a few seconds for Jupyter Notebook to finish loading. The validation of operations cannot be automated because of limitations in Jupyter Notebook.
If you face issues during learning, feel free to ask Labby. Provide feedback after the session, and we will promptly resolve the problem for you.
Skills Graph
%%%%{init: {'theme':'neutral'}}%%%%
flowchart RL
python(("`Python`")) -.-> python/BasicConceptsGroup(["`Basic Concepts`"])
pandas(("`Pandas`")) -.-> pandas/ReadingDataGroup(["`Reading Data`"])
pandas(("`Pandas`")) -.-> pandas/DataSelectionGroup(["`Data Selection`"])
pandas(("`Pandas`")) -.-> pandas/DataAnalysisGroup(["`Data Analysis`"])
pandas(("`Pandas`")) -.-> pandas/DataVisualizationGroup(["`Data Visualization`"])
pandas(("`Pandas`")) -.-> pandas/AdvancedOperationsGroup(["`Advanced Operations`"])
python(("`Python`")) -.-> python/ControlFlowGroup(["`Control Flow`"])
python(("`Python`")) -.-> python/DataStructuresGroup(["`Data Structures`"])
python(("`Python`")) -.-> python/ModulesandPackagesGroup(["`Modules and Packages`"])
python(("`Python`")) -.-> python/PythonStandardLibraryGroup(["`Python Standard Library`"])
python(("`Python`")) -.-> python/DataScienceandMachineLearningGroup(["`Data Science and Machine Learning`"])
python(("`Python`")) -.-> python/FunctionsGroup(["`Functions`"])
python/BasicConceptsGroup -.-> python/comments("`Comments`")
pandas/ReadingDataGroup -.-> pandas/read_csv("`Read CSV`")
pandas/DataSelectionGroup -.-> pandas/select_columns("`Select Columns`")
pandas/DataSelectionGroup -.-> pandas/conditional_selection("`Conditional Selection`")
pandas/DataAnalysisGroup -.-> pandas/basic_statistics("`Basic Statistics`")
pandas/DataAnalysisGroup -.-> pandas/groupby_operations("`GroupBy Operations`")
pandas/DataVisualizationGroup -.-> pandas/bar_plots("`Bar Plots`")
pandas/DataVisualizationGroup -.-> pandas/line_plots("`Line Plots`")
pandas/AdvancedOperationsGroup -.-> pandas/time_series_analysis("`Time Series Analysis`")
pandas/AdvancedOperationsGroup -.-> pandas/reshape_data("`Reshaping Data`")
python/ControlFlowGroup -.-> python/for_loops("`For Loops`")
python/DataStructuresGroup -.-> python/lists("`Lists`")
python/DataStructuresGroup -.-> python/tuples("`Tuples`")
python/DataStructuresGroup -.-> python/dictionaries("`Dictionaries`")
python/ModulesandPackagesGroup -.-> python/importing_modules("`Importing Modules`")
python/ModulesandPackagesGroup -.-> python/standard_libraries("`Common Standard Libraries`")
python/PythonStandardLibraryGroup -.-> python/date_time("`Date and Time`")
python/DataScienceandMachineLearningGroup -.-> python/numerical_computing("`Numerical Computing`")
python/DataScienceandMachineLearningGroup -.-> python/data_analysis("`Data Analysis`")
python/DataScienceandMachineLearningGroup -.-> python/data_visualization("`Data Visualization`")
python/FunctionsGroup -.-> python/build_in_functions("`Build-in Functions`")
subgraph Lab Skills
python/comments -.-> lab-65438{{"`Handling Time Series Data`"}}
pandas/read_csv -.-> lab-65438{{"`Handling Time Series Data`"}}
pandas/select_columns -.-> lab-65438{{"`Handling Time Series Data`"}}
pandas/conditional_selection -.-> lab-65438{{"`Handling Time Series Data`"}}
pandas/basic_statistics -.-> lab-65438{{"`Handling Time Series Data`"}}
pandas/groupby_operations -.-> lab-65438{{"`Handling Time Series Data`"}}
pandas/bar_plots -.-> lab-65438{{"`Handling Time Series Data`"}}
pandas/line_plots -.-> lab-65438{{"`Handling Time Series Data`"}}
pandas/time_series_analysis -.-> lab-65438{{"`Handling Time Series Data`"}}
pandas/reshape_data -.-> lab-65438{{"`Handling Time Series Data`"}}
python/for_loops -.-> lab-65438{{"`Handling Time Series Data`"}}
python/lists -.-> lab-65438{{"`Handling Time Series Data`"}}
python/tuples -.-> lab-65438{{"`Handling Time Series Data`"}}
python/dictionaries -.-> lab-65438{{"`Handling Time Series Data`"}}
python/importing_modules -.-> lab-65438{{"`Handling Time Series Data`"}}
python/standard_libraries -.-> lab-65438{{"`Handling Time Series Data`"}}
python/date_time -.-> lab-65438{{"`Handling Time Series Data`"}}
python/numerical_computing -.-> lab-65438{{"`Handling Time Series Data`"}}
python/data_analysis -.-> lab-65438{{"`Handling Time Series Data`"}}
python/data_visualization -.-> lab-65438{{"`Handling Time Series Data`"}}
python/build_in_functions -.-> lab-65438{{"`Handling Time Series Data`"}}
end