notebook.community

Edit and run



In [11]:

    
import pandas as pd



In [ ]:

    
name



In [6]:

    
df = pd.read_csv("/Users/calex/Downloads/Checking1.csv", name['date', 'amt',=None)



In [7]:

    
df.head()









    Out[7]:







  
    
      
      0
      1
      2
      3
      4
    
  
  
    
      0
      10/12/2018
      -64.04
      *
      NaN
      PURCHASE AUTHORIZED ON 10/10 AMZN Mktp US*MT5V...
    
    
      1
      10/12/2018
      -6.48
      *
      NaN
      PURCHASE AUTHORIZED ON 10/10 AMZN Mktp US*MT68...
    
    
      2
      10/12/2018
      -5.55
      *
      NaN
      PURCHASE AUTHORIZED ON 10/10 AMZN Mktp US*MT87...
    
    
      3
      10/12/2018
      4698.52
      *
      NaN
      AMERICREDIT DIRECT DEP 181012 941607572332VDT ...
    
    
      4
      10/12/2018
      23.44
      *
      NaN
      YMCA of Metropol Payroll 000101 IMM00000336542...



In [10]:

    
df.filter( == "10/12/2018")









    



  File "<ipython-input-10-d41bed48ce61>", line 1
    df.filter(df.1 == "10/12/2018")
                 ^
SyntaxError: invalid syntax



In [ ]:



In [ ]:



In [ ]:

	0	1	2	3	4
0	10/12/2018	-64.04	*	NaN	PURCHASE AUTHORIZED ON 10/10 AMZN Mktp US*MT5V...
1	10/12/2018	-6.48	*	NaN	PURCHASE AUTHORIZED ON 10/10 AMZN Mktp US*MT68...
2	10/12/2018	-5.55	*	NaN	PURCHASE AUTHORIZED ON 10/10 AMZN Mktp US*MT87...
3	10/12/2018	4698.52	*	NaN	AMERICREDIT DIRECT DEP 181012 941607572332VDT ...
4	10/12/2018	23.44	*	NaN	YMCA of Metropol Payroll 000101 IMM00000336542...