How to remove square bracket from pandas dataframe

by

If values in column value have type list, use:

df['value'] = df['value'].str[0]

Or:

df['value'] = df['value'].str.get(0)

Docs.

Sample:

df = pd.DataFrame({'value':[[63],[65],[64]]})
print (df)
  value
0  [63]
1  [65]
2  [64]

#check type if index 0 exist
print (type(df.loc[0, 'value']))
<class 'list'>

#check type generally, index can be `DatetimeIndex`, `FloatIndex`...
print (type(df.loc[df.index[0], 'value']))
<class 'list'>

df['value'] = df['value'].str.get(0)
print (df)
   value
0     63
1     65
2     64

If strings use str.strip and then convert to numeric by astype:

df['value'] = df['value'].str.strip('[]').astype(int)

Sample:

df = pd.DataFrame({'value':['[63]','[65]','[64]']})
print (df)
  value
0  [63]
1  [65]
2  [64]

#check type if index 0 exist
print (type(df.loc[0, 'value']))
<class 'str'>

#check type generally, index can be `DatetimeIndex`, `FloatIndex`...
print (type(df.loc[df.index[0], 'value']))
<class 'str'>


df['value'] = df['value'].str.strip('[]').astype(int)
print (df)
  value
0    63
1    65
2    64

More Related Contents:

  1. Filter pandas DataFrame by substring criteria
  2. How to test if a string contains one of the substrings in a list, in pandas?
  3. Pandas filtering for multiple substrings in series
  4. Remove unwanted parts from strings in a column
  5. String concatenation of two pandas columns
  6. Find column whose name contains a specific string
  7. add a string prefix to each value in a string column using Pandas
  8. pandas dataframe str.contains() AND operation
  9. Pandas DataFrame stored list as string: How to convert back to list
  10. Pandas column access w/column names containing spaces
  11. NLTK-based text processing with pandas
  12. Left justify string values in a pandas DataFrame
  13. Count number of words per row
  14. Converting a column within pandas dataframe from int to string
  15. Capitalize first letter of each word in a dataframe column
  16. How to use str.contains() with multiple expressions in pandas dataframes
  17. Copy text between parentheses in pandas DataFrame column into another column
  18. Convert DataFrame column type from string to datetime
  19. How to convert an XML file to nice pandas dataframe?
  20. df.append() is not appending to the DataFrame
  21. Pandas groupby mean – into a dataframe?
  22. Add Leading Zeros to Strings in Pandas Dataframe
  23. pandas groupby without turning grouped by column into index
  24. Count occurrences of each of certain words in pandas dataframe
  25. removing newlines from messy strings in pandas dataframe cells?
  26. Python/Pandas convert string to time only
  27. pandas: replace string with another string
  28. Anti-Join Pandas
  29. How to convert DataFrame.append() to pandas.concat()?
  30. How to efficiently assign unique ID to individuals with multiple entries based on name in very large df

Leave a Comment