Visual Python Manual
  • Visual Python Manual
  • GETTING STARTED
    • Welcome to Visual Python
    • How to install
    • Installing FAQ
    • Official homepage
    • Link to Github
  • Data Analysis
    • 1. Import
    • 2. File
    • 3. Data Info
    • 4. Frame
      • 4-1. Frame - Edit
      • 4-2. Frame - Transform
      • 4-3. Frame - Sort
      • 4-4. Frame - Encoding
      • 4-5. Frame - Data Cleaning
    • 5. Subset
    • 6. Groupby
    • 7. Bind
    • 8. Reshape
  • Visualization
    • 1. Chart Style
    • 2. Pandas Plot
    • 3. Matplotlib
    • 4. Seaborn
    • 5. Plotly
    • 6. WordCloud
  • Statistics
    • 1. Prob. Distribution
    • 2. Descriptive Statistics
    • 3. Normality Test
    • 4. Equal Var. Test
    • 5. Correlation Analysis
    • 6. Reliability Analysis
    • 7. Chi-square Test
    • 8. Student's T-test
    • 9. ANOVA
    • 10. Factor Analysis
    • 11. Regression
    • 12. Logistic Regression
  • Machine Learning
    • 1. Data Sets
    • 2. Data Split
    • 3. Data Prep
    • 4. AutoML
    • 5. Regressor
    • 6. Classifier
    • 7. Clustering
    • 8. Dimension
    • 9. GridSearch
    • 10. Fit/Predict
    • 11. Model Info
    • 12. Evaluation
    • 13. Pipeline
    • 14. Save / Load
Powered by GitBook
On this page
  1. Data Analysis
  2. 4. Frame

4-2. Frame - Transform

Previous4-1. Frame - EditNext4-3. Frame - Sort

Last updated 8 months ago

  1. Set index: Set the selected column as the index.

  2. Reset index: Converts the index back to a column.

  3. Data shift: Shifts the data in the selected column up or down.

Data Shift

  1. Periods: Set the amount by which you want to move the data. Use a positive value to move it down, and a negative value to move it up.

  2. Set the units for the values entered in Frequency. If it's not time data, omit this setting.

    1. (Ex) Periods: 3, Frequency: minute -> Move down by 3 minutes

    2. (Ex) Periods: 3, Frequency: X -> Move down 3 spaces

  3. Fill value: Enter a value to fill the empty space created by moving the data.