Add-A-New-Column-1

Sat 17 May 2025

Add a New Column

import pandas as pd
data = {
    'city' : ['Toronto', 'Montreal', 'Waterloo'],
    'points' : [80, 70, 90]
}
data
{'city': ['Toronto', 'Montreal', 'Waterloo'], 'points': [80, 70, 90]}
type(data)
dict
df = pd.DataFrame(data)
df
city points
0 Toronto 80
1 Montreal 70
2 Waterloo 90
df = df.assign(code = [1, 2, 3])
df
city points code
0 Toronto 80 1
1 Montreal 70 2
2 Waterloo 90 3


Score: 10

Category: pandas


Apply-Custom-Lamdba-Function

Sat 17 May 2025
import numpy as np
import pandas as pd
data = {
    'city' : ['Toronto', 'Montreal', 'Waterloo'],
    'points' : [80, 70, 90]
}
data
{'city': ['Toronto', 'Montreal', 'Waterloo'], 'points': [80, 70, 90]}
type(data)
dict
df = pd.DataFrame(data)
df

Category: pandas

Read More

Apply-Function

Sat 17 May 2025
import pandas as pd
data = {
    'city' : ['Toronto', 'Montreal', 'Waterloo', 'Toronto', 'Waterloo', 'Toronto', 'Toronto'],
    'points' : [80, 70, 90, 85, 79, 82, 200]
}
data
{'city': ['Toronto',
  'Montreal',
  'Waterloo',
  'Toronto',
  'Waterloo',
  'Toronto',
  'Toronto'],
 'points': [80, 70, 90, 85, 79, 82, 200]}
type(data)
dict
df = pd.DataFrame(data)
df

Category: pandas

Read More

Bollinger-Bands

Sat 17 May 2025

# !pip install pandas_datareader
import pyutil as pyu
pyu.get_local_pyinfo()
'conda env: ml312-2024; pyv: 3.12.7 | packaged by Anaconda, Inc. | (main, Oct  4 2024, 13:27:36) [GCC 11.2.0]'
print(pyu.ps2("pandas"))
pandas==2.2.3

import yfinance as yf
import pandas as pd
import matplotlib …

Category: pandas

Read More

Categorical-To-Neumerical

Sat 17 May 2025
import numpy as np
import pandas as pd
data = {
    'sam' : ['archery', 'badminton', 'athletics', 'cycling_road', 'canoe_sprint', 'boxing'],
    'medal' : ['gold', 'silver', 'bronze', 'gold', 'gold', 'silver']
}
df = pd.DataFrame(data)
df
sam medal
0 archery …

Category: pandas

Read More

Col Match

Sat 17 May 2025

import pyutil as pyu
pyu.get_local_pyinfo()
'conda env: ml311; pyv: 3.11.10 (main, Oct  3 2024, 07:29:13) [GCC 11.2.0]'
print(pyu.ps2("haystack-ai ollama-haystack python-dotenv"))
haystack-ai==2.8.0
ollama-haystack is not installed in the current environment.
python-dotenv==0.21.0

import pandas as pd …

Category: pandas

Read More

Correlation-1

Sat 17 May 2025

import pyutil as pyu
pyu.get_local_pyinfo()
'conda env: ml312-2024; pyv: 3.12.7 | packaged by Anaconda, Inc. | (main, Oct  4 2024, 13:27:36) [GCC 11.2.0]'
print(pyu.ps2("pandas"))
pandas==2.2.3

import pandas as pd
import numpy as np
def histogram_intersection(a, b):
    v …

Category: pandas

Read More

Csv-Monitor

Sat 17 May 2025

import pyutil as pyu
pyu.get_local_pyinfo()
'conda env: ml311; pyv: 3.11.10 (main, Oct  3 2024, 07:29:13) [GCC 11.2.0]'
print(pyu.ps2("haystack-ai ollama-haystack python-dotenv"))
haystack-ai==2.8.0
ollama-haystack is not installed in the current environment.
python-dotenv==0.21.0

import pandas as pd …

Category: pandas

Read More

Csv-To-Dataframe-9844

Sat 17 May 2025
import numpy as np
import pandas as pd
df = pd.read_csv('https://s3-eu-west-1.amazonaws.com/shanebucket/downloads/uk-500.csv')
df
first_name last_name company_name address city county postal phone1 phone2 email web
0 …

Category: pandas

Read More

Data-2-Csv-Xlsx

Sat 17 May 2025

import pyutil as pyu
pyu.get_local_pyinfo()
'conda env: ml312-2024; pyv: 3.12.7 | packaged by Anaconda, Inc. | (main, Oct  4 2024, 13:27:36) [GCC 11.2.0]'
print(pyu.ps2("pandas faker"))
pandas==2.2.3
faker==33.1.0

from faker import Faker
import pandas as pd …

Category: pandas

Read More
Page 1 of 2

Next »