Rosdyana Kusuma rosdyana

Tata Cara Mengerjakan Tugas Wajib

Nama Tugas	Jurusan	Semester	Unduh Tugas	Batas Waktu Pengumpulan
Tugas Wajib 1	PGSD	Semester 3	Unduh	2 Hari setelah TUWEB 2
Tugas Wajib 1	PGPAUD	Semester 2	Unduh	2 Hari setelah TUWEB 2
Tugas Wajib 1	PGPAUD	Semester 9	Unduh	2 Hari setelah TUWEB 2

Description of PR that completes issue here...

Screenshot (if available)

Magic words:

psql -U postgres

Some interesting flags (to see all, use -h or --help depending on your psql version):

-E: will describe the underlaying queries of the \ commands (cool for learning!)
-l: psql will list all databases and then exit (useful if the user you connect with doesn't has a default database, like at AWS RDS)

	<?xml version="1.0" encoding="UTF-8"?>
	<feed xmlns="http://www.w3.org/2005/Atom"
	xmlns:g="http://base.google.com/ns/1.0">
	<title>abc : 666</title>
	<link rel="self" href="https://www.abc.com.tw"/>
	<entry>
	<g:id>04070325</g:id>
	<g:availability>available for order</g:availability>
	<g:condition>refurbished</g:condition>
	<g:description><![CDATA[學院風格紋綁帶毛呢後鬆緊褲裙]]></g:description>

	import pandas as pd
	import sys

	CHUNK_SIZE = int(sys.argv[2])
	rows = pd.read_csv(sys.argv[1], chunksize=CHUNK_SIZE)
	for i, chuck in enumerate(rows):
	# i is for chunk number of each iteration
	chuck.to_csv('out{}.csv'.format(i))

	from omnidata.models import *
	from ma_audience.models import *
	from django.db.models import *
	from omnidata.models import Product as d_Product, Organization as d_Organization, Conversion, PageView
	import collections
	from datetime import timedelta


	org = Organization.objects.get(id=1) # Ruby
	d_org = d_Organization.objects.get(id=1)

	from django.db.models import Count, Max, Q
	from django.db.models.functions import Length
	from ma_audience.models import Audience

	unique_fields = ['email']

	duplicates = (
	Audience.objects.filter(Q(organization_id=81), ~Q(email=''), Q(email__isnull=False)).values(*unique_fields)
	.order_by()
	.annotate(max_id=Max('id'), count_id=Count('id'))

	def repeatedString(s, n):
	number = s.count('a')
	if number == 0:
	return 0
	if number == 1 and len(s) == 1:
	return n
	repeats = n//len(s)
	remainder = math.floor(n%len(s))
	return number*repeats+s[:remainder].count('a')

	# from remote to local
	```
	scp [email protected]:/remote/file.txt /local/directory
	```

	# from local to remote
	```
	scp file.txt [email protected]:/remote/directory
	```