Pandas: Adding new column to dataframe which is a copy of the index column

by

I think you need reset_index:

df3 = df3.reset_index()

Possible solution, but I think inplace is not good practice, check this and this:

df3.reset_index(inplace=True)

But if you need new column, use:

df3['new'] = df3.index

I think you can read_csv better:

df = pd.read_csv('university2.csv', 
                 sep=";", 
                 skiprows=1,
                 index_col="YYYY-MO-DD HH-MI-SS_SSS",
                 parse_dates="YYYY-MO-DD HH-MI-SS_SSS") #if doesnt work, use pd.to_datetime

And then omit:

#Changing datetime
df['YYYY-MO-DD HH-MI-SS_SSS'] = pd.to_datetime(df['YYYY-MO-DD HH-MI-SS_SSS'], 
                                               format="%Y-%m-%d %H:%M:%S:%f")
#Set index from column
df = df.set_index('YYYY-MO-DD HH-MI-SS_SSS')

More Related Contents:

  1. Annotate bars with values on Pandas bar plots
  2. Python matplotlib multiple bars
  3. How to plot multiple Seaborn Jointplot in Subplot
  4. Add x and y labels to a pandas plot
  5. Plot different DataFrames in the same figure
  6. Setting Different Bar color in matplotlib Python [duplicate]
  7. How to plot multiple dataframes in subplots
  8. Reset color cycle in Matplotlib
  9. Scatter plot form dataframe with index on x-axis
  10. Problem in combining bar plot and line plot (python)
  11. Seaborn: countplot() with frequencies
  12. Bar Chart: How to choose color if value is positive vs value is negative
  13. How to plot stacked event duration (Gantt Charts)
  14. How to show a bar and line graph on the same plot
  15. pandas .plot() x-axis tick frequency — how can I show more ticks?
  16. Python pandas / matplotlib annotating labels above bar chart columns [duplicate]
  17. How to plot multiple dataframes to the same plot axes
  18. How can I group a stacked bar chart?
  19. Plotting a stacked Bar Chart
  20. How to add multiple annotations to a bar plot
  21. ValueError: view limit minimum -35738.3640567 is less than 1 and is an invalid Matplotlib date value
  22. Plot the x-axis as a date
  23. Pandas Plotting Display all date values on x-axis (matplolib only displays few values) formatted as MMM-YYYY [duplicate]
  24. How to rotate x-axis tick labels in a pandas plot
  25. Getting vertical gridlines to appear in line plot in matplotlib
  26. plotting a histogram on a Log scale with Matplotlib
  27. Changing width of bars in bar chart created using seaborn.factorplot
  28. Plot two levels of x_ticklabels on a pandas multi-index dataframe [duplicate]
  29. pandas plot value counts barplot in descending manner [duplicate]
  30. How to create a scatter plot by category [duplicate]

Leave a Comment