Python programming exercises

• Pandas:

  • ReadPlot:

    • Data frame, read csv, data frame properties
    • data frame basic calculations: sum of row
    • add new column, delte
    • query using index, condition
    • sort
    • plot histogram, kde, plot
    • clean data- remove NaN, fill NaN
    • write results to a new file

  • Dict

    • read txt, select columns to read
    • rename column using dictionary
    • check row,column count, data types
    • Add new colum and calculate
    • Parse date string using str.slice or datetiem
    • Group data using groupby, access groups
    • Calculate mean, sum for grouped data
    • create new dataframe with grouped data