2,306
edits
Changes
Jump to navigation
Jump to search
mLine 7:
Line 7: + + + + + + + + + + + + + + + + + + + + + Line 30:
Line 51: − + Line 57:
Line 78: − +
→Read CSV
<syntaxhighlight lang="python3">
<syntaxhighlight lang="python3">
df = pd.read_csv('news_2019.05.10.csv')
df = pd.read_csv('news_2019.05.10.csv')
</syntaxhighlight>
== DataSeries ==
<syntaxhighlight lang="python3">
s = pd.Series(['banana', 42])
s = pd.Series(['banana', 42], index=['Fruit', 'Calories'])
</syntaxhighlight>
</syntaxhighlight>
==Dataframe==
==Dataframe==
=== Create ===
<syntaxhighlight lang="python3">
scientists = pd.DataFrame({
'Name': ['Rosaline Franklin', 'William Gosset'],
'Occupation': ['Chemist', 'Statistician'],
'Born': ['1920-07-25', '1876-06-13'],
'Died': ['1958-04-16', '1937-10-16'],
})
</syntaxhighlight>
=== From CSV ===
<syntaxhighlight lang="python3">
news = pd.read_csv('news_2019.05.10.csv')
</syntaxhighlight>
===Info===
===Info===
</syntaxhighlight>
</syntaxhighlight>
=== Select specific rows ===
===Select specific rows===
<syntaxhighlight lang="python3">
<syntaxhighlight lang="python3">
df.loc[[9, 99, 999]]
df.loc[[9, 99, 999]]
</syntaxhighlight>
</syntaxhighlight>
=== Subset multiple rows and multiple columns ===
===Subset multiple rows and multiple columns===
<syntaxhighlight lang="python3">
<syntaxhighlight lang="python3">
df.iloc[[1,34,56],[2,4,5]]
df.iloc[[1,34,56],[2,4,5]]