Pandas set_index does not set the index

by

set_index is not inplace (unless you pass inplace=True). otherwise all correct

In [7]: df = df.set_index(pd.DatetimeIndex(df['b']))

In [8]: df
Out[8]: 
<class 'pandas.core.frame.DataFrame'>
DatetimeIndex: 100 entries, 2013-06-14 09:10:23.523845 to 2013-06-14 10:12:51.650043
Data columns (total 2 columns):
b    100  non-null values
c    100  non-null values
dtypes: datetime64[ns](1), int64(1)

also as a FYI, in forthcoming 0.12 release (next week),
you can pass unit=us to specify units of microseconds since epoch

In [13]: pd.to_datetime(a,unit="us")
Out[13]: 
<class 'pandas.tseries.index.DatetimeIndex'>
[2013-06-14 13:10:23.523845, ..., 2013-06-14 14:12:51.650043]
Length: 100, Freq: None, Timezone: None

More Related Contents:

  1. converting a text file to csv file with out index
  2. pandas: How do I split text in a column into multiple rows?
  3. Find row where values for column is maximal in a pandas DataFrame
  4. Fast Haversine Approximation (Python/Pandas)
  5. How can I filter lines on load in Pandas read_csv function?
  6. Pandas Groupby Range of Values
  7. Drop rows containing empty cells from a pandas DataFrame
  8. How to form tuple column from two columns in Pandas
  9. Convert pandas Series to DataFrame
  10. Pandas selecting by label sometimes return Series, sometimes returns DataFrame
  11. Pandas: resample timeseries with groupby
  12. Pandas groupby.size vs series.value_counts vs collections.Counter with multiple series
  13. How to keep leading zeros in a column when reading CSV with Pandas?
  14. Comparing two pandas dataframes for differences
  15. Read XLSB File in Pandas Python
  16. Remove name, dtype from pandas output of dataframe or series
  17. Export pandas Styled table to image file
  18. pandas – find first occurrence
  19. changing all dates to standard date time in dataframe
  20. Showing all index values when using multiIndexing in Pandas
  21. Python: Pandas Dataframe how to multiply entire column with a scalar
  22. Read CSV into a dataFrame with varying row lengths using Pandas
  23. Vectorizing or Speeding up Fuzzywuzzy String Matching on PANDAS Column
  24. Count occurrences of items in Series in each row of a DataFrame
  25. Column of lists, convert list to string as a new column
  26. Getting days since last occurence in Pandas DataFrame?
  27. How to delete the last row of data of a pandas dataframe
  28. Add column in dataframe from list
  29. Pandas update sql
  30. Round float columns in pandas dataframe

Leave a Comment