|
Size: 1021
Comment:
|
Size: 1025
Comment:
|
| Deletions are marked like this. | Additions are marked like this. |
| Line 30: | Line 30: |
| }} | }}} |
| Line 36: | Line 36: |
| }} | }}} |
| Line 40: | Line 40: |
| == Renaming Columns == | == Renaming Columns1 == |
| Line 44: | Line 44: |
| }} | }}} |
Contents
Description
Pandas is a fast, powerful, flexible and easy to use open source data analysis and manipulation tool, built on top of the Python programming language.
Snippets
Standard import
Toggle line numbers
1 import numpy as np
2 import pandas as pd
Read CSV file
Toggle line numbers
1 path = '/path/to/file(s)'
2 df = pd.read_csv(path + 'name.csv', sep=';', header=0, dtype={'Force String Column': str},
3 parse_dates=['Date Column'] encoding='utf-8')
Renaming Columns
Toggle line numbers
1 dt.rename(columns={'File column name 1': 'Column1', 'File column name 2': '2'}, inplace=True)
Do Y for each value in column X
Toggle line numbers
1 df.loc[:, ['X']] = df.loc[:, ['X']].apply(lambda x: x.Y)
Renaming Columns1
Toggle line numbers
1 dt.rename(columns={'File column name 1': 'Column1', 'File column name 2': '2'}, inplace=True)