Please enable JavaScript.
Coggle requires JavaScript to display documents.
deleted (numpy (functions (np.loadtxt(filename, skiprows=list,…
deleted
numpy
-
functions
np.loadtxt(filename, skiprows=list, usecols=list,..) = load files of single data type
np.genfromtxt('titanic.csv', delimiter=',', names=True, dtype=None) load files of mixed data type
pandas
data types
-
Dataframe
Methods
index
-
loc - df.loc['row's label'] or df.loc['row's label', 'col name' ] - return seris type
df.loc[[ row label1, row label2], [col name 1, col name 2]] - return df type
[['col name1', 'col name2', ..]] return a Df type
iloc - alike as loc, indexing by integer not labels
df.iloc[row:row, col:col]
-
-
-
instantiation
-
pd.read_csv('file_name.csv, chunksize=10)
-
functions
pd.read_sql_query('SQL QUERY, sqlalchemy engine')
-