# Day 25: 100 Days of Code

### Content Covered

- Reading CSV(comma separated values) data in python
- DataFrames(2D, Tables) and Series(1D, List, Every single column): working with rows and columns(Pandas)

```
import pandas
data = pandas.read_csv("weather_data.csv")
``` 

**Two ways to get data of columns i.e., the condition is a column in a table.**
```
data["condition"] #Dictionary
data.condition #object
``` 
**Get data in row**

```
data[data.day == "Monday"]
data[data.temp == data.temp.max()]
``` 

**Create DataFrame from scratch in pandas**
```
data_dict = {
    "students": ["Amy", "James", "Angela"],
    "scores": [76, 56, 65]
}
data = pandas.DataFrame(data_dict)
print(data)
data.to_csv("new_data.csv")
``` 

### US States Game Project

![Screen Shot 2022-02-20 at 9.17.01 PM.png](https://cdn.hashnode.com/res/hashnode/image/upload/v1645373845510/Hivz9JozD.png)

Also play on [Sporcle](https://www.sporcle.com/games/g/states) 

My code is on [Github](https://github.com/maryambiibii/100DaysOfCode/tree/main/Day25)