Guest User

Untitled

a guest
Nov 18th, 2017
93
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 1.30 KB | None | 0 0
  1. def missing_values(dataFrame):
  2. """function returns the percent rate of null values in given DataFrame"""
  3. missing_data = dataFrame.isnull().sum() * 100
  4. missing_data = missing_data.sort_values(ascending = False)
  5. missing_data = pd.DataFrame({'missing_rate':missing_data})
  6. return missing_data
  7.  
  8.  
  9. def get_ticks(DataFrame,labels):
  10. """return list of lists corelated with labels.
  11. Each label contain uniq set of ticks which can be use for countplot"""
  12. xticks = []
  13. for i,label in enumerate(df_labels):
  14. values = list(set(DataFrame[label]))
  15. xtick = []
  16. listed_data = list(DataFrame[label])
  17. for value in values:
  18. xtick.append(listed_data.count(value))
  19. xticks.append(list(set(xtick)))
  20. return xticks
  21.  
  22.  
  23. import dateutil.parser
  24.  
  25. def insert_data_columns(dataFrame, nameOfDataColumn):
  26. def getDateTimeFromISO8601String(s):
  27. d = dateutil.parser.parse(s)
  28. return d
  29. dateTimeList = [getDateTimeFromISO8601String(x).date() for x in dataFrame[nameOfDataColumn]]
  30. dataFrame['day'] = pd.Series([x.day for x in dateTimeList])
  31. dataFrame['month'] = pd.Series([x.month for x in dateTimeList])
  32. dataFrame['year'] = pd.Series([x.year for x in dateTimeList])
  33. dataFrame['day_of_week'] = pd.Series([x.weekday() for x in dateTimeList])
Add Comment
Please, Sign In to add comment