Pandas codebase¶
global settings¶
pd.set_option('display.max_colwidth', None) # see whole width dataframe
select columns¶
df = df[["a","b"]]
create dataframe¶
d = {'col1': [1, 2], 'col2': [3, 4]}
df = pd.DataFrame(data=d)
merge¶
frames = [d1,d2,d3,d4,d5,d6]
frames = pd.concat(frames)
add column¶
df.insert(2, "Age", [21, 23, 24, 21], True)
del column¶
del df['column_name']
df = df.drop(df.columns[[0, 1, 3]], axis=1) # df.columns is zero-based pd.Index
df.drop('column_name', axis=1, inplace=True)
to csv¶
frames.to_csv("french/french_results_bert.csv")
filter row¶
df_bert[(df_bert["response1"] == 0) | (df_bert["response2"] == 0)]
convert column NAMES to uppercase¶
df.columns = [col.upper() for col in df.columns]
df['name'] = df['name'].map(lambda name: name.upper())
first row¶
df_bert.iloc[0]