May 2022
Penyewaan sepeda motor matic mio J 115cc
May 2022
Penyewaan sepeda motor matic mio J 115cc
May 2022
Daripada sepedanya jarang menjalani fitrah nya yaitu di tunggangi hehehe
mending di sewakan, biar si sepeda ga bosen di gantung di kamar doang.
transform_avg_rating()
function by grouping by the course_id
column, and taking the mean of the rating
column.extract_rating_data()
to extract raw ratings data. It takes in as argument the database engine db_engines
.Now that you have a grasp of what's happening in the datacamp_application
database, let's go ahead and write up a query for that database.
The goal is to get a feeling for the data in this exercise. You'll get the rating data for three sample users and then use a predefined helper function, print_user_comparison()
, to compare the sets of course ids these users rated.
datacamp_application
. The host is localhost
with port 5432
. The username is repl
and the password is password
.4387
, 18163
and 8770
.print_user_comparison()
with the three users you selected.# Complete the connection URI
Course id overlap between users:
================================ User 1 and User 2 overlap: {32, 96, 36, 6, 7, 44, 95} User 1 and User 3 overlap: set() User 2 and User 3 overlap: set()
In this exercise, you'll complete a transformation function transform_avg_rating()
that aggregates the rating data using the pandas
DataFrame's .groupby()
method. The goal is to get a DataFrame with two columns, a course id and its average rating:
course_id | avg_rating |
---|---|
123 | 4.72 |
111 | 4.62 |
… | … |
In this exercise, you'll complete this transformation function, and apply it on raw rating data extracted via the helper function extract_rating_data()
which extracts course ratings from the rating
table.
transform_avg_rating()
function by grouping by the course_id
column, and taking the mean of the rating
column.extract_rating_data()
to extract raw ratings data. It takes in as argument the database engine db_engines
.transform_avg_rating()
on the raw rating data you've extracted8 Mei 2022
Baru angkat CPU seken, spek nya bener-bener dah dari tahun 2017 di idam-idamkan, budget murah, spek mantap.
Atas rekomendasi dari Ngelag.com https://ngelag.com/rakit-pc-gaming-5-jutaan-amd-2017/
CPU : AMD Vishera FX-6300 (6 Core)Balikpapan, 20 April 2022
Gerah liat speedometer mio J yang ga berfungsi sampai buat indikator di speedometer menyala.
kabel speedometer baru, gearbox speedometer baru. masih tetap ga berfungsi, selidik punya selidik liat velg depannya ternyata tonjolan buat pendorong gearbox speedometer nya patah.
Cari-cari velg seken harga lumayan 200rb an, dan beberapa velg seken yang di temukan kondisi sama, rompal di bagian tonjolan untuk speedometer. keluar uang 200rb untuk resiko yang sama ngapain juga kan ya.
Yauda iseng wiken bawa ke tukang bubut, rencana awal mengikuti saran di youtube yaitu buat drat dan tanam baut, saya analisa kemungkinan besar lebih awet.
Sampai di tukang bubut, Mas Dani namanya, malah nyaranin dibuatkan bushing saja, semacam ring dari besi/baja yang di pasang suaian pas ke velg, karena bahannya besi jadi bisa di las.
BTW saya juga coba tanya ke tempat las argon untuk las velg ini (karena material velg alumunium alloy) mirip dengan bahan blok mesin, jadi harus las argon, biayanya 100-200rb. Hampir seharga velg seken nya.
Back to topic, jadi di tukang bubut dibuatkan bushing dan di las lagi besi tonjolannya, tapi harus ada yang di sesuaikan karena bushing membuat diameter pasangan antara velg dan gearbox speedometer jadi clash, terpaksa gasket yang di gearbox speedometer dilepaskan dan sedikit ada penyesuaian di plastik gearbox nya. Biaya? 50rb aja hhehehe, kayaknya ini malah lebih awet.
Selesai dan speedometer mio J berfungsi lagi. Hepi