Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- # Load the files using pandas
- import pandas as pd
- df = pd.read_csv("/Users/serafeim/Downloads/Testfile.csv")
- # Get the desired elements based on 'Time' column
- mask = df['Time'] < 0.1
- # Write the new file
- df_1 = df[mask] # or directly use: df_1 = df[df['Time'] < 0.1]
- # save it
- df_1.to_csv("Testfile1.csv")
- print(df_1)
- No. Time Length
- 0 1 0.000000 146
- 1 2 0.006752 116
- 2 3 0.019767 156
- 3 4 0.039635 144
- 4 5 0.060090 147
- 5 6 0.069165 138
- 6 7 0.079700 133
- 7 8 0.099397 135
- #For 0.1 to 0.2 applying 2 logical conditions
- df_2 = df[(df['Time'] > 0.1) & (df['Time'] < 0.2)]
- import pandas as pd
- lower = [0,0.1,0.3]
- upper = [0.1,0.2,0.4]
- df = pd.read_csv("/Users/serafeim/Downloads/Testfile.csv")
- for k,(i,j) in enumerate(zip(lower,upper)):
- # i and j will get the lower and upper values
- temp = df[(df['Time'] > i) & (df['Time'] < j)]
- temp.to_csv("/Users/serafeim/Downloads/aaa_{}".format(k))
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement