$ pip install pandas

import pandas as pd

df = pd.DataFrame({
        'A' : [1, 2, 2, 3, 3, 3, 4, 4, 4, 4, 5, 5, 5, 5, 5, 6, 6, 7, 8, 9, 10],
        'B' : [1, 1, 2, 2, 3, 3, 4, 4, 5, 5, 6, 6, 6, 7, 7, 8, 8, 8, 8, 8, 8]
    })

# CSV
csv_data  = pd.read_csv('./path/to/hoge.csv')

# TSV
tsv_data  = pd.read_csv('./path/to/hoge.csv', delimiter='\t')

data = data[['column1', 'column2']]

data = data[data.column1 == 'hoge']

data = data[data.column1.str.contains(regex)]

df = df.dropna()

df = df.dropna(subset=['Item 1', 'Item 2'])

#In the case of one type
df = df.sort_values(['type of data'])

# 1 ->Sort in ascending order of 2
df = df.sort_values(['Data type 1', 'Data type 2'])

df.rename(columns={'A': 'a'}, index={'ONE': 'one'}, inplace=True)

df = df.reset_index(drop=True)

df = df.astype(float)

df = df.T

df.values.tolist()

# CSV
data.to_csv('./path/to/output.csv')

# TSV
data.to_csv('./path/to/output.csv', sep='\t')

Recommended Posts